Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...
Fields | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Created By |
Database Field: ERPx_APTransactionHeader.CreatedBy | ||||||||||||||||
Created Date |
Database Field: ERPx_APTransactionHeader.CreatedDate | ||||||||||||||||
Currency ID |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Company Currencies. Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK | ||||||||||||||||
Discount Date | Identifies the date the discount expires. It is based on the number of discount days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of discount days set up on the selected Payment Terms. This is not required and only editable by changing the Payment Terms assigned to the transaction. Database Field: ERPx_APTransactionHeader.DiscountDate | ||||||||||||||||
Due Date | Identifies the date payment is due. It is based on the number of days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of days set up on the selected Payment Terms. This is required and only editable by changing the Payment Terms assigned to the transaction. Database Field: ERPx_APTransactionHeader.DueDate | ||||||||||||||||
GL Date |
Database Field: ERPx_APTransactionHeader.GLDate | ||||||||||||||||
Last Updated |
Database Field: ERPx_APTransactionHeader.LastUpdated | ||||||||||||||||
Last User |
Database Field: ERPx_APTransactionHeader.LastUser | ||||||||||||||||
Pmt./Apply Hold | Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is an editable text box that defaults as blank and is always editable, even for posted transactions as long as they have not yet been fully applied.
Database Field: ERPx_APTransactionHeader.IsOnApplicationHold | ||||||||||||||||
Transaction Class |
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK | ||||||||||||||||
TransactionSK |
Database Field: ERPx_APTransactionHeader.TransactionHeaderSK | ||||||||||||||||
Vendor ID |
Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
...
Toolbar Icons | Description | ||||||||||||||||
Delete |
| ||||||||||||||||
Excel |
| ||||||||||||||||
New |
| ||||||||||||||||
Fields | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Checkbox |
| ||||||||||||||||
Description |
Database Field: ERPx_APTransactionLine.LineDescription | ||||||||||||||||
Distributed To |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Vendors, Employees and Projects. Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK | ||||||||||||||||
Extended |
Database Field: ERPx_APTransactionLine.ExtendedAmount | ||||||||||||||||
Price |
Database Field: ERPx_APTransactionLine.Price | ||||||||||||||||
Purchase Account |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' GL Accounts. Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK | ||||||||||||||||
Quantity |
Database Field: ERPx_APTransactionLine.Quantity | ||||||||||||||||
UOM |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Units of Measure. Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
...