|
Accounting AP Detail
This data object is used to capture and return all accounts payable invoice information.
This information is located in Accounts Payable Invoice Entry and General Ledger Transactions within the Fusion business system.
URL
/frw/APDetail
Field Details…
| SQL Field Name | Column Description |
|---|---|
| AddDate | This field displays the date on which an A/P invoice was added. |
| AgeCategoryFromInvoiceDate | This field displays the Aging category the invoice falls in based on the Invoice date of the invoice. |
| AgeCategoryFromInvoiceDueDate | This field displays the Aging of the invoice from the Due date of the invoice. |
| APInvoice | This field displays a given Accounts Payable Invoice. |
| APInvoiceSource | This field displays the source where the AP Invoice came from. |
| Balance | This field displays the remaining balance of the invoice. |
| Bank | This field displays the bank that paid the invoice. |
| CheckAmount | This field displays the amount of the check the invoice was paid on. |
| CheckDate | This field displays the check date of the check the invoice was paid on. |
| CheckNumber | This field displays the check number used in a given transaction. |
| DiscountAmount | This field displays the amount of a discount, if any, on a given A/R invoice. |
| DiscountDueDate | This field displays the date by which an invoice must be paid in order to use the associated discount. |
| GLPostingSequence | This field displays the accounting posting sequence of the AP Invoice. |
| InvoiceAmount | This field displays the amount due for a given A/P invoice. |
| InvoiceDate | This field displays the invoice date for the A/P Invoice. |
| Journal | This field displays the journal source code for a general ledger transaction. |
| LastUpdate | This field displays the date on which an A/P invoice was last updated. |
| NetDueDate | This field displays the date on which an Accounts Payable invoice is due. |
| PayeeAddress1 | This field displays the Address line 1 of the Payee for the check the invoice was paid on. |
| PayeeAddress2 | This field displays the Address line 2 of the Payee for the check the invoice was paid on. |
| PayeeCity | This field displays the City of the Payee for the check the invoice was paid on. |
| PayeeCountry | This field displays the Country of the Payee for the check the invoice was paid on. |
| PayeeCounty | This field displays the County of the Payee for the check the invoice was paid on. |
| PayeeName | This field displays the name of the payee for a given A/P invoice. |
| PayeePostalCode | This field displays the Postal Code of the Payee for the check the invoice was paid on. |
| PayeeRegion | This field displays the Region of the Payee for the check the invoice was paid on. |
| PaymentPostingBranch | This field displays the Branch that posted the check the invoice was paid on. |
| PaymentPostingSequence | This field displays the posting sequence of the check the invoice was paid on. |
| PaymentTerm | This field displays the payment term attached to a given A/P invoice. |
| PaymentUser | This field displays the user who cut the check. |
| PaymentVoidedUser | This field displays the user who voided the check. |
| PostingBranch | This field displays the branch that posted the AP invoice. |
| PostingDate | This field displays the date on which an Accounts Payable invoice was posted. |
| PostingDescription | This field displays a posting description for an Accounts Payable invoice. |
| PostingPeriod | This field displays the posting period that was used to depreciate a fixed asset. |
| PostingReference | This field displays the posting reference number attached to an invoice. |
| ReferenceBranch | This field displays the branch of the reference number attached to the Invoice. |
| ReferenceType | This field displays the source type of the reference number (Parts Purchase Order, Miscellaneous Purchase Order, Local Purchase Order) |
| ReleasedDate | This field displays the date on which an A/P invoice was released. |
| ReleasedUser | This field displays the user who release the invoice from suspension. |
| IsReversed | this field displays whether or not an A/P invoice has been reversed. |
| Status | This field displays the status of a given A/P invoice. |
| IsSuspended | This field displays whether or not an A/P invoice has been suspended. |
| SuspendedDate | This field displays the date on which an A/P invoice was suspended. |
| SuspendedUser | This field displays the user who marked the Invoice as “suspended”. |
| Vendor | This field displays the vendor attached to a given A/P invoice. |
| VendorName | This field displays the name of the vendor attached to a given A/P invoice. |
| IsVoided | This field displays whether or not an A/P invoice has been voided. |
| VoidedDate | This field displays the date the AP invoice was voidied. |
| VoidedUser | This field displays the user who voided the AP Invoice. |