GetProductInfoByCode()

Description

Returns detailed product information based on the product code entered.

GetProductInfoByCode(Code AS String, IncludeDeleted AS Boolean, IncludeDiscontinued AS Boolean)

Return Value

XML String

Parameters

Code = Search string for product code.
IncludeDeleted = Select to include deleted records in the results.
IncludeDiscontinued = Select to include discontinued product records in the results.

Remarks

XML String has the following structure:

Field	Type	Length	Description
iId	Integer	4	Primary Key - Unique Identifier.
iLocationId	Integer	4	Not used.
cCode	String	10	Product code
cDistCode	String	14	Distributor's Product Id.
nProdType	Decimal	1,0	Indicates the type of product. 1 = Retail 2 = Professional Supply
iClassId	Integer	4	Foreign Key to Product Sub Class iId.
cUpcCode	String	14	Product UPC code.
lMulti	Boolean	1	Indicates whether the product is part of a multi-product package.
iManufId	Integer	4	Foreign Key to Manufacturer iId.
iDistribId	Integer	4	Foreign Key to Distributor iId.
cDescript	String	60	Product description.
cSize	String	8	Product size.
nWholeSale	Decimal	8	Wholesale cost.
nRetail	Decimal	8	Retail price.
nMarkUp	Decimal	8	% mark-up over wholesale cost.
nEmpCost	Decimal	8	Employee cost.
nOnHand	Integer	4	Quantity on hand count.
nOrderFlag	Integer	4	Order point.
nModelQty	Integer	4	Model quantity.
nOrderMultiplier	Integer	4	Order in multiples.
lPreTaxed	Boolean	1	Indicates whether the distributor charges tax on the product.
dLastOrder	DateTime	8	Date last ordered.
dLastRecv	DateTime	8	Date last received.
dLastCount	DateTime	8	Date last counted.
dLastSale	DateTime	8	Date last sold.
mNotes	String		Product notes.
lShowNotes	Boolean	1	Indicates whether the product notes display when selling the product.
lSale	Boolean	1	Indicates whether the product is on sale.
nSalePrice	Decimal	8	Sale price.
dSaleStart	DateTime	8	Sale start date.
dSaleEnd	DateTime	8	Sale end date.
dCreated	DateTime	8	Date added to Millennium.
lNonTaxable	Boolean	1	Indicates if the product is taxable.
lIgnoreDiscounts	Boolean	1	Indicates whether clients can receive discounts on the product.
lDisco	Boolean	1	Indicates whether the product is marked discontinued.
nNextTime	Decimal	3,0	Indicates how often clients should purchase the product.
lPreLabeled	Boolean	1	Indicates whether the distributor labels the product.
lOverride	Boolean	1	Indicates whether the product has a commission override.
nOverrideAmount	Decimal	8	Commission override (dollar amount or percentage).
cCommType	String	8	Commission override type. $ = Fixed dollar commission % = Percentage commission
nSpiff	Decimal	8	Spiff Amount.
cSpiffType	String	1	Spiff Type. $ = Fixed dollar spiff % = Percentage spiff
dSpiffStart	DateTime	8	Spiff start date.
dSpiffEnd	DateTime	8	Spiff end date.
dDateDel	DateTime	8	Date deleted.
nCaseQty	Integer	4	Quantity in each case.
iGId	Integer	4	Product Global Id.
lAllowPoints	Boolean	1	Indicates whether clients can earn points for purchasing the product.
lAvailableInCO	Boolean	1	Indicates whether you can order the product from the Central Office warehouse.
tChanged	DateTime	8	Date last updated.
iChgBy	Integer	4	Id of the employee who last updated the product record.
lOverrideTax	Boolean	1	Indicates whether the product uses a tax override.
nPSTOverride	Decimal
nGSTOverride	Decimal
cClassName	String	30	Product class name.
cSubClassName	String	40	Product subclass name.
cManufacturer	String	60	Manufacturer name.
cDistributor	String	60	Distributor name.