Returns details of tanning package sales during the specified date range.
GetTanningSalesByDate(StartDate AS Date, EndDate AS Date)
XML String
StartDate = Start date for the records to return.
EndDate = End date for the records to return.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
cTanningCode |
String |
8 |
Identifying code for the tanning package. |
|
cTanningDescription |
String |
40 |
Tanning package description. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
nDrawerId |
Decimal |
2,0 |
Drawer Id. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. |
|
iTransTanDetailId |
Integer |
4 |
Primary Key - Unique Identifier |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
iEmpId |
Integer |
4 |
Id of Employee who sold the tanning package. Foreign Key to Employee iId. |
|
iPurchFor |
Integer |
4 |
Purchased For Client Id. Foreign Key to Client iId. |
|
iPurchBy |
Integer |
4 |
Purchased By Client Id. Foreign Key to Client iId. |
|
nPrice |
Decimal |
8 |
Price of tanning package. |
|
nQuantity |
Decimal |
4,0 |
Number of tanning packages sold. |
|
nType |
Decimal |
1,0 |
Indicates the type of tanning package. 1 = By Session 2 = By Time 3 = By Number of Weeks |
|
dStartDate |
Date |
8 |
On sale start date. |
|
dEndDate |
Date |
8 |
On sale end date. |
|
nTotSlots |
Decimal |
7,2 |
Indicates the total length of the sessions purchased. - If nType = 1, then nNumSlots represents the number of sessions. - If nType = 2, then nNumSlots represents the length of time the package is good for. - If nType = 3, then nNumSlots represents the number of weeks the package is good for. |
|
nSlotsLeft |
Decimal |
7,2 |
Indicates the total length of the sessions remaining. - If nType = 1, then nNumSlots represents the number of sessions. - If nType = 2, then nNumSlots represents the length of time the package is good for. - If nType = 3, then nNumSlots represents the number of weeks the package is good for. |
|
iTanId |
Integer |
4 |
Tanning Package Id. Foreign Key to Tanning Definitions iId. |
|
iGId |
Integer |
4 |
Tanning Package Global Id. |