Returns a reward points usage history for a specified client(s) during the specified date range.
GetClientPointsUsage(XmlIds AS String, StartDate AS Date, EndDate AS Date)
XML String
XmlIds = XML String containing the Client Ids of the records to return. You must format this string using the XML IdList Structure Definition.
StartDate = Start date for the records to return.
EndDate = End date for the records to return.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier |
|
iClientId |
Integer |
4 |
Client Id. Foreign Key to Clients iId. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Foreign Key to Transaction Header iId. |
|
iClientPromoId |
Integer |
4 |
Client Point Type Id. Foreign Key to Points Type iId. |
|
iPointsUsed |
Integer |
4 |
Number of points used. |
|
yAmountUsed |
Decimal |
8 |
Dollar amount used. |
|
iGId |
Integer |
4 |
Client Points Usage Record Global Id. |
|
cType |
String |
120 |
Promotion/Reward name. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
cInvoiceNo |
String |
12 |
Transaction number. |