Retrieves account ledger transactions for the AccountsPayable schema.

View-Specific Information

The AccountLedger view provides read-only access to JD Edwards account ledger transactions 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 (e.g., DocCo, DoTy, LineExtension, AccountNumber, ExplanationAlphaName, InvoiceNumber, ...): support =, !=, LIKE, and IN.
• Numeric columns (DocumentNumber, RegisterNumber, Amount, BatchNumber, AddressNumber, ...): support =, !=, <, <=, >, >=, and IN.
• Date columns (GLDate, DateUpdated): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.
• Single-character text columns (PC): stored as a String with a maximum length of 1: support =, !=, and IN.

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

SELECT * FROM AccountLedger WHERE GLDate > '2024-01-01' AND GLDate <= '2024-12-31' AND BusinessUnit = '100'

Columns