|
This data object is used to display the commission information by salesperson and stock number for a given deal packet invoice.
This information can be found by clicking the Commission Worksheet hyperlink in the Accounting Review application in the Fusion business system.
URL
/frw/SalesDealCommission
Field Details…
| SQL Field Name | Column Description |
|---|---|
| Approved | This field displays whether the commission for the given deal has been approved to be paid. |
| BaseCost | This field displays the base cost of the unit that was sold. |
| Branch | This field displays the branch associated with the given deal. |
| Commission | This field displays the commission amount for the salesperson of the given unit on the deal. |
| CommissionDate | This field displays the date that the commission was prepared and approved (defaults to the date that it was added to the system, but can be manually changed in Fusion). |
| CommissionPercentage | This field displays the percentage of the unit on the deal that is calculated as commission. |
| IsCommissionPercentageAgainstProfit | This field displays whether the commission for the salesperson of the given unit on the deal will be calculated against profit, rather than the gross amount of the deal. |
| Cost | This field displays the cost of the given unit. |
| DealNumber | This field displays the deal number of the deal that the unit was sold on. |
| Department | This field displays the department associated with the given deal. |
| FinanceCommission | This field displays the cost of the finance commission unit addon on the given deal packet. |
| FinanceLender | This field displays the finance lender associated with the given deal packet. |
| FinanceReserve | This field displays the reserve amount from the given deal packet invoice. |
| FlatAmount | This field displays the amount that the salesperson of the given unit on the deal will receive as commission. |
| Held | This field displays whether the commission is being held from being paid. |
| HeldDate | This field displays the date as of which the commission is being held. |
| HeldReason | This field displays the reason that the commission is being held. |
| IncludeFinanceReserveInTotalProfit | This field displays whether the finance reserve should be included in the total profit for the commission for the sale of the given unit. |
| IncludeInsuranceIncomeInTotalProfit | This field displays whether the insurance income should be included in the total profit for the commission for the sale of the given unit. |
| InsuranceCommission | This field displays the cost of the insurance commission unit addon on the given deal packet. |
| InsuranceIncome | This field displays the cost of the insurance income unit addon on the given deal packet. |
| InventoryType | This field displays the inventory type of the unit that was sold and that commission will be paid on. |
| InvoiceDate | This field displays the invoice date of the deal that the unit was sold on. |
| Make | This field displays the make of the unit that was sold and that commission will be paid on. |
| MinimumCommission | This field displays the minimum amount that the salesperson of the given unit on the deal would receive as commission. |
| MinimumProfit | This field displays the minimum profit of the unit on the deal that is considered subject to commission. |
| MinimumProfitPercentage | This field displays the minimum profit percentage of the unit on the deal that is considered subject to commission. |
| Misc1 | This field displays the description of the first miscellaneous item to be considered in calculating commission. |
| Misc1Cost | This field displays the cost of the first miscellaneous item to be considered in calculating commission. |
| Misc1Price | This field displays the price of the first miscellaneous item to be considered in calculating commission. |
| Misc1Profit | This field displays the profit (price - cost) of the first miscellaneous item to be considered in calculating commission. |
| Misc2 | This field displays the description of the second miscellaneous item to be considered in calculating commission. |
| Misc2Cost | This field displays the cost of the second miscellaneous item to be considered in calculating commission. |
| Misc2Price | This field displays the price of the second miscellaneous item to be considered in calculating commission. |
| Misc2Profit | This field displays the profit (price - cost) of the second miscellaneous item to be considered in calculating commission. |
| Model | This field displays the model of the unit that was sold and that commission will be paid on. |
| Note | This field displays the note entered regarding the given commission. |
| OpenLPOs | This field displays the total expected amount of all open LPOs for the given unit. |
| PacketNumber | This field displays the packet number of the deal packet that the unit was sold on. |
| Price | This field displays the price of the given unit. |
| Profit | This field displays the profit (price - cost) for the given unit. |
| ProratedOverUnderAllowance | This field displays the over/under allowance for the given unit on the given deal. |
| Salesperson | This field displays the salesperson who will be receiving commission for the sale of the given unit. |
| SoldStockNumber | This field displays the stock number of the unit that was sold and that commission will be paid on. |
| TotalAddonCost | This field displays the total cost of all addons subject to commission on the given deal. |
| TotalAddonPrice | This field displays the total price of all addons subject to commission on the given deal. |
| TotalAddonProfit | This field displays the total profit (total price - total cost) of all addons subject to commission on the given deal. |
| TotalCost | This field displays the total cost (Cost + Total Addon Cost + Misc 1 Cost + Misc 2 Cost) of the given unit on the deal. |
| TotalPrice | This field displays the total price (Price + Total Addon Price + Misc 1 Price + Misc 2 Price) of the given unit on the deal. |
| TotalProfit | This field displays the total profit (Profit + Total Addon Profit + Misc 1 Profit + Misc 2 Profit - Prorated Over Under Allowance) of the given unit on the deal. Note that if Include Finance Reserve In Total Profit and/or Include Insurance Income In Total Profit is checked, Finance Reserve will be added to Total Profit and/or Insurance Income will be subtracted from Total Profit, respectively. |
| Year | This field displays the year of the unit that was sold and that commission will be paid on. |