| 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 | DIMEN | Dimension | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF150 | FC_DIMEN | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 4 | CTRGR | Translation method | nvarchar | 5 | 0 | CHAR | (N' ') | No | TF550 | FC_CTRGR | Allow NULL? |
| 5 | RNDIN | Rounding entry | char | 1 | 0 | CHAR | (N' ') | No | | FC_RNDIN | Allow NULL? |
| 6 | SEQNR | Sequence number in a method | nvarchar | 3 | 0 | CHAR | (N' ') | No | | FC_SEQNO | Allow NULL? |
| 7 | ISET1 | Item set 1 | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | FC_ISET1 | Allow NULL? |
| 8 | STYP2 | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 9 | SSET2 | Subitem set | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | FC_SSET2 | Allow NULL? |
| 10 | ISET3 | Item set 2 | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | FC_ISET3 | Allow NULL? |
| 11 | ERTIN | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | Yes | TF420 | FC_EXRIND | Allow NULL? |
| 12 | CTKEY | Currency translation key | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CTKEY | Allow NULL? |
| 13 | ERPYR | Use the exchange rate from the prior year | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ERPYR | Allow NULL? |
| 14 | AVGER | Use average exchange rate for reductions | char | 1 | 0 | CHAR | (N' ') | No | | FC_AVGER | Allow NULL? |
| 15 | ITEMD | Item - debit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_ITEMD | Allow NULL? |
| 16 | ITEMC | Item - credit | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF100 | FC_ITEMC | Allow NULL? |
| 17 | AIDIN | Affects earnings-Dr | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_AIDIN | Allow NULL? |
| 18 | AICIN | Affects earnings - credit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_AICIN | Allow NULL? |
| 19 | BSIIN | Set contains balance sheet items | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_BSIIN | Allow NULL? |
| 20 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TF110 | FC_SITYP | Allow NULL? |
| 21 | SITEM | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TF115 | FC_SITEM | Allow NULL? |
| 22 | UEXIT | Name of exit for user-defined exchange rate determination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | FC_UEXIT | Allow NULL? |
| 23 | GVREF | State consolidated value at the reference exchange rate | char | 1 | 0 | CHAR | (N' ') | No | | FC_GVREF | Allow NULL? |
| 24 | TDIFF | Disclosure of Temporal Translation Differences | char | 1 | 0 | CHAR | (N' ') | No | | FC_TDIFF | Allow NULL? |
| 25 | DTPCU | Break down translation differences by partner unit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DTPCU | Allow NULL? |
| 26 | DTCUR | Break down translation differences by transaction currency | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DTCUR | Allow NULL? |
