Returns details of membership refunds during the specified date range.
GetMembershipRefunds(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. |
|
iMemberId |
Integer |
4 |
Membership Id. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Foreign Key to Transaction Header iId. |
|
nRefAmount |
Decimal |
8 |
Refund amount. |
|
iClientId |
Integer |
4 |
Client Id. |
|
iEmpId |
Integer |
4 |
Id of the employee who sold the membership. |
|
lDisable |
Boolean |
1 |
|
|
iGId |
Integer |
4 |
Not used. |
|
lTaxable |
Boolean |
1 |
Indicates whether the membership is taxable. |
|
iOriginTaxId |
Integer |
4 |
Tax Id for the original sale transaction. |