Returns details of the services sold during the specified date range.
GetServiceSales(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 |
|
cServiceCode |
String |
10 |
Identifying code for the service. |
|
cServiceDescription |
String |
40 |
Description of service. |
|
tDateTime |
DateTime |
8 |
Transaction date/time. |
|
nDrawerId |
Decimal |
2 |
Drawer Id. |
|
iTransDetailId |
Integer |
4 |
Transaction Detail Id. |
|
iHeaderId |
Integer |
4 |
Transaction Header Id. Unique identifier for each transaction. |
|
cInvoiceNo |
String |
12 |
Transaction invoice number. (Formatted as YYYYMMDDXXXX - where XXXX is an incrementing ticket number.) |
|
iItemId |
Integer |
4 |
Service Id. Foreign Key to Services Id. |
|
iEmpId |
Integer |
4 |
Employee Id. Foreign Key to Employee Id. |
|
iClientId |
Integer |
4 |
Client Id. Foreign Key to Client iId. |
|
iApptType |
Integer |
4 |
Appointment Type Id. Foreign Key to appointment type Id. |
|
nPrice |
Decimal |
8 |
Individual price of each service. Includes any discounts or price changes. |
|
nQuantity |
Decimal |
7,2 |
Quantity sold. |
|
cDiscount |
String |
5 |
Discount type given. % = Percentage off discount $ = Fixed dollar off or a spread discount C = Coupon discount S = Special price or a price override P = Package discount E = Employee price discount |
|
nEmpCharge |
Decimal |
8 |
Employee charge for service. |
|
nHouseCharge |
Decimal |
8 |
House charge for service. |
|
lPreBook |
Boolean |
1 |
Indicates whether the client received a prebook discount. |
|
lOnline |
Boolean |
1 |
Indicates whether the client received an Online Booking discount. |
|
lRefund |
Boolean |
1 |
Indicates whether the line item is a refund. |
|
lTaxable |
Boolean |
1 |
Indicates whether the service is taxable. |
|
lGST |
Boolean |
1 |
Indicates whether GST tax applies to the transaction. |
|
lPST |
Boolean |
1 |
Indicates whether PST tax applies to the transaction. |
|
lMembershipSaleDetailId |
Integer |
4 |
Membership Sale Detail Record Id. |