Returns a list of the packages/series sold during the specified date range.
GetPackageSeriesSalesListingByDate(XmlLocationIds AS String, 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 records in the results.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
lVoid |
Boolean |
1 |
Indicates whether an employee voided the package/series sale. |
|
tDateTime |
DateTime |
8 |
Date/time of the transaction. |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used. |
|
iPackageId |
Integer |
4 |
Package Id. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Foreign Key to Transaction Header iId. |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
nAmount |
Decimal |
8 |
Sale amount. |
|
dValidFrom |
DateTime |
8 |
Date from which the package/series can be used. |
|
dExpiration |
DateTime |
8 |
Expiration date for the package/series. |
|
iEmpId |
Integer |
4 |
Id of the employee who sold the package/series. |
|
iPurchFor |
Integer |
4 |
Purchased For Client Id. Foreign Key to Client iId. |
|
iPurchBy |
Integer |
4 |
Purchased By Client Id. Foreign Key to Client iId. |
|
cPkgNumber |
String |
20 |
Sequential identifying number assigned to the package. |
|
lSeries |
Boolean |
1 |
Indicates whether the item is a series. |
|
nTip |
Decimal |
8 |
Total prepaid tip for the package/series. |
|
nTipLeft |
Decimal |
8 |
Prepaid tip remaining for the package/series. |
|
iGId |
Integer |
4 |
Global Id of the package/series sales record. |
|
nValue |
Decimal |
8 |
Value of the package/series. |
|
nHouseCharge |
Decimal |
8 |
Total amount of house charges for the services included with the package/series. |
|
iRefById |
Integer |
4 |
Id of the referral source for the client who purchased the package/series. Foreign Key to Client Referrals iId. |
|
mNotes |
String |
|
Transaction notes. |
|
iMemDetailId |
Integer |
4 |
Package was result of membership sale or package awarded when paying EFT Foreign Key to Membership Sale Detail record. |
|
iEmpId2 |
Integer |
4 |
Id of the second employee awarded commission for selling the package. |
|
nSplit1 |
Decimal |
8 |
Factional split of commission awarded to Employee 1. |
|
nSplit2 |
Decimal |
8 |
Factional split of commission awarded to Employee 2. |