Retrieves contract revenue summary records for the ContractBilling schema.

View-Specific Information

The ContractRevenueSummary view provides read-only access to JD Edwards contract revenue data from the ContractBilling 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 (OrTy, OrderCo, ContractChangeNumber, OwnerPayItem, ProgramID, UserID, ...): support =, !=, LIKE, and IN.
• Numeric columns (OrderNumber, LineNumber, Century, CurrentAmount, CurrentForeignAmount, CurrentUnits, CumulativeAmount, ...): support =, !=, <, <=, >, >=, and IN.
• Date columns (GLDate, DateUpdated): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.

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

SELECT * FROM ContractRevenueSummary WHERE OrderNumber = 12345 AND GLDate >= '2024-01-01'

Columns