Returns a transaction history for the specified client(s) during the specified date range.
GetClientHistory(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 |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
nLineNo |
Integer |
4 |
Line number. |
|
nPrice |
Decimal |
8 |
Individual price of each service. Includes any discounts or price changes. |
|
nQuantity |
Decimal |
7,2 |
Quantity sold. A decimal value indicates a split line commission for the line. |
|
cTransType |
String |
1 |
Indicates the type of data that this record represents. A = Account Payment C = Cancelation E = Series G = Gift Certificate K = Package M = Membership N = No Show P = Product R = Refund S = Service T = Tanning |
|
cProduct |
String |
40 |
Product description. |
|
cService |
String |
40 |
Service description. |
|
iPrdSrvId |
Integer |
4 |
Product/Service Id. Foreign Key to Product/Service iId. |
|
iEmpId |
Integer |
4 |
Employee Id. Foreign Key to Employee iId. |
|
iEmpGId |
Integer |
4 |
Not used. |
|
ClientId |
Integer |
4 |
Client Id. Foreign Key to Clients iId. |
|
ClientGId |
Integer |
4 |
Not used. |
|
cEmpName |
String |
36 |
Name of the employee associated with the transaction. |
|
cClientName |
String |
36 |
Client name. |
|
lVoid |
Boolean |
1 |
Indicates a voided transaction. |