|
This data object is used to display all accounts payable vendor information from the Fusion business system.
This information is located in the Accounts Payable Vendor program within the Fusion business system.
URL
/frw/APVendor
Field Details…
| SQL Field Name | Column Description |
|---|---|
| Is1099Required | This field displays whether or not a 1099 form is required, matching setting found in the vendor record. |
| AddDate | This field displays the date in which the vendor was added into Fusion. |
| AddUser | This field displays the user name of the individual who added the vendor into Fusion. |
| APGroup | This field displays the Accounts Payable Group assigned to the given A/P Vendor. |
| CellPhone | This field displays the A/P vendor’s cell phone number. |
| CompanyName | This field displays the company name of an A/P vendor. |
| ControlBranch | This field displays the designated control branch from the vendor record. |
| CurrencyCode | This field displays the currency code assigned to the vendor. |
| AmountDue30 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 31-60 days past the due date of the invoice. |
| AmountDue60 | the field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 61-90 days past the due date of the invoice. |
| AmountDue90 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 91-120 days past the due date of the invoice. |
| AmountDueNow | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 1-30 days past the due date of the invoice. |
| AmountDueOver120 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are more than 120 days past the due date of the invoice. |
| AmountNotDue | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are less than one day past the due date of the invoice. |
| This field displays the A/P vendor’s email address. | |
| EstablishedDate | This field displays the date on which an A/P vendor was established. |
| Fax | This field displays the A/P vendor’s fax number. |
| Inactive | This field displays whether or not a given A/P vendor is set to inactive. |
| InvoiceDateAmountDue30 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 31-60 days past the invoice date of the invoice. |
| InvoiceDateAmountDue60 | the field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 61-90 days past the invoice date of the invoice. |
| InvoiceDateAmountDue90 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 91-120 days past the invoice date of the invoice. |
| InvoiceDateAmountDueNow | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are 1-30 days past the invoice date of the invoice. |
| InvoiceDateAmountDueOver120 | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are more than 120 days past the invoice date of the invoice. |
| InvoiceDateAmountNotDue | This field displays the total balance due for all A/P invoices with a status equal to “posted” and that are less than one day past the invoice date of the invoice. |
| LastUpdateDate | This field displays the date in which the given vendor was last updated. |
| LastUpdateUser | This field displays the user name of the individual who last updated the given vendor. |
| IsMiscellaneousAccount | This field displays whether a vendor is flagged as a miscellaneous vendor. |
| OfficePhone | This field displays the Office Phone number of the Vendor. |
| PaidPreviousYTD | This field displays the total of all payments made to a vendor for the previous fiscal year. |
| PaidYTD | This field displays the total of all unvoided check amounts written to a vendor in the current calendar year. |
| PaymentTerms | This field displays payment terms associated with a given vendor. |
| Address1 | This field displays the address line one of the vendor found on the Physical tab of A/P Vendor. |
| Address2 | This field displays the address line two of the vendor found on the Physical tab of A/P Vendor. |
| City | This field displays the city of the vendor found on the Physical tab of A/P Vendor. |
| PhysicalContactName | This field displays the physical contact name for an A/P vendor. |
| PhysicalCountry | This field displays the country of the vendor found on the Physical tab of A/P Vendor. |
| PhysicalCounty | This field displays the county of the vendor found on the Physical tab of A/P Vendor. |
| PostalCode | This field displays the postal code of the vendor found on the Physical tab of A/P Vendor. |
| Region | This field displays the region of the vendor found on the Physical tab of A/P Vendor. |
| PurchasesPreviousYTD | This field displays the total amount of all invoices for a vendor for the previous fiscal year. |
| PurchasesYTD | This field displays the total of all unvoided invoice amounts for a vendor in the current fiscal year. |
| QuickLookup | This field displays the quick look up name assigned to the vendor. |
| RemitToAddress1 | This field displays the Remit-To address line one of the vendor found on the Remit-To tab of A/P Vendor. |
| RemitToAddress2 | This field displays the Remit-To address line two of the vendor found on the Remit-To tab of A/P Vendor. |
| RemitToAllowEmail | This field displays the value of the allow email check box of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToCellPhone | This field displays the cell phone of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToCity | This field displays the Remit-To city of the vendor found on the Remit-To tab of A/P Vendor. |
| RemitToContactName | This field displays the Remit To contact name for an A/P vendor. |
| RemitToCountry | This field displays the country of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToCounty | This field displays the county of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToEmail | This field displays the email of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToFax | This field displays the fax of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToOfficePhone | This field displays the office phone of the vendor found on the Remit To tab of A/P Vendor. |
| RemitToPostalCode | This field displays the Remit-To postal code of the vendor found on the Remit-To tab of A/P Vendor. |
| RemitToRegion | This field displays the Remit-To region of the vendor found on the Remit-To tab of A/P Vendor. |
| RemitToShopPhone | This field displays the shop phone of the vendor found on the Remit To tab of A/P Vendor. |
| ShipToAddress1 | This field displays the Ship-To address line one of the vendor found on the Ship-To tab of A/P Vendor. |
| ShipToAddress2 | This field displays the Ship-To address line two of the vendor found on the Ship-To tab of A/P Vendor. |
| ShipToAllowEmail | This field displays the value of the allow email check box of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToCellPhone | This field displays the cell phone of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToCity | This field displays the Ship-To city of the vendor found on the Ship-To tab of A/P Vendor. |
| ShipToContactName | This field displays the Ship To contact name for an A/P vendor. |
| ShipToCountry | This field displays the country of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToCounty | This field displays the county of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToEmail | This field displays the email of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToFax | This field displays the fax of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToOfficePhone | This field displays the office phone of the vendor found on the Ship To tab of A/P Vendor. |
| ShipToPostalCode | This field displays the Ship-To postal code of the vendor found on the Ship-To tab of A/P Vendor. |
| ShipToRegion | This field displays the Ship-To region of the vendor found on the Ship-To tab of A/P Vendor. |
| ShipToShopPhone | This field displays the shop phone of the vendor found on the Ship To tab of A/P Vendor. |
| ShopPhone | This field displays the A/P vendor’s shop phone number. |
| TaxpayerIdentificationNumber | This field displays a vendor’s taxpayer identification number. |
| TotalAmount | This field displays the total balance due for all A/P invoices with a status equal to “posted”. |
| APVendor | This field displays the Account number of the given A/P Vendor. |
| VendorComment | This field displays comments related to accounts payable vendors. |