| 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 | WAEGR | Translation method | nvarchar | 5 | 0 | CHAR | (N' ') | No | T884M | UMR_METH | Allow NULL? |
| 3 | ART | Rounding indicator | char | 1 | 0 | CHAR | (N' ') | No | | UMR_ROUND | Allow NULL? |
| 4 | SEQNO | Sequence number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | UMR_SEQNO | Allow NULL? |
| 5 | SNAM1 | FS item set 1 | nvarchar | 34 | 0 | CHAR | (N' ') | No | | UMR_SNAM1 | Allow NULL? |
| 6 | SNAM2 | TTy set | nvarchar | 34 | 0 | CHAR | (N' ') | No | | UMR_SNAM2 | Allow NULL? |
| 7 | SNAM3 | FS item set 2 | nvarchar | 34 | 0 | CHAR | (N' ') | No | | UMR_SNAM3 | Allow NULL? |
| 8 | RTYPE | Exchange rate indicator | char | 1 | 0 | CHAR | (N' ') | No | | UMR_CUTYP | Allow NULL? |
| 9 | CMETH | Currency translation key | char | 1 | 0 | CHAR | (N' ') | No | | UMR_CUCME | Allow NULL? |
| 10 | ERGEH | Indicator: Affecting net income - Credit | char | 1 | 0 | CHAR | (N' ') | No | | UMR_XERGH | Allow NULL? |
| 11 | ERGES | Indicator: Affecting net income - Debit | char | 1 | 0 | CHAR | (N' ') | No | | UMR_XERGS | Allow NULL? |
| 12 | ITTYP | Set contains balance sheet items | char | 1 | 0 | CHAR | (N' ') | No | | UMR_BILSET | Allow NULL? |
| 13 | ITEMS | Debit item for the currency translation difference | nvarchar | 10 | 0 | CHAR | (N' ') | No | | UMR_ITEMS | Allow NULL? |
| 14 | ITEMH | Credit item for the currency translation difference | nvarchar | 10 | 0 | CHAR | (N' ') | No | | UMR_ITEMH | Allow NULL? |
| 15 | DIFRMVCT | Transaction type | nvarchar | 3 | 0 | CHAR | (N' ') | No | T856 | UMR_RMVCT | Allow NULL? |
| 16 | ERPRYEAR | Exchange rate from prior year | char | 1 | 0 | CHAR | (N' ') | No | | ERPRYEAR | Allow NULL? |
| 17 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF120 | FC_ITCLG | Allow NULL? |
| 18 | ITEM1 | Financial statement item | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_ITEM | Allow NULL? |
| 19 | ITEM2 | Financial statement item | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF100 | FC_ITEM | Allow NULL? |
| 20 | SITYP | Subitem category | nvarchar | 3 | 0 | CHAR | (N' ') | No | TF110 | FC_SITYP | Allow NULL? |
| 21 | SITEM | Subitem | nvarchar | 10 | 0 | CHAR | (N' ') | No | TF115 | FC_SITEM | Allow NULL? |
| 22 | EXIT | Name of exit for user-defined exchange rate determination | nvarchar | 3 | 0 | CHAR | (N' ') | No | | LC_EXIT_CT | Allow NULL? |
| 23 | DTPCU | Break down translation differences by partner unit | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DTPCU | Allow NULL? |
| 24 | DTCUR | Break down translation differences by transaction currency | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DTCUR | Allow NULL? |
