Returns details of discounted transactions during the specified date range.
GetTransactionDiscountsByDate(StartDate AS Date, EndDate AS Date, IncludeVoided AS Boolean)
XML String
StartDate = Start date for the records to return.
EndDate = End date for the records to return.
IncludeVoided = Select to include voided transactions in the results.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iTransactionId |
Integer |
4 |
Transaction Id. |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used. |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Unique identifier for each transaction. |
|
cDiscType |
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, indicating that the item was sold as part of a package/series. E = Employee discount. |
|
nPercent |
Percent |
6,2 |
Indicates percentage discount on the full sales price. |
|
nDiscAmount |
Decimal |
8 |
Indicates the dollar amount discounted. |
|
nLineNo |
Decimal |
4 |
Item line number. |
|
iCoupId |
Integer |
4 |
Coupon Id. |
|
mNote |
String |
|
Discount note. |
|
iGId |
Integer |
4 |
Transaction Header Global Id. |
|
nQuantity |
Decimal |
7,2 |
Quantity sold. |
|
lFullCommission |
Boolean |
1 |
Indicates whether the employee was paid commission on the full price of the item sold. |