| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RCOMP | Company | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | TRANS | Data transfer to the FI-LC System | char | 1 | 0 | | | | Allow NULL? |
| 4 | ACCNT | Indicator: enter account | char | 1 | 0 | | | | Allow NULL? |
| 5 | ACSET | Financial statement version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | PASET | Prefix for trading partner set | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | CHHB1 | Validation group for local valuation | char | 1 | 0 | | | | Allow NULL? |
| 8 | CHHB2 | Valididation group for corporate valuation | char | 1 | 0 | | | | Allow NULL? |
| 9 | SORT1 | Sort key 1 | char | 1 | 0 | | | | Allow NULL? |
| 10 | SORT2 | Sort key 2 | char | 1 | 0 | | | | Allow NULL? |
| 11 | SORT3 | Sort key 3 | char | 1 | 0 | | | | Allow NULL? |
| 12 | REASN | Reason for inclusion in/exclusion from consolidation | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | RPGRP | Data entry form group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | FYEAR | Year of first consolidation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | FPERI | Period of first consolidation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | GPERI | Period for the start of goodwill amortization | nvarchar | 3 | 0 | | | | Allow NULL? |
| 17 | COCAT | Type of data to be supplied by company | char | 1 | 0 | | | | Allow NULL? |
| 18 | VALIDHB1 | Validation name for local valuation checks | nvarchar | 7 | 0 | | | | Allow NULL? |
| 19 | VALIDHB2 | Validation name for corporate valuation checks | nvarchar | 7 | 0 | | | | Allow NULL? |
| 20 | UPLOAD | FI-LC: Upload financial reporting data | char | 1 | 0 | | | | Allow NULL? |
| 21 | IMPORT | FI-LC: Import Reporting Data indicator | char | 1 | 0 | | | | Allow NULL? |
| 22 | CHDBASE | Validation group for DBase PC data entry | char | 1 | 0 | | | | Allow NULL? |
| 23 | AFTYP | Additional field category | nvarchar | 4 | 0 | | | | Allow NULL? |