| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RVERS | Consolidation version | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | CFIND | Indicator: Carryforwards allowed for this version | char | 1 | 0 | | | | Allow NULL? |
| 4 | RCOPY | Ind: Maintenance Allowed by Copying Local Valuation Values | char | 1 | 0 | | | | Allow NULL? |
| 5 | TVUMR | Version for currency translation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | TVCUR | Version for exchange rates | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | TVKAP | Version for consolidation of investments method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 8 | TVBTG | Version for changes in investments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | TVKPP | Version for changes in investee equity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | TVRES | Version for hidden reserves | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | TVERG | Version for equity holdings adjustments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | TVSKO | Version for IC elimination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | TVUMG | Version for reclassifications | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | TVZGE | Version for eliminating intercompany profit and loss | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | TVABG | Version for asset transfers within group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | LOCAL | : only via Integration Manager, X:can only be pstd via FISL | char | 1 | 0 | | | | Allow NULL? |
| 17 | TVFIX | Version for selected FS items | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | GVWFLAG | Flag to indicate appropr. of retained earnings on bal. sheet | char | 1 | 0 | | | | Allow NULL? |
| 19 | RCOPYEXT | Permit Maintenance by Copying of Posting Records | char | 1 | 0 | | | | Allow NULL? |