Returns details of package/series refunds during the specified date range.
GetPackageSeriesRefunds(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. |
|
iPkgId |
Integer |
4 |
Package/Series Id. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Unique identifier for each transaction. |
|
iItemId |
Integer |
4 |
Id of the product or service included with the package/series. |
|
cItemType |
String |
40 |
Item included with the package/series (product or service). |
|
nQuantity |
Decimal |
|
Quantity of the product or service included with the package/series. |
|
nPrice |
Decimal |
8 |
Retail price of the package/series. |
|
iClientId |
Integer |
4 |
Client Id. |
|
iOriginLocId |
Integer |
4 |
Id of the location that sold the package/series. |
|
iGId |
Integer |
4 |
Package/Series Global Id. |
|
iOrigTaxId |
Integer |
4 |
Tax Id from the original sale transaction. |
|
lNoPST |
Boolean |
1 |
Indicates if PST tax applies on this transaction. |
|
lNoGST |
Boolean |
1 |
Indicates if GST tax applies on this transaction. |
|
lTaxable |
Boolean |
1 |
Indicates if the package/series is taxable. |
|
lSwap |
Boolean |
1 |
Indicates if clients can swap the package/series items. |
|
tLastUpdate |
DateTime |
8 |
Date last updated. |
|
iPkId |
Integer |
4 |
Primary Key. |
|
iLocationId |
Integer |
4 |
Not used. |
|
tDateTime |
DateTime |
8 |
Date/time of the refund. |
|
lMailOrder |
Boolean |
1 |
Indicates if the package/series is a mail order. |
|
iLoginId |
Integer |
4 |
Login Id of the user who created the refund. Foreign Key to Logins iId. |