Returns details of client account charges during the specified date range.
GetClientAcctChargesByDate(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. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Foreign Key to Transaction Header iId. |
|
iClientId |
Integer |
4 |
Paying Client Id for the entire transaction. Foreign Key to Clients iId. |
|
nChargeAmou |
Decimal |
8 |
Account charge amount. |
|
cInvNote |
String |
|
Transaction note. |