Custom Reports
The custom report creator allows the user to create fully customizable reports on both assets and contract. Reports can be customized by selecting which specific fields the user would like to include in the report while also allowing the user to implement constraints on which assets or contracts should be included in the reporter. Reports are created using individual fields to specify what you want included in the report and the way in which you view each field can be modified within the creator. Filters can also be placed on the reports as to specialize which assets the user wishes to display in the report. The constraints are unique for assets and contracts as are fields. The creator also allows the user to name, save, duplicate, generate, and download the report as an excel spreadsheet.
Creating a Basic Report
From the Top NavBar, select Reporting.
Once in the Reporting workspace, go the Custom Reports tab.
-
Under the Standard Reports header, click Custom Report to build a new report.
-
First, select the Data Source from which to pool your data by clicking Add Data Source.
-
In the pop-up, choose the Data Source from the drop-down. This forms the basis of your report, as any other data added into the report stems from this initial data source.
Asset: Full set of asset records in system
Contract: Full set of payable and receivable contracts recorded in system
Invoice: Full set of payable and receivable invoices in system
-
Click Add.
-
Once you’ve selected the initial Data Source, specific fields related to your chosen data source will appear.
To include a field in your report, select it from the left Available Fields section and drag and drop it to the right Report Columns section.
You may continue to drag and drop available fields to your report columns as necessary. You may either scroll through the list of Available Fields or use the search function to locate the desired fields.
If you want to add another Data Source, you may click Add Data Source again and select another option to display specific fields for that data source.
-
Some fields may have additional options that will pop up when selected and moved to the Report Columns section.
You may reorder the fields in the Report Columns section simply by dragging and dropping to desired order.
-
Once a field is in the Report Columns section, it may be customized by changing the title, alignment, size, and even color of the column.
-
You may further customize your report by specifying any grouping or sorting by clicking the gear icon in the Structure field, which will open the Grouping and Sorting pop-up.
-
If you would like to freeze the first (or more) column(s), you may indicate that in the Freeze first field.
-
Name your custom report at the top of the workspace.
-
This is also where you can choose what to do next with your report.
The globe icon permits all users to view this custom report.
The save icon saves the custom report for it to be ran or edited at a later date.
The duplicate icon saves a new report.
The download icon will download the report to an Excel spreadsheet.
The paperclip icon allows you to import an excel template for the report.
Advanced Custom Report Functions
If you would like to further customize your report, Real Estate Manager offers the ability to add filters, manual calculations, and static columns.
Adding Filters to the Report
Fields simply add columns to the report, they do not implement any criteria that discriminate between which asset (or contracts for example) should be displayed in the report. This is done by adding filters. Filters serve the purpose of adding constraints to the report so that if you want to put only certain assets or contracts into the report, it is possible.
-
Once you’ve selected a Data Source and chosen your desired fields, click the Add Filter button within the Data Source box.
-
From the Filter drop-down, select the first row to filter on. The choices in the drop-down will include all fields you’ve selected from the chosen data source.
Click Add.
-
In the next pop-up, select the relevant values to filter for.
Click Save. The filter will be added to the Data Source box and will be applied when generating the report.
Generate Custom Report with Cost Per Area for Contract Data Source
-
Navigate to Reporting > Create New Report > Create New Custom Report to view the Custom Report Builder.
Under Contract data source, update the Report Columns for the contract.
Enable Include Cost Per Area in the filter section.
-
Choose a standard unit (e.g., convert per Sq. M to per Sq. Ft) for conversion. It is optional.
Click Confirm. A pop-up appears to select the report format.
-
Select the report format and click Generate.
-
In My Jobs, download the output to view:
Per Annum Cost
Cost Per Area (Original Unit) — e.g., per acre
Converted Cost Per Area — e.g., per square meter
-
Reports display Cost Per Area in a two-column format:
A numeric value (e.g., 85.00)
A measurement unit (e.g., per Sq. Ft, per Sq. M)
The system automatically recalculates values when unit conversion is applied. This logic applies to both individual and total costs for consistency.
Automated Email Delivery for Custom Reports
Real Estate Manager allows you to receive custom reports directly via email when they're completed, eliminating the need to manually check back for finished reports. You can choose between automatic email delivery with a simple one-click option or the traditional download process based on your preferences. Completed reports are always available for download from the system regardless of your chosen delivery method, providing flexible access to your generated reports.
To automate email delivery for custom reports, follow the below steps:
Log into Real Estate Manager and navigate to the Custom Reports section.
Locate the custom report you want to generate from the list.
Click the Email link next to the report name (this bypasses the report editor screen for faster processing). The system automatically queues your report job with email delivery enabled.
-
You'll receive an email notification with:
Appropriate subject line indicating the completed report.
The report file as an attachment.
Delivery to your registered email address.
You can also download the report from the job results page in the system or use the standard download workflow.
Choosing Your Delivery Method
For Email Delivery: Click Emailnext to any built-in custom report - the report will be automatically sent to your email upon completion.
For Traditional Download: Click Export to use the existing download-only workflow - the report will be available for download from the job results page.
Good to Know
Your email address is automatically synchronized with your user profile and uses your registered email address only. You cannot configure email delivery to other users' addresses. If your email address changes, log back into the system to sync the update.
Email delivery is currently available for custom reports only; standard reports continue to use existing download workflows.
Email jobs are processed in the same queue as regular report jobs. Failed or incomplete jobs will not send emails. All successfully completed reports remain downloadable from the system, regardless of email delivery method.
Adding Additional Data Sources
Additional data sources may be added to the report, such as asset contracts. These can be added when you already have a data source selected, such as asset, added to the report. This is done by selecting the data source button again which will give you options to add additional data sources. The additional data source selected will feed off the already loaded data source, meaning that if you have initially selected asset as your data source, asset contracts (the newly selected data source) will be related to the previous source, hence in this case meaning that the contracts loaded into the reports will be related to the user’s assets. Both data sources will now appear at the top of the workspace. As with the original data source, new fields are available to add to the report and constraints/ filters can be applied to the new data source.
Manual Calculation
Manual calculations may be performed on certain fields and then added to the report. These calculations will be visible in the report as its own column.
Click the calculator icon in the top right corner of the Report Columns section.
-
In the pop-up, select which report column will be used by clicking Add column and choosing the field from the available choices in the drop-down.
In the Formula field, enter the simple calculation that will be used to generate this column. The formula can include column values and the mathematical operators for multiplication, division, addition, and subtraction. Parenthesis are supported.
For Aggregation, you may select to use the formula entered or a simple sum function.
Click Confirm.
You will see a new field called Manual Calculation. This name may be changed by clicking in the name field and editing as necessary.
To make any changes to your formulas, click the gear icon to display the pop-up.
Once the report is exported to Excel, the calculation will be performed and appear in its own column.
Managing Standard Report Types
To simplify reporting and ensure consistency, 7 pre-configured standard report templates are available. These templates include pre-selected fields that enable users to quickly analyze key areas such as assets, contracts, vendors, portfolio performance, and payments.
The following are the available standard report types:
Lease Accounting Significant Contract Report
Contract Renewal Option Report
Leased Asset Portfolio Report
Owned Asset Portfolio Report
Document Repository Report
Contract Clause Report
Payment Review Report
For detailed information about each report, refer to the Standard Report Types section.
How to Use Standard Reports
Access Standard Reports
Log into Real Estate Manager and navigate to the Custom Reports section.
Standard reports are listed under Custom Reports and labeled as Standard Report Type.
Customize a Standard Report (Optional)
Click Edit next to the desired standard report.
Review the pre-selected fields designed to analyze the portfolio.
Add additional fields if needed
-
Click Save. Once saved, the customized report appears under Saved Reports Type with a Global tag.
Generate and Share Reports
Click Export to run the report based on the selected filters.
Click Email to send the report directly via email.
-
Click Delete to delete the saved report type.
Note: Delete option is available only for the saved or customized report types. The standard report templates cannot be deleted.
Data Sources for Custom Reports
Data Source |
Description |
|---|---|
Parent Data Source: Asset |
Asset location and Custom Fields for Assets |
Asset Contract |
Contract information, including Contract definitions and costs |
Asset Contractors |
Contractor roles and Certifications |
Asset Costs |
Costs defined on Contracts and Invoices |
Asset File |
Files uploaded for an Asset |
Asset Invoices |
Information on Asset Invoices |
Asset Invoice Costs |
Information in an Invoice Cost section |
Asset Invoice Vendor |
Information about Vendors on Invoices |
Asset Valuations |
Valuations added for the Asset |
Parent Data Source: Contract |
Contract information and Custom Fields |
Contract Asset |
Information about the Asset, including Custom Fields |
Contract Clauses |
Clauses attached to the Contract |
Contract File |
Files uploaded for a Contract |
Contract Invoices |
Invoices related to a Contract |
Contract Invoice Costs |
Cost information for Contract Invoices |
Contract Invoices (row filter) |
Invoices related to Contracts with row filters of filter by contract invoice costs and filter by contract invoices |
Contract Leased Asset Details |
Information from leased assets specific to Lease Accounting Significant contracts |
Parent Data Source: Invoice |
Invoice information and Custom Fields |
Invoice Costs |
Costs for an Invoice |
Invoice Vendor |
Vendor Information for an Invoice |
Available Field Types
| Icon | Name |
Description |
|---|---|---|
Multi-Line |
Field consumes multiple lines on the report. |
|
Text |
Characters are text, including numeric. |
|
Configurable |
Field requires you to specify certain definitions or requirements. |
|
Numeric |
Numeric characters that can be used in calculations. |
|
Checkbox |
Field is binomial and data consists of one of two choices. |
|
Monetary |
Field is a monetary value. |
|
Date |
Field is a date. |
Available Fields by Data Source
Data Source: Asset | ||
|---|---|---|
Address (Full) |
Currency Code |
Marketing for Sublease (Y/N) |
Address City |
Current Index |
Measurement Field Test |
Address Country |
Date Assignment/Sublet Requested |
Method of Notice Comments |
Address Country Code |
Division |
Multi-Tenant (Y/N) |
Address Latitude |
Electrical |
Name |
Address Line 1 |
Electrical – Comments |
Notes |
Address Line 2 |
Elevator – Warranty Expiration Date |
Occupied (Y/N) |
Address Longitude |
Elevator Repairs |
OPEX/CAMS Base Year |
Address Postcode |
Entity |
OPEX/CAMS Comments |
Address State |
Exposure (N/E/S/W) |
Ownership |
Address State (Abbrv) |
Exterior Doors |
Parent Name |
Approval Date |
Exterior Doors – Comments |
Parking Lot |
Archive Date |
Fire Alarm (Y/N) |
Parking Lot – Comments |
Area available for Sublease |
Fire Sprinklers (Y/N) |
Permission Required (Y/N) |
Asset Files (List) |
Floors in Building |
Previous Index |
Asset Files with Path (List) |
Floors Occupied |
Primary Use |
Asset Owner |
Force Majeure Clause Exists |
Property Tax Comments |
Asset Type |
Force Majeure Comments |
RE Comments |
Asset User |
Foundations |
RE Status |
Assignment/Sublet Lease Reference |
Foundations – Comments |
RE Strategy |
Assignment/Sublet Primary Contact |
FTE Capacity |
Reference Number |
Assignment/Sublet Project Manager |
FTE Headcount |
Rentable Area (Gross) |
Assignment/Sublet Status |
Full Name |
Rentable Area UOM |
Attached Contracts (List) |
Gross-up (Y/N) |
Request Made (Y/N) |
Base Index |
HVAC – Warranty Expiration Date |
Return Date |
Boiler – Warranty Expiration Date |
HVAC Maintenance |
Roof |
Boiler Repairs |
HVAC Maintenance – Comments |
Roof – Comments |
Building Area |
HVAC Repairs |
Roof – Warranty Expiration Date |
Building Area UOM |
HVAC Replacement |
Roof Repairs |
Business Unit |
HVAC Replacement – Comments |
Security Alarm (Y/N) |
Child Assets – SQM (List) |
Index Base Date |
Security Guards (Y/N) |
Co-Tenancy |
Index Type |
Status |
Co-Tenancy – Comments |
Indexed Adjustment Date |
Subdivision |
Co-Tenancy – Tenant List |
Land Area |
Tenant Default |
Co-Tenancy Clause Exists |
Landlord Default |
Usable Area UOM |
Common Areas |
Lease Abstracted By |
Usable Area (Net) |
Common Areas – Comments |
Lease Fully Abstracted (Y/N) |
Year Build |
Construction Type |
Lease Last Update Date |
Zoning |
Currency |
Lease Reference |
|
Data Source: Asset Contract | ||
|---|---|---|
Approval Date |
Current – Selected Costs |
Next Option – End |
Assignment/Sublet Lease Reference |
Current – Selected Costs – Total |
Next Option – Exercise End |
Assignment/Sublet Project Manager |
Current – Selected Costs P.A. |
Next Option – Exercise Start |
Assignment/Sublet Status |
Current – Selected Costs P.A. – Total |
Next Option – Name |
Audit Restriction Comments |
Current Index |
Next Option – Start |
Base Index |
Current Option Duration – Months |
Next Option Duration – Months |
Break Clause Summary |
Current option Duration – Text |
Next Option Duration – Text |
Break Cluse – Expands |
Current Review – All Costs P.A. – Total |
Next Review – Costs (Expands) |
Building Area |
Current Review – Effective Date |
Next Review – Date |
Commencement – All Costs P.A. – Total |
Current Review - Notes |
Next Review – Notes |
Commencement – Other Costs P.A. - Total |
Current Review – Review Date |
Next Review – State |
Commencement – Selected Costs |
Current Review – Type |
Next Review – Type |
Commencement – Selected Costs – Total |
Current Term End |
Notes |
Commencement – Selected Costs P.A. |
Current Term Start |
OPEX/CAMS Base Amount |
Commencement – Selected Costs P.A. – Total |
Deadline to dispute/audit/settle |
OPEX/CAMS Base Year |
Commencement Costs – Summary |
Description |
OPEX/CAMS Comments |
Contract Absolute Duration – Months |
Gross-up (Y/N) |
Options – Expands |
Contract Absolute Duration – Text |
Gross-up % |
Other Party |
Contract Absolute Expiry Date |
Guarantees (Expands) |
Percentage of area unoccupied by tenant |
Contract Commencement Date |
Historical Costs – Summary |
Permission Required for Assignment/Sublet (Y/N) |
Contract Current Duration – Months |
HR Site ID |
Previous Index |
Contract Current Duration – Text |
In Holdover |
Pro Rata Share %-Bldg |
Contract Direction |
Index Base Date |
Pro Rata Share %-Site |
Contract Expiry Date |
Index Type |
Property Tax Comments |
Contract Files (List) |
Indexed Adjustment Comments |
RE Comments |
Contract Files with Path (List) |
Indexed Adjustment Date |
RE Status |
Contract Liability |
Is Archived |
Reference Number |
Contract Options Detail |
Lease Abstracted By |
Request for Assignment/Sublet Made (Y/N) |
Contract Type |
Lease Fully Abstracted (Y/N) |
Restrictions on who can perform audit? (Y/N) |
Contracting Party |
Lease Last Update Date |
Tax Base Amount |
Contractor |
Lease Reference |
Tax Base Year |
Currency |
Lease Reviewed/Approved By |
Total Liability (ex Tax) |
Currency Code |
Liability End |
Total Liability (inc Tax) |
Current – All Costs – Summary |
Liability Start |
Total Tax Liability |
Current – Other Costs P.A. - Total |
Measurement Field Test |
Unoccupied Area |
Data Source: Asset Contractors | ||
|---|---|---|
Certifications - Expands |
Fully Certified? |
|
Contractor – Expands |
Role Name |
|
Data Source: Asset Costs |
||
Category |
Currency |
Periodic Cost Total (Invoices) |
Category is Gross? |
Group |
Periodic Costs (Contracted) |
Cost Direction |
Periodic Cost Total (Contracts) |
Periodic Costs (Invoiced) |
Data Source: Asset Valuations |
||
Valuations |
||
Data Source: Asset Invoice Costs |
||
Apportionment Splits |
Cost Category |
Tax Amount |
Asset |
Cost Category Ledger Code |
Tax Jurisdiction |
Asset Address |
Incurred End Date |
Tax Rate Multiplier |
Asset Description |
Incurred Start Date |
Tax Rate Name |
Base Amount |
Label |
Total Amount |
Data Source: Asset Invoice Vendor |
||
Contact Short Name |
LA Roles |
Phone 1 |
Currencies |
Mobile |
Phone 2 |
Name |
||
Fax |
Notes |
|
Data Source: Asset Invoices |
||
AP Export Status |
Invoice Recurrence Frequency |
Payment Batch File Name |
Cost Categories |
Invoice Recurrence Pattern |
Payment Batch Last Action Date |
Currency |
Invoice Type |
Payment Batch Last Action Performed By User |
Description |
Is Multi Asset |
Payment Batch Last Action Performed By Username |
Invoice Date |
Linked Contract |
Payment Batch Last Action Type |
Invoice Direction |
Notes |
Total Base (ex Tax) |
Invoice Group |
Payee Code |
Total Tax (ex Tax) |
Invoice Number |
Payment Batch Description |
Vendor |
Approval Date |
Current – Other Costs P.A. - Total |
Liability Start |
Archive Date |
Current – Selected Costs |
Measurement Field Test |
Assignment/Sublet Lease Reference |
Current – Selected Costs – Total |
Next Option – End |
Assignment/Sublet Project Manager |
Current – Selected Costs P.A. |
Next Option – Exercise End |
Assignment/Sublet Status |
Current – Selected Costs P.A. – Total |
Next Option – Exercise Start |
Audit Restriction Comments |
Current Index |
Next Option – Name |
Available for Use Date |
Current Option Duration – Months |
Next Option – Start |
Base Index |
Current option Duration – Text |
Next Option Duration – Months |
Break Clause Summary |
Current Review – All Costs P.A. – Total |
Next Option Duration – Text |
Break Clause – Expands |
Current Review – Effective Date |
Next Review – Costs (Expands) |
Data Source: Asset Costs | ||
|---|---|---|
Category |
Currency |
Periodic Cost Total (Invoices) |
Category is Gross? |
Group |
Periodic Costs (Contracted) |
Cost Direction |
Periodic Cost Total (Contracts) |
Periodic Costs (Invoiced) |
Data Source: Asset Valuations | ||
|---|---|---|
Valuations |
||
Data Source: Asset Invoice Costs | ||
|---|---|---|
Apportionment Splits |
Cost Category |
Tax Amount |
Asset |
Cost Category Ledger Code |
Tax Jurisdiction |
Asset Address |
Incurred End Date |
Tax Rate Multiplier |
Asset Description |
Incurred Start Date |
Tax Rate Name |
Base Amount |
Label |
Total Amount |
Data Source: Asset Invoice Vendor | ||
|---|---|---|
Contact Short Name |
LA Roles |
Phone 1 |
Currencies |
Mobile |
Phone 2 |
Name |
||
Fax |
Notes |
|
Data Source: Asset Invoices | ||
|---|---|---|
AP Export Status |
Invoice Recurrence Frequency |
Payment Batch File Name |
Cost Categories |
Invoice Recurrence Pattern |
Payment Batch Last Action Date |
Currency |
Invoice Type |
Payment Batch Last Action Performed By User |
Description |
Is Multi Asset |
Payment Batch Last Action Performed By Username |
Invoice Date |
Linked Contract |
Payment Batch Last Action Type |
Invoice Direction |
Notes |
Total Base (ex Tax) |
Invoice Group |
Payee Code |
Total Tax (ex Tax) |
Invoice Number |
Payment Batch Description |
Vendor |
Approval Date |
Current – Other Costs P.A. - Total |
Liability Start |
Archive Date |
Current – Selected Costs |
Measurement Field Test |
Assignment/Sublet Lease Reference |
Current – Selected Costs – Total |
Next Option – End |
Assignment/Sublet Project Manager |
Current – Selected Costs P.A. |
Next Option – Exercise End |
Assignment/Sublet Status |
Current – Selected Costs P.A. – Total |
Next Option – Exercise Start |
Audit Restriction Comments |
Current Index |
Next Option – Name |
Available for Use Date |
Current Option Duration – Months |
Next Option – Start |
Base Index |
Current option Duration – Text |
Next Option Duration – Months |
Break Clause Summary |
Current Review – All Costs P.A. – Total |
Next Option Duration – Text |
Break Clause – Expands |
Current Review – Effective Date |
Next Review – Costs (Expands) |
Data Source: Contract | ||
|---|---|---|
Building Area |
Current Review – Type |
Next Review – Date |
Commencement – All Costs P.A. – Total |
Current Term End |
Next Review – Notes |
Commencement – Other Costs P.A. - Total |
Current Term Start |
Next Review – State |
Commencement – Selected Costs |
Deadline to dispute/audit/settle |
Next Review – Type |
Commencement – Selected Costs – Total |
Depreciation Start Date |
Notes |
Commencement – Selected Costs P.A. |
Description |
OPEX/CAMS Base Amount |
Commencement – Selected Costs P.A. – Total |
Effective Contract Termination Date |
OPEX/CAMS Base Year |
Commencement Costs – Summary |
First Payment Date |
OPEX/CAMS Comments |
Contract Absolute Duration – Months |
GL Code |
Options – Expands |
Contract Absolute Duration – Text |
Gross-up (Y/N) |
Other Party |
Contract Absolute Expiry Date |
Gross-up % |
Percentage of area unoccupied by tenant |
Current Review - Notes |
Guarantees (Expands) |
Permission Required for Assignment/Sublet (Y/N) |
Contract Commencement Date |
Historical Costs – Summary |
Previous Index |
Contract Current Duration – Months |
HR Site ID |
Pro Rata Share %-Bldg |
Contract Current Duration – Text |
In Holdover |
Pro Rata Share %-Site |
Contract Direction |
Index Base Date |
Property Tax Comments |
Contract Expiry Date |
Index Type |
RE Comments |
Contract Files (List) |
Indexed Adjustment Comments |
RE Status |
Contract Files with Path (List) |
Indexed Adjustment Date |
Reference Number |
Contract Liability |
Is Archived |
Request for Assignment/Sublet Made (Y/N) |
Contract Options Detail |
Is Contract Terminated |
Restrictions on who can perform audit? (Y/N) |
Contract Type |
LARR Status |
Tax Base Amount |
Contracting Party |
Lease Abstracted By |
Tax Base Year |
Contractor |
Lease Accounting Contract Type |
Total Liability (ex Tax) |
Cost Center |
Lease Fully Abstracted (Y/N) |
Total Liability (inc Tax) |
Currency |
Lease Last Update Date |
Total Tax Liability |
Currency Code |
Lease Reference |
Unoccupied Area |
Current – All Costs – Summary |
Lease Reviewed/Approved By |
|
Current Review – Review Date |
Liability End |
|
Data Source: Contract Asset | ||
|---|---|---|
Address (Full) |
Division |
Measurement Field Test |
Address City |
Effective Contract Termination Date |
Method of Notice Comments |
Address Country |
Electrical |
Multi-Tenant (Y/N) |
Address Country Code |
Electrical – Comments |
Name |
Address Latitude |
Elevator – Warranty Expiration Date |
Notes |
Address Line 1 |
Elevator Repairs |
Occupied (Y/N) |
Address Line 2 |
Entity |
OPEX/CAMS Base Year |
Address Longitude |
Exposure (N/E/S/W) |
OPEX/CAMS Comments |
Address Postcode |
Exterior Doors |
Ownership |
Address State |
Exterior Doors – Comments |
Parent Name |
Address State (Abbrv) |
Fire Alarm (Y/N) |
Parking Lot |
Approval Date |
Fire Sprinklers (Y/N) |
Parking Lot – Comments |
Area available for Sublease |
Floors in Building |
Permission Required (Y/N) |
Asset Files (List) |
Floors Occupied |
Previous Index |
Asset Files with Path (List) |
Force Majeure Clause Exists |
Primary Use |
Asset Type |
Force Majeure Comments |
Property Tax Comments |
Assignment/Sublet Lease Reference |
Foundations |
RE Comments |
Assignment/Sublet Primary Contact |
Foundations – Comments |
RE Status |
Assignment/Sublet Project Manager |
FTE Capacity |
RE Strategy |
Assignment/Sublet Status |
FTE Headcount |
Reference Number |
Attached Contracts (List) |
Full Name |
Rentable Area (Gross) |
Base Index |
Gross-up (Y/N) |
Rentable Area UOM |
Boiler – Warranty Expiration Date |
HVAC – Warranty Expiration Date |
Request Made (Y/N) |
Boiler Repairs |
HVAC Maintenance |
Return Date |
Building Area |
HVAC Maintenance – Comments |
Roof |
Building Area UOM |
HVAC Repairs |
Roof – Comments |
Business Unit |
HVAC Replacement |
Roof – Warranty Expiration Date |
Child Assets – SQM (List) |
HVAC Replacement – Comments |
Roof Repairs |
Co-Tenancy |
Index Base Date |
Security Alarm (Y/N) |
Co-Tenancy – Comments |
Index Type |
Security Guards (Y/N) |
Co-Tenancy – Tenant List |
Indexed Adjustment Date |
Status |
Date Assignment/Sublet Requested |
Is Contract Terminated |
Subdivision |
Co-Tenancy Clause Exists |
Land Area |
Tenant Default |
Common Areas |
Landlord Default |
Usable Area UOM |
Common Areas – Comments |
Lease Abstracted By |
Usable Area (Net) |
Construction Type |
Lease Fully Abstracted (Y/N) |
Year Build |
Currency |
Lease Last Update Date |
Zoning |
Currency Code |
Lease Reference |
|
Current Index |
Marketing for Sublease (Y/N) |
|
Data Source: Contract Clauses | ||
|---|---|---|
Amendment Clause Text |
Interpretation |
Reason |
Amendment Date |
Is Active |
Receivable From Contact |
Amount Payable |
Latest Invoke Date |
Recorded At Utc |
Amount Receivable |
Lease Page Number |
Recorded By User |
Area |
Notes |
Reminder Date |
Category |
Original Clause Text |
Section |
Clause |
Outcome |
Triggered On |
Comments |
Payable to Contact |
Year |
Documents |
PDF Page Number |
|
Earliest Invoke Date |
Percentage |
|
Data Source: Contract Invoice Costs | ||
|---|---|---|
Apportionment Splits |
Cost Category |
Tax Amount |
Asset |
Cost Category Ledger Code |
Tax Jurisdiction |
Asset Address |
Incurred End Date |
Tax Rate Multiplier |
Asset Description |
Incurred Start Date |
Tax Rate Name |
Base Amount |
Label |
Total Amount |
Data Source: Contract Invoices | ||
|---|---|---|
AP Export Status |
Invoice Number |
Payment Batch Description |
Contact Short Name |
Invoice Recurrence Frequency |
Payment Batch File Name |
Cost Categories |
Invoice Recurrence Pattern |
Payment Batch Last Action Date |
Currencies |
Invoice Type |
Payment Batch Last Action Performed By User |
Currency |
Is Multi Asset |
Payment Batch Last Action Performed By Username |
Description |
LA Roles |
Payment Batch Last Action Type |
Linked Contract |
Phone1 |
|
Fax |
Mobile |
Phone2 |
Invoice Date |
Name |
Total Base (ex Tax) |
Invoice Direction |
Notes |
Total Tax (ex Tax) |
Invoice Group |
Payee Code |
Vendor |
Data Source: Contract Option | ||
|---|---|---|
End |
Exercise Start |
Start |
Exercise End |
Name |
Term Notes |
Data Source: Contract Leased Asset Details | ||
|---|---|---|
Asset Owner |
Business Unit |
Entity |
Asset User |
Cost Center |
Fair Market Value |
Available For Use Start Date |
Depreciation Start Date |
GLCode |
Data Source: Invoices | ||
|---|---|---|
AP Export Status |
Invoice Recurrence Frequency |
Payment Batch Last Action Performed By User |
Cost Categories |
Invoice Recurrence Pattern |
Payment Batch Last Action Performed By Username |
Currency |
Invoice Type |
Payment Batch Last Action Type |
Description |
Is Multi Asset |
Phone1 |
GL Code |
Linked Contract |
Phone2 |
Invoice Date |
Notes |
Total Base (ex Tax) |
Invoice Direction |
Payee Code |
Total Tax (ex Tax) |
Invoice Group |
Payment Batch Description |
Vendor |
Invoice Number |
Payment Batch File Name |
|
Invoice Recurrence Frequency |
Payment Batch Last Action Date |
|
Data Source: Invoice Costs | ||
|---|---|---|
Apportionment Splits |
Cost Category |
Tax Amount |
Asset |
Cost Category Ledger Code |
Tax Jurisdiction |
Asset Address |
Incurred End Date |
Tax Rate Multiplier |
Asset Description |
Incurred Start Date |
Tax Rate Name |
Base Amount |
Label |
Total Amount |
Data Source: Invoice Vendor | ||
|---|---|---|
Contact Short Name |
LA Roles |
Phone 1 |
Currencies |
Mobile |
Phone 2 |
Name |
||
Fax |
Notes |
|