Returns a tanning package listing.
GetTanningPackageDefinitions(IncludeDeleted AS Boolean)
XML String
IncludeDeleted = Select to include deleted records in the results.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used. |
|
cCode |
String |
8 |
Identifying code for the tanning package. |
|
cDescript |
String |
40 |
Tanning package description. |
|
nType |
Decimal |
1,0 |
Indicates the type of tanning package. 1 = By Session 2 = By Time 3 = By Number of Weeks |
|
nNumSlots |
Decimal |
6,2 |
Indicates the length of the session. - If nType = 1, then nNumSlots represents the number of sessions. - If nType = 2, then nNumSlots represents the length of time the package is valid. - If nType = 3, then nNumSlots represents the number of weeks the package is valid. |
|
nPrice |
Decimal |
8 |
Tanning package price. |
|
lOnSale |
Boolean |
1 |
Indicates whether the package |
|
dSaleStart |
DateTime |
8 |
On sale start date. |
|
dSaleEnd |
DateTime |
8 |
On sale end date. |
|
nSalePrice |
Decimal |
8 |
On sale price. |
|
nExpireWeeks |
Decimal |
3,0 |
Number of weeks until the package expires. |
|
dDateDel |
DateTime |
8 |
Date deleted. |
|
iGId |
Integer |
4 |
Tanning Package Global Id. |
|
tChanged |
DateTime |
8 |
Date last changed. |
|
iChgBy |
Integer |
4 |
Id of the employee who last changed the tanning package. |