|
This data object displays 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/InvoiceSalesSummary
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which the given invoice was created. |
| AddUser | This field displays the username of the user that originally added the open order, which has since been invoiced, to the system. |
| AverageCostGrossProfit | This field displays the gross profit of the given invoice, based on the average cost of the items on the invoice. |
| AverageCostGrossProfitMargin | This field displays the gross profit margin of the given invoice, based on the average cost of the items on the invoice. |
| 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. |
| BillingCustomerAddress1 | This field displays the first line of the Bill To address for the billing customer on the given invoice. |
| BillingCustomerAddress2 | This field displays the second line of the Bill To address for the billing customer on the given invoice. |
| BillingCustomerCity | This field displays the city of the Bill To address for the billing customer on the given invoice. |
| BillingCustomerCounty | This field displays the county of the Bill To address for the billing customer on the given invoice. |
| BillingCustomerPostalCode | This field displays the postal code of the Bill To address for the billing customer on the given invoice. |
| BillingCustomerRegion | This field displays the region or state of the Bill To address for the billing customer on the given invoice. |
| 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. |
| CustomerPO | This field displays the customer PO number on the given invoice. |
| Department | This field displays the department in which the invoice was created. |
| Division | This field displays the division in which the invoice was created. |
| Branch | This field displays the branch in which the invoice was created. |
| InvoiceDate | This field displays the date on which the given item was invoiced. |
| InvoiceNumber | This field displays the invoice number of the given invoice. |
| InvoiceSubTotal | This field displays the total of the given invoice, excluding taxes. |
| InvoiceTaxTotal | This field displays the total taxes charged on the given invoice. |
| InvoiceTotal | This field displays the total of the given invoice, including taxes. |
| OrderType | This field displays the type of the given invoice, based on the module and/or application in Fusion in which it was created. |
| InvoiceUser | This field displays the username of the user that invoiced the given order. |
| LastUpdate | This field displays the date on which the given invoice was last updated. |
| UpdateUser | This field displays the user name of the user that last updated the invoice. |
| IsLocal | This field displays whether the given invoice should have the local sales tax applied to it, if the invoice is taxable. |
| OrderCustomerAddress1 | This field displays the first line of the Ship To address for the customer who ordered the given invoice. |
| OrderCustomerAddress2 | This field displays the second line of the Ship To address for the customer who ordered the given invoice. |
| OrderCustomerCity | This field displays the city of the Ship To address for the customer who ordered the given invoice. |
| OrderCustomerCounty | This field displays the county of the Ship To address for the customer who ordered the given invoice. |
| OrderCustomerPostalCode | This field displays the postal code of the Ship To address for the customer who ordered the given invoice. |
| OrderCustomerRegion | This field displays the region or state of the Ship To address for the customer who ordered the given invoice. |
| OrderNumber | This field displays the order number of the original item that was invoiced. |
| PaymentMethod | This field displays the payment method by which the customer will pay the invoice. |
| ReplacementCostGrossProfit | This field displays the gross profit of the given invoice, based on the replacement cost of the items on the invoice. |
| ReplacementCostGrossProfitMargin | This field displays the gross profit margin of the given invoice, based on the replacement cost of the items on the invoice. |
| Salesperson | This field displays the outside salesperson associated with the sale to the given customer via the given invoice. |
| TotalAverageCost | This field displays the total average cost of all the items on the given invoice. |
| TotalReplacementCost | This field displays the total replacement cost of all the items on the given invoice. |
| IsVoidedInvoice | This field displays whether the given invoice has been voided. |