Returns the total product sales and refunds for each employee during the specified date range.
GetProductTotalSalesByEmployee(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 |
|
iEmpId |
Integer |
8 |
Employee Id. Foreign key to Employee iId. |
|
cEmpCode |
String |
8 |
Employee code. |
|
cEmpLastName |
String |
20 |
Employee last name. |
|
cEmpFirstName |
String |
15 |
Employee first name. |
|
nTotalQty |
Decimal |
7,2 |
Total quantity sold. |
|
nTotal |
Decimal |
8 |
Total product sales. |
|
nEmpCharge |
Decimal |
8 |
Total of product employee charges. |
|
nHouseCharge |
Decimal |
8 |
Total of product house charges. |
|
lRefund |
Boolean |
1 |
Indicates whether the record contains the refund totals. A TRUE value indicates that the record's values are for products refunded. |