| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SCS_ROCN_GUID | Rental Object or Contract, Depending on Rental | varbinary | 16 | 0 | | | | |
| 3 | SCS_RO_GUID | Rental Object for an SU, Period and Measurement Type | varbinary | 16 | 0 | | | | |
| 4 | OBJTYPE | Object Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | OBJNR | Object Number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 6 | ADD_OBJNR | Object Number for Additional Account Assignment | nvarchar | 22 | 0 | | | | Allow NULL? |
| 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | PTO | Period End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | PURPOSE | Purpose of Apportionment | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | | | | |
| 12 | CNTRIGGER_GUID | Which Object (Usually RO) is Trigger for This Entry | varbinary | 16 | 0 | | | | |
| 13 | PLENGTH | Number of days | nvarchar | 6 | 0 | | | | Allow NULL? |
| 14 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 16 | SCS_PERIOD_GUID | Rental Periods | varbinary | 16 | 0 | | | | |
| 17 | PERIODOTHERGUID | Other, Different Rental Period | varbinary | 16 | 0 | | | | |
| 18 | APPORTVALUE | Reference Factor | decimal | 20 | 8 | | | | |
| 19 | APPORTVALUEOPT | Part of the Reference Factor that Opts | decimal | 20 | 8 | | | | |
| 20 | APPORTVALUERO | Sum of Reference Factors of Lower-Level Objects | decimal | 20 | 8 | | | | |
| 21 | APPORTVALUEOPTRO | Sum of Opting Reference Factors of Lower-Level Objects | decimal | 20 | 8 | | | | |
| 22 | CURRENCY | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 23 | NETAMOUNT | Net Amount | decimal | 22 | 8 | | | | |
| 24 | NONDEDTAXAMT | Non-Deductible Tax Amount | decimal | 22 | 8 | | | | |
| 25 | DEDTAXAMOUNT | Deductible Tax Amount | decimal | 22 | 8 | | | | |
| 26 | HAS_COSTS | Costs Were Posted on the Object | char | 1 | 0 | | | | Allow NULL? |
| 27 | HASCOP | Uses Current Occupancy Principle | char | 1 | 0 | | | | Allow NULL? |
| 28 | PARTTYPE | Type of Service Charge Settlement Participation | char | 1 | 0 | | | | Allow NULL? |
| 29 | TENANT_SHARE | Tenant Share per SU as Percentage | decimal | 5 | 2 | | | | |
| 30 | OWNER_SHARE | Share of Owner, per Service Charge Key, as Percent | decimal | 5 | 2 | | | | |
| 31 | HAS_LIMITATION | Limitation of Settlement Participation | char | 1 | 0 | | | | Allow NULL? |
| 32 | NET_AMOUNT_REAL | Net Amount | decimal | 22 | 8 | | | | |
| 33 | DEDUCT_TAX_REAL | Non-Deductible Tax Amount | decimal | 22 | 8 | | | | |
| 34 | MAXCOSTSU | Maximum Costs Value per Settlement Unit for SCS | decimal | 15 | 2 | | | | |
| 35 | BASE | Basis for Calculation of All-Inclusive Rent | char | 1 | 0 | | | | Allow NULL? |
| 36 | BASEAMOUNT | Basis Amount for Part-Inclusive Rent | decimal | 15 | 2 | | | | |
| 37 | BASEDATE | Date of Base Year Settlement | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | IS_TAX | Value added tax indicator | char | 1 | 0 | | | | Allow NULL? |
| 39 | TOTAL_NETAMOUNT | Net Amount Without Special Agreement | decimal | 15 | 2 | | | | |
| 40 | TOTAL_DEDTAXAMT | Deductible Tax Amount Without Special Agreement | decimal | 15 | 2 | | | | |
| 41 | TOTAL_NONDEDTAX | Non-Deductible Tax Amount Without Special Agreement | decimal | 15 | 2 | | | | |
| 42 | CHRGPERC | Percentage Surcharge Added to Settlement Result | decimal | 5 | 2 | | | | |
| 43 | CHRGDETLEVEL | Level of Determining Surcharge | nvarchar | 2 | 0 | | | | Allow NULL? |
| 44 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | | | | Allow NULL? |
| 45 | CHRGNETAMOUNT | Net Surcharge Amount | decimal | 15 | 2 | | | | |
