Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...
Fields | Description | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Amount |
Database Field: ERPx_APTransactionHeader.ExtendedAmount | ||||||||||||||||||||||||||||||||||||||||
Description |
Database Field: ERPx_APTransactionHeader.Description | ||||||||||||||||||||||||||||||||||||||||
Doc Date |
Database Field: ERPx_APTransactionHeader.TransactionDate | Doc No | excerpt-The Doc Date must be on or before the GL Date when Approving or Posting the Invoice/Credit Memo. If not, the message "The GL Date must be on or after the Doc Date." will be displayed on Save. This field is always editable. Database Field: ERPx_APTransactionHeader.TransactionDate | ||||||||||||||||||||||||||||||||||||||
Doc No |
Database Field: ERPx_APTransactionHeader.DocNumber | ||||||||||||||||||||||||||||||||||||||||
Payment Terms |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms. Database Fields: ERPx_MFPaymentTerms.PaymentTermName, APTransactionHeader.PaymentTermSK | ||||||||||||||||||||||||||||||||||||||||
PO |
Database Field: ERPx_APTransactionHeader.PurchaseOrderID | ||||||||||||||||||||||||||||||||||||||||
Status |
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK | ||||||||||||||||||||||||||||||||||||||||
Vendor |
The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Vendors. Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
...
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 is disabled until the transaction is Posted. Prior to Posting, this field is only editable by changing the Payment Terms assigned to the transaction. Once enabled and if the field is updated, then it must be on or before the Due Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save. 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 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 is disabled until the transaction is Posted. Prior to Posting, this field is only editable by changing the Payment Terms assigned to the transactionassigned to the transaction. Once enabled and if the field is updated, then it must be on or before the Due Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save. Once enabled and if the field is updated, then it must be on or after the Discount Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save. 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 |
...