Returns the total service sales and refunds for each service class during the specified date range.
GetServiceTotalSalesByClass(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 |
|
iClassId |
Integer |
8 |
Service class Id. Foreign key to Service Class iId. |
|
cClassName |
String |
30 |
Service class name. |
|
nTotalQty |
Decimal |
7,2 |
Total quantity. |
|
nTotal |
Decimal |
8 |
Total service sales. |
|
nEmpCharge |
Decimal |
8 |
Total of service employee charges. |
|
nHouseCharge |
Decimal |
8 |
Total of service house charges. |
|
lRefund |
Boolean |
1 |
Indicates whether the record contains the refund totals. A TRUE value indicates that the record's values are for services refunded. |