Field / column | Description |
|---|---|
Code | Unique client business identifier for the contract line. The identifier should be supplied consistently between data loads. |
Type | Specifies the type of contract line, such as Passing rent, indicating the nature of the financial agreement. |
Start date | The start date of the contract line. The forecast will only calculate the cash flows starting from the latest start date Rentable Unit (related to the contract line) or Key handover date. |
Start full period | Defines the first date from which the contract line follows a complete, regular payment cycle according to its cash flow period (e.g., once every quarter). If no value is provided, the system calculates the next start full period after the contract line start date, based on the default start full period, the cash flow period, and the cash flow period time unit. If no default is provided, the start full period equals the contract line start date. |
NFA (Net Floor Area) | The total leased area (in square meters or feet) associated with this contract line. |
End date | The end date of the contract line. The end date of the contract line is capped at the contract’s expiry date, after applying the business logic defined in the expiry date field. |
Start date P&L | If not provided, the P&L start date is calculated based on the cash flow period or contract term, depending on the cost and revenue recognition method. For the cash accounting method, the P&L start date equals the cash flow date. |
End date P&L | If not provided, the P&L end date is calculated based on the cash flow period or contract term, depending on the cost and revenue recognition method. For the cash accounting method, the P&L end date equals the cash flow date. |
RU code (Rentable Unit code) | Reference code indicating the specific rentable unit associated with this contract line. If multiple units are involved, a Multiple (X) link appears. |
Address | Displays the location of the rentable unit or property. |
Rentable unit type | Displays the categorization of the rentable unit, such as Office, Retail, or Warehouse. |
Transaction currency | The currency in which the contract line cash flows are delivered. |
Cash flow | Displays the rental income associated with this contract line, typically on an annual basis (Per annum). You can select one of the following options: • per annum/quarter/month/week • m2 NFA p.a. / p.q./ p.m. / p.w. • m2 GFA p.a. / p.q./ p.m. / p.w. • m2 ITZA p.a. / p.q./ p.m. / p.w. • per unit p.a. / p.q./ p.m. / p.w. |
Payment method | Displays how cash flow is structured, such as In arrears (meaning payments are made after the rental period). |
Cash flow period | Displays the frequency of cash flow payments, such as Once every 1 year. |
General ledger code | The code used to map the cash flow calculates the correct line item in the financial statement for each contract line type. There is a one-to-one mapping between a contract line type and a financial statement line item. A mapping error can occur when a contract line is linked to a general ledger that does not correspond to the cash flow line. In such cases, the contract line will be mapped to a system-generated general ledger under the correct cash flow line. If this field is left empty, a system general ledger is created automatically. |
Index methodology | Displays the method used to adjust rent based on an index, such as inflation or market benchmarks. |
Next indexation | If the first indexation date is earlier than the process reference date, the next indexation date is calculated based on the index period defined in the indexation method. If no first indexation date is provided but an indexation method is specified for the contract line, the next indexation date is calculated using the default indexation month defined in the indexation method. This field is ignored if no indexation method is specified for the contract line. |
VAT scheme | The VAT scheme referenced corresponds to the cash flow amount of the contract line. This scheme is based on the configuration set per country in the application settings. If no value is provided, the cash flow is assumed to be exempt from VAT. |
Next review term | If the first review date is earlier than the process reference date, the next review date is calculated based on the review term. If no first review date is provided but the review rent type and review term are specified for the contract line, the next review date is calculated from the start date, offset by the review term. |
Term | The review term specifies the interval between consecutive rent reviews, expressed in months. It determines how often the rent is subject to review and potential adjustment according to the contract terms. |
Rent type | This field represents the review rent type applied when a cash flow adjustment is triggered by a rent review. It specifies the type of rent that will take effect from the rent review’s effective date. |