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