|
This data object displays the detail items on all invoiced and/or voided repair orders, parts orders, LR contracts, finance charges, deals, fuel invoices, and adjustment invoices, regardless of whether they have been paid in full.
This information can be found in the respective invoicing applications in the Fusion business system.
URL
/frw/InvoiceSalesSummaryDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the detail item was added to the given invoice. |
| AddUser | This field displays the username of the user who added the detail item to the given invoice. |
| AverageCost | This field displays the average cost or cost, for items that do not have an average cost, of the given detail item at the time that the item was added to the invoice. If the average cost of the item was zero, the replacement cost of that item is displayed instead. |
| AverageCostGrossProfit | This field displays the gross profit from the given detail item on the given invoice, based on average cost. |
| AverageCostGrossProfitMargin | This field displays the gross profit margin from the given detail item on the given invoice, based on average cost. |
| IsBillCustomerOT | This field displays whether the customer is to be charged extra for the overtime hours on the given labor charge. |
| IsBillingAdjustment | This field displays whether the billing hours on the given labor charge were manually adjusted. |
| BillingCompanyName | This field displays the company name of the billing customer on the given invoice. |
| BillingCustomer | This field displays the customer number of the billing customer on the given invoice. |
| BillingRateFrequency | This field displays the billing frequency of the given L/R fixed charge. |
| Branch | This field displays the branch in which the given invoice was created. |
| CalculatedPrice | This field displays, for parts and repair order invoices, the price of the given detail item before override price is taken into consideration. |
| CompanyName | This field displays the company name of the customer who ordered the given invoice. |
| Customer | This field displays the customer number of the customer who ordered the given invoice. |
| Department | This field displays the department in which the given invoice was created. |
| Division | This field displays the division in which the given invoice was created. |
| ExtendedAverageCost | This field displays the extended average cost (average cost * quantity) of the given detail item. |
| ExtendedPrice | This field displays the extended price (price * quantity) of the given detail item. |
| ExtendedReplacementCost | This field displays the extended replacement cost (replacement cost * quantity) of the given detail item. |
| InsideSalesperson | This field displays the inside parts salesperson for parts or repair invoices, the unit salesperson for LR invoices, the salesperson for sales invoices, or the salesperson for adjustment invoices converted in through the Load A/R Invoice application. |
| InvoiceDate | This field displays the date on which the invoice that the given detail item is associated with was invoiced. |
| InvoiceNumber | This field displays the invoice number of the invoice that the given detail item is associated with. |
| InvoiceType | This field displays the type of the given invoice (Parts Order Invoice for invoices created in the Parts Order application, Repair Order Invoice for invoices created in the Repair Order application, Sales Invoice for invoices created in the Deal application, L/R Invoice for invoices created in the LR Billing application, Fuel Invoice for invoices created in the Fuel Ticket Billing application, Finance Charge Invoice for finance charges billed in the Finance Charge application, Sales Tax Adjustment Invoice for invoices created in the Sales Tax Adjustment Invoice application, Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Adjustment Invoice, Parts Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Parts Order Invoice, Service Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Repair Order Invoice, Lease Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Lease Invoice, Rental Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Rental Processing Invoice, Sales Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Sales Invoice, Finance Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Finance Charge Invoice, Unapplied Adjustment Invoice for invoices created in the Load A/R Invoice application with an Invoice Type of Unapplied Receipts, Refund Check Adjustment Invoice for invoices created by clicking refund in the toolbar while in the Customer Activity application in order to print a refund check, Moved Payment Adjustment Invoice for invoices created by right clicking on a payment in ROA in the Customer Activity application in order to move a payment to another account) based on the module and/or application in Fusion in which it was created. |
| Item | This field displays the identifying name of the given detail item (part number for parts, technician number for labor, stock number for unit, charge name for miscellaneous, fixed, or variable charges, fuel type for fuel). |
| ItemDescription | This field displays the description of the given detail item, corresponding to the name in the Item field. |
| ItemType | This field displays the type (Part, Miscellaneous Charge, or EHC for Parts Order Invoices, Part, Labor, Miscellaneous Charge, PartsVariance, or LaborVariance for Repair Order Invoices, Sale Unit, Unit Add On, Trade Unit, Deal Add On, FET, Payoff, Deposit, Down Payment, or Financing for Sales Invoices, Fixed Charge, Variable Charge, Miscellaneous Charge, or Fuel Charge for L/R Invoices, Fuel or Miscellaneous Charge for Fuel Invoices, Finance Charge for Finance Charge Invoices, Adjustment Invoice for Sales Tax Adjustment Invoices, Adjustment Invoices, Parts Adjustment Invoices, Service Adjustment Invoices, Lease Adjustment Invoices, Rental Adjustment Invoices, Sales Adjustment Invoices, Finance Adjustment Invoices, Unapplied Adjustment Invoices, Refund Check Adjustment Invoices, or Moved Payment Adjustment Invoices) of the given detail item, transaction, or charge on the invoice. |
| LastUpdateDate | This field displays the date on which the detail item was last updated on the given invoice. |
| LastUpdateUser | This field displays the username of the user who last updated the detail item on the given invoice. |
| MeterType | This field displays the meter type associated with the given L/R variable charge. |
| OEMPrice | This field displays the selling price of the given detail item from the customer, which was received from the OEM through a price verification. |
| OEMRebateAmount | This field displays the rebate amount that can be subtracted from the total cost of the transaction, which was received from the OEM through a price verification. |
| OrderNumber | This field displays the order number of the given invoice (Parts Order Number for Parts Invoices, Repair Order Number for Service Invoices, Fuel Ticket Number for Fuel Invoices, LR Contract Number for LR Invoices, Deal Number for Sales Invoices). |
| OrderStatus | This field displays Invoiced or Voided, to indicate whether the given invoice has been voided. |
| OTHours | This field displays the number of overtime hours on the given labor charge. |
| OTMultiplier | This field displays the multiplier used to determine cost per hour of the overtime hours associated with the given labor charge. |
| OutsideSalesperson | This field displays the outside salesperson associated with the given customer on the given invoice. |
| OverridePrice | This field displays the override price entered for the given detail item when it was added to the given parts or repair order invoice. |
| PartType | This field displays the part type of the given part detail item (Part for a part without a core, Exc for a part with a core, Inh for a clean core, or Ret for a dirty core). |
| PartsActionType | This field displays the action type selected when the part was sold (sale, sale-force fill, or sale-no usage update). |
| Price | This field displays the price of the given detail item at the time that the item was added to the invoice. |
| Quantity | This field displays the quantity of the given detail item on the invoice. |
| ReplacementCost | This field displays the replacement cost or cost, for items that do not have a replacement cost, of the given detail item at the time that the item was added to the invoice. |
| ReplacementCostGrossProfit | This field displays the gross profit from the given detail item on the given invoice, based on replacement cost. |
| ReplacementCostGrossProfitMargin | This field displays the gross profit margin from the given detail item on the given invoice, based on replacement cost. |
| StockNumber | This field displays the stock number of the unit associated with the given detail item on the invoice. |
| Supplier | This field displays the supplier of the given part detail item on the invoice. |
| TaskNumber | This field displays the task number on the repair order that the given detail item is associated with. |
| UnitNumber | This field displays the unit number of the unit associated with the given detail item on the invoice. |