| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | CAM_REF_GUID | Reference Factor Unique Internal Key | varbinary | 16 | 0 | | | | |
| 3 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | | | |
| 4 | CAM_POOL_GUID | Expense Pool in CAM Recovery | varbinary | 16 | 0 | | | | |
| 5 | CAM_RO_GUID | Rental Object of CAM Pool | varbinary | 16 | 0 | | | | |
| 6 | VALIDFROM | Date: Measurement Valid From | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | VALIDTO | Date: Measurement Valid To | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | CAM_PERIOD_GUID | Rental Period GUID | varbinary | 16 | 0 | | | | |
| 9 | ROOBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 10 | CNOBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 11 | OCCCNOBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 12 | MTOCCUPATION | Major Tenant Occupation Indicator | char | 1 | 0 | | | | Allow NULL? |
| 13 | CHECKREDDENOM | Indicator for Reduce Denominator | char | 1 | 0 | | | | Allow NULL? |
| 14 | TERMNOPROV | Number of CAM Provision Terms | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | DENMETHOD | Denominator Method in CAM | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | DENMETHODINT | Internal Denominator Method in CAM | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | OCCUPIEDMEAS | Determination Based on Occupied Measurement Share | char | 1 | 0 | | | | Allow NULL? |
| 18 | PLENGTH | Number of days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 19 | DENMEAS | Denominator Measurement Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | MEASUNIT | Measurement Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | MEASVALUE | Measurement Amount | decimal | 17 | 4 | | | | |
| 22 | APPORTVALUE | Reference Factor for a Rental Unit | decimal | 20 | 8 | | | | |
| 23 | DENOMINATOR | Fixed Denominator | decimal | 15 | 2 | | | | |
| 24 | DENOMTHRESHOLD | Threshold | decimal | 9 | 2 | | | | |
| 25 | FIXEDSHARE | Fixed Share | decimal | 15 | 2 | | | | |
| 26 | LOC_KEY | Regional Location Key for Heating Value Days | nvarchar | 10 | 0 | | | | Allow NULL? |