GetProduct()

Description

Returns a product object you can use to update that product.

GetProduct(ProductId AS Number)

Return Value

Object

Parameters

ProductId = Search string for product search.

Remarks

Object has the following structure:

Field	Type	Length	Description
iId	Integer	4	Primary Key - Unique Identifier.
dDateDeleted	DateTime	8	Date deleted.
iGlobalId	Integer	4	Product Global Id.
eObjectState	Enumeration	1	Indicates the status of the object. -1 = Unchanged 0 = New/Added 1 = Changed 2 = Deleted
cProductCode	String	10	Product code.
cDistributorCode	String	14	Distributor's Product Id.
nProductType	Decimal	1,0	Indicates the type of product. 1 = Retail 2 = Professional Supply
iProductClassId	Integer	4	Foreign Key to Product Sub Class iId.
cUpcCode	String	14	Product UPC code.
lIsMultiProductPackage	Boolean	1	Indicates whether the product is part of a multi-product package.
iManufacturerId	Integer	4	Foreign Key to Manufacturer iId.
iDistributorId	Integer	4	Foreign Key to Distributor iId.
cDescription	String	60	Product description.
cSize	String	8	Product size.
nWholesalePrice	Decimal	8	Wholesale price.
nRetailPrice	Decimal	8	Retail price.
nEmployeeCost	Decimal	8	Employee cost.
iOnHandCount	Integer	4	Quantity on hand.
iOrderPoint	Integer	4	Order point.
iModelQty	Integer	4	Model quantity.
iOrderInMultiplesOfQty	Integer	4	Recommended order quantity.
lPreTaxed	Boolean	1	Indicates whether the distributor charges tax on the product.
dLastOrderDate	DateTime	8	Date last ordered.
dLastReceivedDate	DateTime	8	Date last delivered.
dLastCountDate	DateTime	8	Date last counted.
dLastSaleDate	DateTime	8	Date last sold.
cNotes	String		Product notes.
lShowNotes	Boolean	1	Indicates whether the product notes display when selling the product.
lIsOnSale	Boolean	1	Indicates whether the product is on sale.
nOnSalePrice	Decimal	8	Sale price.
dOnSaleStartDate	DateTime	8	Sale start date.
dOnSaleEndDate	DateTime	8	Sale end date.
dDateCreated	DateTime	8	Date added to Millennium.
lIsNonTaxable	Boolean	1	Indicates whether the product is taxable.
llIgnoreDiscounts	Boolean	1	Indicates whether clients can receive discounts on the product.
lIsDiscontinued	Boolean	1	Indicates whether the product is marked discontinued.
nNextTime	Decimal	3,0	Indicates how often clients should purchase the product.
lPreLabeledFlag	Boolean	1	Indicates whether the distributor labels the product.
lHasCommissionOverride	Boolean	1	Indicates whether the product has a commission override.
nCommissionOverrideAmount	Decimal	8	Commission override (dollar amount or percentage).
cCommissionOverrideType	String	8	Commission override type. $ = Fixed dollar commission % = Percentage commission
nSpiffAmount	Decimal	8	Spiff Amount.
cSpiffType	String	1	Spiff Type. $ = Fixed dollar spiff % = Percentage spiff
dSpiffStartDate	DateTime	8	Spiff start date.
dSpiffEndDate	DateTime	8	Spiff end date.
iQuantityInCase	Integer	4	Quantity in each case.
lAllowPoints	Boolean	1	Indicates whether points can be associated with this product.