| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ITEM | Consolidation item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | SPLIN | Indicator: partial breakdown | char | 1 | 0 | | | | Allow NULL? |
| 4 | FIXIN | Indicator: Selected FS item | char | 1 | 0 | | | | Allow NULL? |
| 5 | CONIN | Ind.: Item used only during consolidation | char | 1 | 0 | | | | Allow NULL? |
| 6 | AMOIN | Indicator: quantity | char | 1 | 0 | | | | Allow NULL? |
| 7 | ITSUM | Indicator: totals item | char | 1 | 0 | | | | Allow NULL? |
| 8 | SIGN | Debit/credit sign for consolidation item | char | 1 | 0 | | | | Allow NULL? |
| 9 | ITTYP | Asset/Liability/IncSt/Other | char | 1 | 0 | | | | Allow NULL? |
| 10 | CHAIN | Indicator: contra item | char | 1 | 0 | | | | Allow NULL? |
| 11 | TTYIN | Indicator: breakdown by transaction types | char | 1 | 0 | | | | Allow NULL? |
| 12 | YOAIN | Indicator: breakdown by years of acquisition | char | 1 | 0 | | | | Allow NULL? |
| 13 | ASCIN | Indicator: Breakdown by trading partners (affiliates) | char | 1 | 0 | | | | Allow NULL? |
| 14 | CURIN | Indicator: breakdown by currency | char | 1 | 0 | | | | Allow NULL? |
| 15 | ADFIN | Breakdown by additional field | char | 1 | 0 | | | | Allow NULL? |
| 16 | SETS | Definition of totals item | nvarchar | 60 | 0 | | | | Allow NULL? |
| 17 | ITCON | Contra item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 18 | NEWIT | New financial statement item number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | ALTIT | Reference item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | KZEIS | Indicator: Totals item for EIS reporting | char | 1 | 0 | | | | Allow NULL? |