Retrieves payment proposal records for the AccountsPayable schema.

View-Specific Information

The ProposalOfPayment view provides read-only access to JD Edwards accounts payable payment proposals from the AccountsPayable schema. This view does not support insert, update, or delete operations.

Select

The add-in uses the JD Edwards API to process WHERE clause conditions for all columns in this table. All columns support server-side filtering via the JD Edwards QBE (Query By Example) mechanism.

The supported operators depend on the column data type:

• Text columns (DocCo, DoTy, PayItm, CurCod, BankAcctGL, BusinessUnit, InvoiceNumber, ...): support =, !=, LIKE, and IN.
• Numeric columns (DocumentNumber, PayExt, AddressNumber, PayeeNumber, OpenAmount, ExchangeRate, CurrencyAmount, AmountOpen): support =, !=, <, <=, >, >=, and IN.
• Date columns (InvoiceDate, DueDate, ...): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.
• Single-character text columns (PayInst, PayStat): stored as a String with a maximum length of 1: support =, !=, and IN.

For example, the following query is processed server-side:

SELECT * FROM ProposalOfPayment WHERE AddressNumber = 5001 AND DueDate <= '2024-12-31' AND PayStat = 'A'

Columns