Retrieves rent increase amount records for the RealEstateManagement schema.

View-Specific Information

The RentIncreaseAmounts view provides read-only access to JD Edwards rent increase batch data from the RealEstateManagement 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 (GLOffset, BusinessUnit, UserCode, UserReference, UserID, ProgramID, CurCod, ...): support =, !=, LIKE, and IN.
• Numeric columns (BatchNumber, OrderNumber, LeaseVersion, LineNumber, GrossAmount, UserAmount, UserNumber, TimeUpdated): support =, !=, <, <=, >, >=, and IN.
• Date columns (BeginDate, EndingDate, UserDate, DateUpdated): support =, !=, <, <=, >, >=, and IN. Two conditions on the same date column can be combined to express a range.
• Single-character text columns (FD): stored as a String with a maximum length of 1: support =, !=, and IN.

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

SELECT * FROM RentIncreaseAmounts WHERE OrderNumber = 7001 AND BeginDate >= '2024-01-01' AND BusinessUnit = '200'

Columns