Returns details of membership sales during the specified date range.
GetMembershipSalesByDate(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 membership. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used. |
|
iMembershipId |
Integer |
4 |
Membership Id. |
|
iClientId |
Integer |
4 |
Client Id. |
|
iEmpId |
Integer |
4 |
Id of the employee that who sold the membership. |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Unique identifier for each transaction. |
|
nPrice |
Decimal |
8 |
Membership sales price. |
|
dExpiration |
DateTime |
8 |
Expiration date for the membership. |
|
lRefunded |
Boolean |
1 |
Indicates whether an employee refunded the membership enrollment fee. |
|
iGId |
Integer |
4 |
Not used. |
|
cMemberNumber |
String |
20 |
Membership number |
|
nBillFrequency |
Decimal |
3,0 |
Billing frequency for the membership dues. |
|
nPreBill |
Decimal |
3,0 |
You can set how many weeks before the bill date to send the bill. |
|
NStopMembership |
Decimal |
3,0 |
You can set when to stop the membership if payment is past due. |
|
lTaxable |
Boolean |
1 |
Indicates if the membership is taxable. |
|
nBillType |
Decimal |
1 |
Billing option for the membership. 1 = Manual Billing 2 = Paid In Full (PIF) 3 = Periodic/Recurring |
|
lAutoRenew |
Boolean |
1 |
Indicates whether the membership is setup for automatic renewal. |
|
nAutoRenewType |
Decimal |
1 |
Indicates the type of automatic renewal used. 1 = Full Renew 2 = Monthly |
|
dAutoRenewBegins |
DateTime |
8 |
Automatic renewal date for the membership. |
|
iMemMonths |
Integer |
3 |
Membership length in months. |
|
dValidFrom |
DateTime |
8 |
Date from which the membership is valid. |
|
iTransFromLocId |
Integer |
4 |
Id of the location that transferred the membership out. |
|
iTransToLocId |
Integer |
4 |
Id of the location that transferred the membership in. |