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 connector 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