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