| 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 | SETTL_GUID | Generic Key of Process | varbinary | 16 | 0 | RAW | | No | VICAPROCESSID | RECAPROCESSGUID | |
| 3 | SETTLMODE | Settlement Method | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TIVSCSETTLMODE | RECASETTLMODE | Allow NULL? |
| 4 | SETTLTYPE | Settlement type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TIVSCSETTLTYPE | RESCSTYPE | Allow NULL? |
| 5 | PURPOSE | Settlement Purpose | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCSEPURPOSE | Allow NULL? |
| 6 | FLG_REVERSAL | Reversal indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | VSSTORNO | Allow NULL? |
| 7 | PFROM | Start of Settlement Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RESCSETTLEVALIDFROM | Allow NULL? |
| 8 | PTO | Date Up to Which Settlement Should Be Performed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RESCSETTLTO | Allow NULL? |
| 9 | SPOOLNR | Spool number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | VVSPONR | Allow NULL? |
| 10 | SANPNR | | nvarchar | 3 | 0 | | (N'000') | Yes | | | Allow NULL? |
| 11 | HEADERTXT | Document Header Text | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RERAHEADERTXT | Allow NULL? |
| 12 | PSTNGDATE | Posting Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERAPSTNGDATE | Allow NULL? |
| 13 | DOCDATE | Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RERADOCDATE | Allow NULL? |
| 14 | BLINEDATE | Baseline date for due date calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VVDZFBDT | Allow NULL? |
| 15 | DTAPE_ACCESS | Reading Method for DME Data | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCTAPECREATETYPE | Allow NULL? |
| 16 | DTAPE_NAME | Name of DME File | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | RESCFILENAME_READ | Allow NULL? |
| 17 | MLTAPE_SORTBY | Output of M/L Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | RESCHSMLTSORTBY | Allow NULL? |
| 18 | MLTAPE_ACCESS | Saving Method for DME Data | char | 1 | 0 | CHAR | (N' ') | Yes | | RESCLOCALSERVER | Allow NULL? |
| 19 | MLTAPE_NAME | Name of DME File | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | RESCFILENAME_WRITE | Allow NULL? |
| 20 | LAST_STEP | Internal Name of Settlement Step | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RESCSSETTLSTEP | Allow NULL? |
| 21 | PARAMKEY | Settlement Schema | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RESCPARAMKEY | Allow NULL? |
| 22 | DOCCOUNTER | Document Counter | int | 10 | 0 | INT4 | ((0)) | Yes | | RERADOCCOUNTER | Allow NULL? |
| 23 | AJPROCESSGUID | Generic Key of Adjustment Run Within SCS | varbinary | 16 | 0 | RAW | | Yes | | RESCAJPROCESSGUID | |
| 24 | KEYDATECOP | Key Date for Current Occupancy Principle | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RESCKEYDATECOP | Allow NULL? |
| 25 | TAXDATE | Date for defining tax rates | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | TXDAT | Allow NULL? |
| 26 | CHRGPERC | Percentage Surcharge Added to Settlement Result | decimal | 5 | 2 | DEC | ((0)) | Yes | | RESCCHRGPERCSETTLEMENT | |
| 27 | VERSION | Version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | COVERSI | Allow NULL? |
| 28 | MEASKEYDATE | Key Date for Determination of Measurement Amount | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RESCMEASKEYDATE | Allow NULL? |
