| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DOCTY | Document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | RVERS | Consolidation version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 4 | RLEVL | Posting level | char | 1 | 0 | | | | Allow NULL? |
| 5 | PLACT | Ind: 0 = Act. 1 = Plan, SPACE = Rollup | char | 1 | 0 | | | | Allow NULL? |
| 6 | TCURR | Post in transaction currency | char | 1 | 0 | | | | Allow NULL? |
| 7 | LCURR | Post in local currency | char | 1 | 0 | | | | Allow NULL? |
| 8 | GCURR | Post in group currency | char | 1 | 0 | | | | Allow NULL? |
| 9 | BLSHI | Indicator: Post to balance sheet items | char | 1 | 0 | | | | Allow NULL? |
| 10 | PRLOI | Indicator: Post to income statement items | char | 1 | 0 | | | | Allow NULL? |
| 11 | STATI | Indicator: Post to statistical items | char | 1 | 0 | | | | Allow NULL? |
| 12 | BALAN | Balance check for consolidation document | char | 1 | 0 | | | | Allow NULL? |
| 13 | RESUL | Indicator: Post result effect? | char | 1 | 0 | | | | Allow NULL? |
| 14 | DTAXD | Credit deferred income taxes? | char | 1 | 0 | | | | Allow NULL? |
| 15 | DTAXC | Debit deferred income taxes? | char | 1 | 0 | | | | Allow NULL? |
| 16 | NORNG | Number range | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | CUTYP | Exch.rate indicator f.transl. transactions to group currency | char | 1 | 0 | | | | Allow NULL? |
| 18 | TAXIN | Indicator: No calculation of average deferred tax rate | char | 1 | 0 | | | | Allow NULL? |
| 19 | QNTIN | Indicator: Post quantities | char | 1 | 0 | | | | Allow NULL? |
| 20 | ADTIN | Indicator: Use of additional fields | char | 1 | 0 | | | | Allow NULL? |
| 21 | AUTRV | Automatic reversal in subsequent period/year | char | 1 | 0 | | | | Allow NULL? |
| 22 | CLR_ITEM | Clearing item for cross-company posting | nvarchar | 10 | 0 | | | | Allow NULL? |