Commitments dashboard
Item
Value
Index
028
ID
CRECM01,1,1,1
Domain
REM
Tab
Commitments
Title
Multi year, contract income and expenditure review/ forecast
Drill-down from ID
-
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Bar: sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures)
Line: sum of AmountExclVat for IsPaymentContractLine = ‘N’ (Income)
KPI type
Totals
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
029
ID
CRECM01,1,1,2,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure review/ forecast
Drill-down from ID
CRECM01,1,1,1 (bar)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures), stacked by contract type (Leasecontract, Servicecontract etc.)
KPI type
Totals
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
030
ID
CRECM01,1,1,2,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income review/ forecast
Drill-down from ID
CRECM01,1,1,1 (line)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income), stacked by contract type (Leasecontract, Servicecontract etc.)
KPI type
Totals
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
031
ID
CRECM01,1,1,3,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure details review/ forecast
Drill-down from ID
CRECM01,1,1,2,E
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures), stacked by contracts
KPI type
Totals
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
032
ID
CRECM01,1,1,3,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income details review/ forecast
Drill-down from ID
CRECM01,1,1,2,I
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income), stacked by contracts
KPI type
Totals
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
033
ID
CRECM01,1,2,1
Domain
REM
Tab
Commitments
Title
Multi year, contract income and expenditure review/ forecast
Drill-down from ID
-
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Bar: sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field NetLettableArea.
Line: sum of AmountExclVat for IsPaymentContractLine = ‘N’ (Income) / PropertyDetails field NetLettableArea.
Active PropertyDetails row based on Reference date.
KPI type
Per m2 RFA
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
034
ID
CRECM01,1,2,2,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure review/ forecast
Drill-down from ID
CRECM01,1,2,1 (bar)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field NetLettableArea, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per m2 RFA
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
035
ID
CRECM01,1,2,2,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income review/ forecast
Drill-down from ID
CRECM01,1,2,1 (line)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails field NetLettableArea, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per m2 RFA
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
036
ID
CRECM01,1,2,3,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure details review/ forecast
Drill-down from ID
CRECM01,1,2,2,E
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field NetLettableArea, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per m2 RFA
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
037
ID
CRECM01,1,2,3,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income details review/ forecast
Drill-down from ID
CRECM01,1,2,2,I
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails field NetLettableArea, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per m2 RFA
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
038
ID
CRECM01,1,3,1
Domain
REM
Tab
Commitments
Title
Multi year, contract income and expenditure review/ forecast
Drill-down from ID
-
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Bar: sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field ActualNumbeOfPeople.
Line: sum of AmountExclVat for IsPaymentContractLine = ‘N’ (Income) / PropertyDetails field ActualNumbeOfPeople.
Active PropertyDetails row based on Reference date.
KPI type
Per headcount
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
039
ID
CRECM01,1,3,2,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure review/ forecast
Drill-down from ID
CRECM01,1,3,1 (bar)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field ActualNumbeOfPeople, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per headcount
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
040
ID
CRECM01,1,3,2,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income review/ forecast
Drill-down from ID
CRECM01,1,3,1 (line)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails field ActualNumbeOfPeople, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per headcount
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
041
ID
CRECM01,1,3,3,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure details review/ forecast
Drill-down from ID
CRECM01,1,3,2,E
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails field ActualNumbeOfPeople, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per headcount
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
042
ID
CRECM01,1,3,3,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income details review/ forecast
Drill-down from ID
CRECM01,1,3,2,I
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails field ActualNumbeOfPeople, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per headcount
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
043
ID
CRECM01,1,4,1
Domain
REM
Tab
Commitments
Title
Multi year, contract income and expenditure review/ forecast
Drill-down from ID
-
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Bar: sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails fields NumberOfCubicleWorkStations; NumberOfOfficeWorkStations; NumberOfHotDeskWorkStations; NumberOfMeetingRoomWorkStations.
Line: sum of AmountExclVat for IsPaymentContractLine = ‘N’ (Income) / PropertyDetails field ActualNumbeOfPeople.
Active PropertyDetails row based on Reference date.
KPI type
Per workstation
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
044
ID
CRECM01,1,4,2,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure review/ forecast
Drill-down from ID
CRECM01,1,4,1 (bar)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails fields NumberOfCubicleWorkStations; NumberOfOfficeWorkStations; NumberOfHotDeskWorkStations; NumberOfMeetingRoomWorkStations, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per workstation
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
045
ID
CRECM01,1,4,2,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income review/ forecast
Drill-down from ID
CRECM01,1,4,1 (line)
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails fields NumberOfCubicleWorkStations; NumberOfOfficeWorkStations; NumberOfHotDeskWorkStations; NumberOfMeetingRoomWorkStations, stacked by contract type (Leasecontract, Servicecontract etc.).
Active PropertyDetails row based on Reference date.
KPI type
Per workstation
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
046
ID
CRECM01,1,4,3,E
Domain
REM
Tab
Commitments
Title
Multi year, contract expenditure details review/ forecast
Drill-down from ID
CRECM01,1,4,2,E
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘Y’ (Expenditures) / PropertyDetails fields NumberOfCubicleWorkStations; NumberOfOfficeWorkStations; NumberOfHotDeskWorkStations; NumberOfMeetingRoomWorkStations, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per workstation
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract
Item
Value
Index
047
ID
CRECM01,1,4,3,I
Domain
REM
Tab
Commitments
Title
Multi year, contract income details review/ forecast
Drill-down from ID
CRECM01,1,4,2,I
Filter
ContractLine cashflow for specific year
Review: at <reference date year> - 4 to <reference date year>
Forecast: at <reference date year> to <reference date year> + 4
Contract of type:
UsrServiceContract',
'UsrInsuranceContract',
'UsrPermit',
'UsrTax',
'UsrDepreciation',
'UsrFinancing',
'UsrLegalCharge'
Selected value for ContractLine.NormCostCategoryRef (Cost category)
Selected value for Contractline.NormCostTypeRef (Cost type)
Selected properties
X-axis
Year
Y-axis
Business object: ContractCashflow
Sum of AmountExclVat for IsPaymentContractLine = ‘F’ (Income) / PropertyDetails fields NumberOfCubicleWorkStations; NumberOfOfficeWorkStations; NumberOfHotDeskWorkStations; NumberOfMeetingRoomWorkStations, stacked by contracts.
Active PropertyDetails row based on Reference date.
KPI type
Per workstation
Extra info
ContractCashflow is linked to ContractLine
ContractLine is linked to Contract