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