GetProductSales()

Returns details of the products sold during the specified date range.

XML String

XML String has the following structure:

Field	Type	Length	Description
cProductCode	String	10	Product code.
cProductDescription	String	40	Product description.
tDateTime	DateTime	8	Transaction date/time.
nDrawerId	Decimal	2	Drawer Id.
iTransDetailId	Integer	4	Transaction Detail Id.
iHeaderId	Integer	4	Transaction Header Id. Unique identifier for each transaction.
cInvoiceNo	String	12	Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.)
iItemId	Integer	4	Product Id. Foreign Key to Products iId.
iEmpId	Integer	4	Employee Id. Foreign Key to Employee iId.
iClientId	Integer	4	Client Id. Foreign Key to Client iId.
iApptType	Integer	4	Appointment Type Id. Foreign Key to Appointment Type iId.
nPrice	Decimal	8	Product price (includes any discounts or price changes).
nQuantity	Decimal	7,2	Quantity sold.
cDiscount	String	5	Discount type given. % = Percentage off discount $ = Fixed dollar off or a spread discount C = Coupon discount S = Special price or a price override P = Package discount E = Employee discount
nEmpCharge	Decimal	8	Employee charge for product.
nHouseCharge	Decimal	8	House charge for product.
lPreBook	Boolean	1	Indicates whether the client received a prebook discount.
lOnline	Boolean	1	Indicates whether the client received an Online Booking discount.
lRefund	Boolean	1	Indicates whether the line item is a refund.
lTaxable	Boolean	1	Indicates if the product is taxable.
lGST	Boolean	1	Indicates if GST tax applies on this transaction.
lPST	Boolean	1	Indicates if PST tax applies on this transaction.
lPackageId	Integer	4	Package Id.