GetDiscountsByMember()

Description

Returns discount information for the specified membership number.

Return Value

XML String

Parameters
Remarks

XML String has the following structure:

Field

Type

Length

Description

iId

Integer

4

Millennium Primary Key - Unique Identifier.

iClientId

Integer

4

Client Id.  Foreign key to client's iId.

iMemberId

Integer

4

Membership Type Id.  Foreign key to membership type iId.

cMember

String

14

Membership number.

lIsMember

Boolean

1

Indicates whether the client has a valid membership.

dMemSince

DateTime

8

Start date for client membership.

nServDisc

Decimal

3,0

Service discount amount.  % off services.

nRetDisc

Decimal

3,0

Retail discount amount.  % off retail.

nTanDisc

Decimal

3,0

Tanning discount amount.  % off tanning.

nPkgDisc

Decimal

3,0

Package/series discount amount.  % off package/series.

lSRound

Boolean

1

Indicates whether service discounts round to the nearest dollar.

lRRound

Boolean

1

Indicates whether retail discounts round to the nearest dollar.

lS1Disc

Boolean

1

Indicates whether service discounts apply on Sunday.

lS2Disc

Boolean

1

Indicates whether service discounts apply on Monday.

lS3Disc

Boolean

1

Indicates whether service discounts apply on Tuesday.

lS4Disc

Boolean

1

Indicates whether service discounts apply on Wednesday.

lS5Disc

Boolean

1

Indicates whether service discounts apply on Thursday.

lS6Disc

Boolean

1

Indicates whether service discounts apply on Friday.

lS7Disc

Boolean

1

Indicates whether service discounts apply on Saturday.

IR1Disc

Boolean

1

Indicates whether retail discounts apply on Sunday.

IR2Disc

Boolean

1

Indicates whether retail discounts apply on Monday.

IR3Disc

Boolean

1

Indicates whether retail discounts apply on Tuesday.

IR4Disc

Boolean

1

Indicates whether retail discounts apply on Wednesday.

IR5Disc

Boolean

1

Indicates whether retail discounts apply on Thursday.

IR6Disc

Boolean

1

Indicates whether retail discounts apply on Friday.

IR7Disc

Boolean

1

Indicates whether retail discounts apply on Saturday.

dExpires

DateTime

8

Membership expiration date.

iGId

Integer

4

Not used.

lFrozen

Boolean

1

Indicates whether the membership is frozen.

dFrozen

DateTime

8

Date the membership was frozen.

dUnFrozen

Boolean

1

Date the membership was unfrozen.

nBillType

Decimal

1

Billing option for the membership.

1 = Manual Billing

2 = Paid In Full (PIF)

3 = Periodic/Recurring

dReactivation

DateTime

8

Reactivation date for the membership.

iLocationId

Integer

4

Not used.

iHomeLocationId

Integer

4

Id of the home location for the membership.

iMembershipSaleDetailId

Integer

4

Membership Sale Detail Id.

lSuspended

Boolean

1

Indicates whether the membership is suspended.

lCancelled

Boolean

1

Indicates whether the client cancelled the membership.

lPrimary

Boolean

1

Indicates whether the client is the primary member.

cMemberName

String

40

Name of the membership.

 

 

Contact Us | Send Feedback