| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SCS_ROCN_GUID | Rental Object or Contract, Depending on Rental | varbinary | 16 | 0 | RAW | | No | | RESCROCNGUID | |
| 3 | SCS_RO_GUID | Rental Object for an SU, Period and Measurement Type | varbinary | 16 | 0 | RAW | | Yes | VISCS_SU_RO | RESCROGUID | |
| 4 | OBJTYPE | Object Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | RECAOBJTYPE | Allow NULL? |
| 5 | OBJNR | Object Number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RECAOBJNR | Allow NULL? |
| 6 | ADD_OBJNR | Object Number for Additional Account Assignment | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | RERAADDOBJNR | Allow NULL? |
| 7 | PFROM | Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODFROM | Allow NULL? |
| 8 | PTO | Period End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RECAPERIODTO | Allow NULL? |
| 9 | PURPOSE | Purpose of Apportionment | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TIVSCPURPOSE | RESCFORPURPOSE | Allow NULL? |
| 10 | MEAS | Measurement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVBDMEAS | REBDMEAS | Allow NULL? |
| 11 | SETTL_GUID | Unique Key of Settlement | varbinary | 16 | 0 | RAW | | Yes | * | RECASETTLGUID | |
| 12 | CNTRIGGER_GUID | Which Object (Usually RO) is Trigger for This Entry | varbinary | 16 | 0 | RAW | | Yes | | RESCTRIGGERGUID | |
| 13 | PLENGTH | Number of days | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | VVATAGE | Allow NULL? |
| 14 | CONDTYPE | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDCONDTYPE | RECDCONDTYPE | Allow NULL? |
| 15 | FLOWTYPE | Flow Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TIVCDFLOWTYPE | RECDFLOWTYPE | Allow NULL? |
| 16 | SCS_PERIOD_GUID | Rental Periods | varbinary | 16 | 0 | RAW | | Yes | VISCS_RENT | RESCPERIODGUID | |
| 17 | PERIODOTHERGUID | Other, Different Rental Period | varbinary | 16 | 0 | RAW | | Yes | | RESCPERIODOTHERGUID | |
| 18 | APPORTVALUE | Reference Factor | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUE | |
| 19 | APPORTVALUEOPT | Part of the Reference Factor that Opts | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUEOPTING | |
| 20 | APPORTVALUERO | Sum of Reference Factors of Lower-Level Objects | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUESUM | |
| 21 | APPORTVALUEOPTRO | Sum of Opting Reference Factors of Lower-Level Objects | decimal | 20 | 8 | DEC | ((0)) | Yes | | RESCAPPORTVALUEOPTINGSUM | |
| 22 | CURRENCY | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 23 | NETAMOUNT | Net Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNETAMOUNT | |
| 24 | NONDEDTAXAMT | Non-Deductible Tax Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNONDEDTAXAMT | |
| 25 | DEDTAXAMOUNT | Deductible Tax Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCDEDTAXAMT | |
| 26 | HAS_COSTS | Costs Were Posted on the Object | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOSTS | Allow NULL? |
| 27 | HASCOP | Uses Current Occupancy Principle | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASCOP | Allow NULL? |
| 28 | PARTTYPE | Type of Service Charge Settlement Participation | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCPARTTYPE | Allow NULL? |
| 29 | TENANT_SHARE | Tenant Share per SU as Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | RESCPTENANT | |
| 30 | OWNER_SHARE | Share of Owner, per Service Charge Key, as Percent | decimal | 5 | 2 | DEC | ((0)) | Yes | | RESCPOWNER | |
| 31 | HAS_LIMITATION | Limitation of Settlement Participation | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCHASLIMITATION | Allow NULL? |
| 32 | NET_AMOUNT_REAL | Net Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNETAMOUNTREAL | |
| 33 | DEDUCT_TAX_REAL | Non-Deductible Tax Amount | decimal | 22 | 8 | DEC | ((0)) | Yes | | RESCNONITAXREAL | |
| 34 | MAXCOSTSU | Maximum Costs Value per Settlement Unit for SCS | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCSMAXCOSTSU | |
| 35 | BASE | Basis for Calculation of All-Inclusive Rent | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCSBASE | Allow NULL? |
| 36 | BASEAMOUNT | Basis Amount for Part-Inclusive Rent | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCSBASEAMOUNT | |
| 37 | BASEDATE | Date of Base Year Settlement | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RESCSBASEDATE | Allow NULL? |
| 38 | IS_TAX | Value added tax indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | JMWST | Allow NULL? |
| 39 | TOTAL_NETAMOUNT | Net Amount Without Special Agreement | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCNETAMOUNTTOTAL | |
| 40 | TOTAL_DEDTAXAMT | Deductible Tax Amount Without Special Agreement | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCDEDTAXAMTTOTAL | |
| 41 | TOTAL_NONDEDTAX | Non-Deductible Tax Amount Without Special Agreement | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCNONDEDTAXAMTTOTAL | |
| 42 | CHRGPERC | Percentage Surcharge Added to Settlement Result | decimal | 5 | 2 | DEC | ((0)) | Yes | | RESCCHRGPERC | |
| 43 | CHRGDETLEVEL | Level of Determining Surcharge | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RESCCHRGDETLEVEL | Allow NULL? |
| 44 | FIXFITCHARACT | Fixtures and Fittings Characteristic | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | REBDFIXFITCHARACT | Allow NULL? |
| 45 | CHRGNETAMOUNT | Net Surcharge Amount | decimal | 15 | 2 | CURR | ((0)) | Yes | | RESCCHRGNETAMOUNT | |
