|
This data object displays parts and service salesperson commission records as seen in the Salesperson Commission Display application in Fusion.
URL
/frw/SalesPersonCommission
Field Details…
| SQL Field Name | Column Description |
|---|---|
| Branch | This field displays the branch associated with the invoice record for the commission detail item. |
| Commission | This field displays the commission the salesperson received for the line item. |
| Commission Rate | This field displays the commission rate for the salesperson. |
| CommissionTable | This field displays the commission table applied to the user branch department record that determines the commission. |
| Customer | This field displays the customer number associated with the invoice record. |
| Department | This field displays the department associated with the invoice record for the commission detail item. |
| ExtendedCost | This field displays the extended cost of the item sold on the invoice. |
| ExtendedPrice | This field displays the extended price of the item sold on the invoice. |
| GrossProfit | This field displays the gross profit of the item sold. |
| GrossProfitMargin | This field displays the gross profit margin of the item sold. |
| InvoiceDate | This field displays the invoice date of the invoice assocaited with commission detail item. |
| InvoiceDateandTime | This field displays the invoice date and time of the invoice assocaited with commission detail item. |
| InvoiceNumber | This field displays the invoice number associated with the commission detail item. |
| Item | This field displays the item that was sold. |
| IsOutsideSalesperson | This field displays Yes, if the salesperson associated with the detail is an outside salesperson, or No if the salesperson is not. |
| Quantity | This field displays the quantity of the item sold. |
| Salesperson | This field displays the Salespersons username associated with the commission detail record. |
| SalespersonName | This field displays the Salespersons first name and last name. |
| IsVoided | If the record is for a voided invoice, this field is set to Yes. If not, this field is set to No. |