|
This data object returns the detail information for all open (unpaid balance) accounts receivable invoices, unvoided, voided, or reopened, along with all unapplied payments.
URL
/frw/ARDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AgeCategory | This field displays the Aging category the invoice falls in, based on the Due date of the invoice. |
| InvAgeCategory | This field displays the Aging category the invoice falls in based on the Invoice date of the invoice. |
| BranchCode | This field displays the branch the given invoice originated from. |
| CompanyName | This field displays the company name of the customer. |
| CreditLimit | This field displays the credit limit allowed for a given A/R customer. |
| CustomerBaseBranch | This field displays the customer base branch assigned to the given customer. |
| CustomerKey | This field displays the identifier associated with the customer on the given AR Invoice within Fusion. |
| CustomerPONumber | This field displays the purchase order number used by a customer. |
| DaysOld | This field displays the difference between the invoice due date and the current date. |
| InvDaysOld | This field displays the difference between the invoice date (or void date for a voided invoice) and the current date. |
| Department | This field displays the department associated with the given invoice. |
| DiscountAmount | This field displays the total discount allowed on the payment of a given A/R invoice. |
| IsDisputeInvoice | This field displays whether the given invoice is flagged as disputed and therefore cannot have a payment applied to it. |
| GrossMargin | This field displays the gross profit margin of the invoice ((P-C)/P * 100 where P is the total price of all the associated items on the invoice, before tax, and where C is the total cost of all the associated items on the invoice, before tax). |
| InvoiceBalance | This field displays the remaining balance due on the invoice. |
| InvoiceDate | This field displays the invoice date for the given record (displays void date if the given invoice is a voided invoice). |
| InvoiceDescription | This field displays the invoice type of the given invoice, followed by the invoice number (or ‘Unapplied Payment for Customer:’ followed by the company name of the customer and the reference associated with the unapplied payment). |
| InvoiceDueDate | This field displays the date on which the given invoice is due. |
| InvoiceNumber | This field displays the invoice number of the given invoice. |
| Amount | This field displays the total amount owed on the original invoice, regardless of payments made. |
| InvoiceType | This field displays a reference to the type of the invoice, based on the module of Fusion in which the invoice was created, along with whether the invoice is a voided invoice (Parts Order Invoice, Parts Order Invoice Void, Fuel Invoice, etc.). |
| InvoiceUser | This field displays the user who created the invoice. |
| NumberPayments | This field displays the total number of payments that have been applied to the given invoice. |
| OriginalDueDate | This field displays the date on which an A/R Invoice was originally due. |
| OutSideSalesPerson | This field displays the outside salesperson who made the sale for a given invoice (populated for Parts Orders, Repair Orders, Lease Contracts, and Sales Invoices). |
| PaidAmount | This field displays the total amount paid, or the sum of all payments made, for the given invoice. |
| PaymentMethod | This field displays the payment method used by a customer. |
| PaymentTerm | This field displays the payment term attached to a given A/R invoice. |
| SeparateStatement | This field displays whether or not the given customer is flagged to receive a statement separately from the parent customer associated with them. |
| PaymentBalance | This field displays the remaining payment balance left on an unapplied payment. |
| UserDefinedPaymentMethod | This field displays the payment method for a customer, as defined by the user. |