Returns details of gift certificate refunds during the specified date range.
GetGiftCertificateRefunds(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 |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iGiftId |
Integer |
4 |
Gift Certificate Id. |
|
nRefAmount |
Decimal |
8 |
Refund amount. |
|
nRefTip |
Decimal |
8 |
Prepaid tip refunded. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Foreign Key to Transaction Header iId. |
|
iOriginLocId |
Integer |
4 |
Id of the location that sold the gift certificate. |
|
iGId |
Integer |
4 |
Gift Certificate Global Id. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
iClientId |
Integer |
4 |
Client Id. |
|
lMailOrder |
Boolean |
1 |
Indicates whether the gift certificate was a mail order. |
|
iLoginId |
Integer |
4 |
User login that sold the gift certificate. Foreign Key to User Logins iId. |