| 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 | T000 | MANDT | Allow NULL? |
| 2 | RCOMP | Company | nvarchar | 6 | 0 | CHAR | (N' ') | No | T880 | RCOMP_D | Allow NULL? |
| 3 | TRANS | Data transfer to the FI-LC System | char | 1 | 0 | CHAR | (N' ') | No | | FKTRANS | Allow NULL? |
| 4 | ACCNT | Indicator: enter account | char | 1 | 0 | CHAR | (N' ') | No | | KZ_ACCNT | Allow NULL? |
| 5 | ACSET | Financial statement version | nvarchar | 4 | 0 | CHAR | (N' ') | No | T011 | ACSET | Allow NULL? |
| 6 | PASET | Prefix for trading partner set | nvarchar | 4 | 0 | CHAR | (N' ') | No | | VBNDSETPRF | Allow NULL? |
| 7 | CHHB1 | Validation group for local valuation | char | 1 | 0 | CHAR | (N' ') | No | T857N | CHHB1 | Allow NULL? |
| 8 | CHHB2 | Valididation group for corporate valuation | char | 1 | 0 | CHAR | (N' ') | No | T857N | CHHB2 | Allow NULL? |
| 9 | SORT1 | Sort key 1 | char | 1 | 0 | CHAR | (N' ') | No | T850A | SORTFKA1 | Allow NULL? |
| 10 | SORT2 | Sort key 2 | char | 1 | 0 | CHAR | (N' ') | No | T850A | SORTFKA2 | Allow NULL? |
| 11 | SORT3 | Sort key 3 | char | 1 | 0 | CHAR | (N' ') | No | T850A | SORTFKA3 | Allow NULL? |
| 12 | REASN | Reason for inclusion in/exclusion from consolidation | nvarchar | 2 | 0 | CHAR | (N' ') | No | | REASN_FK | Allow NULL? |
| 13 | RPGRP | Data entry form group | nvarchar | 4 | 0 | CHAR | (N' ') | No | T857D | RPGRP | Allow NULL? |
| 14 | FYEAR | Year of first consolidation | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | RYEAR_FK | Allow NULL? |
| 15 | FPERI | Period of first consolidation | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERID_FK | Allow NULL? |
| 16 | GPERI | Period for the start of goodwill amortization | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PERID_AFAG | Allow NULL? |
| 17 | COCAT | Type of data to be supplied by company | char | 1 | 0 | CHAR | (N' ') | No | | COCAT | Allow NULL? |
| 18 | VALIDHB1 | Validation name for local valuation checks | nvarchar | 7 | 0 | CHAR | (N' ') | No | GB93 | VALIDHB1 | Allow NULL? |
| 19 | VALIDHB2 | Validation name for corporate valuation checks | nvarchar | 7 | 0 | CHAR | (N' ') | No | GB93 | VALIDHB2 | Allow NULL? |
| 20 | UPLOAD | FI-LC: Upload financial reporting data | char | 1 | 0 | CHAR | (N' ') | No | | FK_UPLOAD | Allow NULL? |
| 21 | IMPORT | FI-LC: Import Reporting Data indicator | char | 1 | 0 | CHAR | (N' ') | No | | FK_IMPORT | Allow NULL? |
| 22 | CHDBASE | Validation group for DBase PC data entry | char | 1 | 0 | CHAR | (N' ') | Yes | T857N | LC_CHDBASE | Allow NULL? |
| 23 | AFTYP | Additional field category | nvarchar | 4 | 0 | CHAR | (N' ') | No | T85Y | FK_AFTYP | Allow NULL? |
