Toolbar Icons | Description |
---|
Excel | Insert excerpt |
---|
| Excel - LV |
---|
| Excel - LV |
---|
nopanel | true |
---|
|
|
Favorites | Insert excerpt |
---|
| Favorites Add/Remove - Global |
---|
| Favorites Add/Remove - Global |
---|
nopanel | true |
---|
|
|
Grid Layout | Insert excerpt |
---|
| Grid Layout - Global |
---|
| Grid Layout - Global |
---|
nopanel | true |
---|
|
|
Help | Insert excerpt |
---|
| Help - Global |
---|
| Help - Global |
---|
nopanel | true |
---|
|
|
Inquiry Criteria | Insert excerpt |
---|
| Inquiry Criteria - Global |
---|
| Inquiry Criteria - Global |
---|
nopanel | true |
---|
|
- Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
- Date To: a text box to enter an ending Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
- Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: New, Approved, Ready To Post, Posted, Void, Deleted, Replaced. The default values are "New, Approved, Ready To Posted and Posted".
|
Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
Fields | Description |
Checkbox | Used to select one or more records. |
Currency | Insert excerpt |
---|
| HELP:Def: Currency |
---|
| HELP:Def: Currency |
---|
nopanel | true |
---|
|
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK |
Distributed To | Database Fields: ERPx_APVendor.VendorSK, ERPx_APTransactionLine.ToDistributionAccountSK |
Distributed To Type | Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN |
Doc Date | Database Field: ERPx_APTransactionHeader.TransactionDate |
Doc Description | Database Field: ERPx_APTransactionHeader.Description |
Doc No | Database Field: ERPx_APTransactionHeader.DocNumber |
Extended | Database Field: ERPx_APTransactionLine.ExtendedAmount |
GL Date | Database Field: ERPx_APTransactionHeader.GLDate |
GL Period | Database Fields: ERPx_MFFiscalPeriod.FiscalPeriodSK, ERPx_APTransactionHeader.GLDate |
GL Year | Database Fields: ERPx_MFFiscalPeriod.FiscalYearSK, ERPx_APTransactionHeader.GLDate |
Item Description | Database Field: ERPx_APTransactionLine.LineDescription |
Payable Account | Database Fields: ERPx_GLAccount.AccountSK, ERPx_ |
Payable Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_ |
Pmt./Apply Hold | Database Field: ERPx_APTransactionHeader.IsOnApplicationHold |
PO | Database Field: ERPx_APTransactionHeader.PurchaseOrderID |
Purchase Account | Database Fields: ERPx_GLAccount.AccountSK, ERPx_APVendor.APGLAcctRef |
Purchase Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef |
Quantity | Database Field: ERPx_APTransactionLine.Quantity |
Status | Database Fields: ERPx_APTransactionStatus.TransactionStatusSK, ERPx_APTransactionHeader.TransactionStatusSK |
Transaction | Database Field: ERPx_APTransactionHeader.TransactionHeaderID |
Transaction Class | Database Fields: ERPx_APTransactionClass.TransactionClassSK, ERPx_APTransactionHeader.TransactionClassSK |
Transaction Type | Database Field: ERPx_APTransactionType.TransactionTypeSK |
UOM | Database Fields: ERPx_IMItem.UOMSK, ERPx_APTransactionLine.QuantityUOMSK |
Vendor | Database Fields: ERPx_APVendor.VendorSK, ERPx_APTransactionHeader.VendorSK |
Vendor Class | Database Field: ERPx_APVendorClass.VendorClassSK, ERPx_APTransactionHeader.VendorSK |
Vendor Name | Database Field: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |