|
Deal Detail
This data object is used to display all detail items on all unit sales deals.
This information can be found by clicking the detail hyperlinks in the Deal application in the Fusion business system.
URL
/frw/SalesDealDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given detail item was added to the deal. |
| AddUser | This field displays the username of the user who added the given detail item to the deal. |
| AmountSubjectToFET | This field displays, for the given unit detail item, the amount subject to FET ((FET Amount + Tire Tax Credit)/0.12) for the unit on the given deal. |
| Branch | This field displays the branch in which the given deal was created. |
| BuyRate | This field displays, for the given financing detail item, the buy rate associated with the deal financing. |
| Cost | This field displays the cost of the given detail item on the deal (Cost for Sale Unit, Unit Addon, or Deal Addon, 0 for Trade Unit, FET, Payoff, Deposit, or Financing). |
| DealHeaderNumber | This field displays the deal number of the deal that the given detail item was added to. |
| DealPacketNumber | This field displays the deal packet number of the deal packet that the given detail item was added to. |
| Department | This field displays the department in which the given deal was created. |
| Division | This field displays the division in which the given deal was created. |
| ExemptDelivery | This field displays, for the given unit detail item, the amount of exempt delivery expenses associated with the given unit. |
| ExemptEquipment | This field displays, for the given unit detail item, the amount of exempt equipment expenses associated with the given unit. |
| FETAmount | This field displays, for the given unit detail item, the amount of Federal Excise Tax charged on the sale of the given unit. |
| FinanceReserve | This field displays, for the given financing detail item, the finance reserve amount associated with the deal financing. |
| InventoryType | This field displays, for the given unit on the deal, the inventory type of that unit. |
| InvoiceDate | This field displays, for invoiced deals, the date on which the given deal was invoiced. |
| InvoiceNumber | This field displays, for invoiced deals, the invoice number for the given deal. |
| Item | This field displays the identifying name of the given detail item (Stock Number for units, FET for FET, Payoff Name for payoffs, Payment Type for deposits, Finance Lender for financing, and the name of the given addon for unit and deal addons). |
| ItemDescription | This field displays a brief description of the given detail item (Make, Model, and Year for units, FET for FET, Loan Number for payoffs, Payment Description for deposits, Finance Lender Description for financing, and the description of the given addon for unit and deal addons). |
| ItemType | This field displays a description identifying which kind of deal detail item is displayed on the given record. |
| LastUpdateDate | This field displays the date on which the given detail item was last updated on the deal. |
| LastUpdateUser | This field displays the username of the user who last updated the given detail item on the deal. |
| OrderStatus | This field displays the status of the given deal, and signifies whether it has been invoiced and/or posted to accounting. |
| Period | This field displays, for the given financing detail item, the financing period associated with the deal financing. |
| PrePosted | This field displays, for the given deposit on the deal, whether it has been preposted to accounting. |
| Price | This field displays the price of the given detail item on the deal (Price for Sale Unit, Price * -1 for Trade Unit, Addon Price for Unit or Deal Addon, FET Amount for FET, Payoff Amount for Payoff, Deposit Amount * -1 for Deposit, Financing Amount * -1 for Financing). |
| Profit | This field displays the profit for the given detail item on the deal. |
| ProfitCalculation | This field displays the calculation used to determine the profit for the given item type. |
| ProfitMargin | This field displays the percentage of the price of the given item that is considered profit. |
| Rate | This field displays, for the given financing detail item, the financing rate associated with the deal financing. |
| Refunded | This field displays, for the given deposit on the deal, whether it has been refunded. |
| SaleType | This field displays, the sale type associated with the given deal. |
| StockNumber | This field displays the stock number of the unit that the given detail item is associated with (not populated for general deal level detail items). |
| TireTaxCredit | This field displays, for the given unit detail item, the amount of tire tax credit associated with the given unit. |
| TradeInActualCashValue | This field displays, for the given trade unit on the deal, the amount that the trade unit is actually worth. |
| TradeInAllowance | This field displays, for the given trade unit on the deal, the total allowance given to the customer for the trade unit. |
| TradeInOverUnderAllowance | This field displays, for the given trade unit on the deal, the over/under allowance (Trade In Allowance - Trade In Actual Cash Value) for the trade unit. |