Returns a client discount object you can use to update that discount.
GetClientDiscount(ClientId AS Number)
Object
ClientId = Client Id for which to view discount information.
Object has the following structure:
|
Field |
Type |
Length |
Description |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
dDateDeleted |
Date |
8 |
Date deleted. |
|
iGlobalId |
Integer |
4 |
Client Discount Global Id. |
|
eObjectState |
Enumeration |
1 |
Indicates the status of the object. -1 = Unchanged 0 = New/Added 1 = Changed 2 = Deleted |
|
iClientId |
Integer |
4 |
Client Id. Foreign key to Clients iId. |
|
iMembershipId |
Integer |
4 |
Membership Type Id. Foreign key to Membership Type iId. |
|
cMembershipNumber |
String |
14 |
Membership number. |
|
lIsMember |
Boolean |
1 |
Indicates whether the client has a valid membership. |
|
dMemberSince |
DateTime |
8 |
Start date for the client's membership. |
|
nServiceDiscount |
Decimal |
3,0 |
Service discount amount. % off services. |
|
nRetailDiscount |
Decimal |
3,0 |
Retail discount amount. % off retail. |
|
nTanningDiscount |
Decimal |
3,0 |
Tanning discount amount. % off tanning. |
|
nPackageSeriesDiscount |
Decimal |
3,0 |
Package/series discount amount. % off package/series. |
|
lRoundServiceDiscount |
Boolean |
1 |
Indicates whether the service discounts round to the nearest dollar. |
|
lRoundRetailDiscount |
Boolean |
1 |
Indicates whether the retail discounts round to the nearest dollar. |
|
lHasServiceDiscountOnSunday |
Boolean |
1 |
Indicates whether service discounts apply on Sunday. |
|
lHasServiceDiscountOnMonday |
Boolean |
1 |
Indicates whether service discounts apply on Monday. |
|
lHasServiceDiscountOnTuesday |
Boolean |
1 |
Indicates whether service discounts apply on Tuesday. |
|
lHasServiceDiscountOnWednesday |
Boolean |
1 |
Indicates whether service discounts apply on Wednesday. |
|
lHasServiceDiscountOnThursday |
Boolean |
1 |
Indicates whether service discounts apply on Thursday. |
|
lHasServiceDiscountOnFriday |
Boolean |
1 |
Indicates whether service discounts apply on Friday. |
|
lHasServiceDiscountOnSaturday |
Boolean |
1 |
Indicates whether service discounts apply on Saturday. |
|
lHasRetailDiscountOnSunday |
Boolean |
1 |
Indicates whether retail discounts apply on Sunday. |
|
lHasRetailDiscountOnMonday |
Boolean |
1 |
Indicates whether retail discounts apply on Monday. |
|
lHasRetailDiscountOnTuesday |
Boolean |
1 |
Indicates whether retail discounts apply on Tuesday. |
|
lHasRetailDiscountOnWednesday |
Boolean |
1 |
Indicates whether retail discounts apply on Wednesday. |
|
lHasRetailDiscountOnThursday |
Boolean |
1 |
Indicates whether retail discounts apply on Thursday. |
|
lHasRetailDiscountOnFriday |
Boolean |
1 |
Indicates whether retail discounts apply on Friday. |
|
lHasRetailDiscountOnSaturday |
Boolean |
1 |
Indicates whether retail discounts apply on Saturday. |
|
dExpiresDate |
DateTime |
8 |
Membership expiration date. |
|
lIsFrozen |
Boolean |
1 |
Indicates whether the client's membership is frozen. |
|
dFrozenDate |
DateTime |
8 |
Date when the client's membership was frozen. |
|
dUnFrozenDate |
DateTime |
8 |
Date when the client's membership was unfrozen. |
|
cEFTType |
String |
13 |
Billing method used to pay the membership dues. - Unknown - CreditCard - ACH - BillToPrimary |
|
dReactivationDate |
DateTime |
8 |
Reactivation date for the membership. |
|
iHomeLocationId |
Integer |
4 |
Id of the location where the client purchased the membership. |
|
iMembershipSaleDetailId |
Integer |
4 |
Id of the transaction record for the membership sale. |
|
lIsSuspended |
Boolean |
1 |
Indicates whether the membership is suspended. |
|
lIsCancelled |
Boolean |
1 |
Indicates whether the client cancelled the membership. |
|
lIsPrimary |
Boolean |
1 |
Indicates whether the client is the primary member of the membership. |