| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DIMEN | Dimension | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | CMETH | Method | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | SEQNO | Sequence number in a method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | ITSET1 | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 7 | SISET1 | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 8 | SITYP1 | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | ITSET2 | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 10 | SISET2 | Identification of a set | nvarchar | 34 | 0 | | | | Allow NULL? |
| 11 | SITYP2 | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | SITYP | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | ODIFITD | Debit item for posting other differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | ODIFITC | Credit item for posting other differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 15 | CDIFITD | Debit item for currency translation differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | CDIFITC | Credit item for currency translation differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | ODIFSTD | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | ODIFSTC | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 19 | CDIFSTD | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | CDIFSTC | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | ODIFSID | Debit subitem for posting other differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | ODIFSIC | Credit subitem for posting other differences | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | CDIFSID | Subitem for translation differences (debits) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 24 | CDIFSIC | Subitem for translation differences (credits) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | ITG1IND | Post the difference to this item set | char | 1 | 0 | | | | Allow NULL? |
| 26 | ITG2IND | Post the difference to this item set | char | 1 | 0 | | | | Allow NULL? |
