| 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 | COILV | Calculation base for the consolidation of investments | char | 1 | 0 | | | | Allow NULL? |
| 4 | INVVAL | Location of investment holdings values | char | 1 | 0 | | | | Allow NULL? |
| 5 | EQUVAL | Location of equity data | char | 1 | 0 | | | | Allow NULL? |
| 6 | EQIVAL | Location of data for subsequent equity consolidation | char | 1 | 0 | | | | Allow NULL? |
| 7 | ESHFLG | Net display of equity aging report | char | 1 | 0 | | | | Allow NULL? |
| 8 | ESHSIT | Subitem category for investee equity | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | ESHMDS | Debits subitem for minority interest | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | ESHMCS | Credits subitem for minority interest | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | NIPDFLG | Affect net income when posting partial divestitures | char | 1 | 0 | | | | Allow NULL? |
| 12 | NIIDFLG | Affect net income when reducing indirect investments | char | 1 | 0 | | | | Allow NULL? |
| 13 | ASSDT | Doc. type assignment | char | 1 | 0 | | | | Allow NULL? |
| 14 | PUACHK | Validation of Push-down Goodwill | char | 1 | 0 | | | | Allow NULL? |
| 15 | XRINDGWBS | Goodwill in Local Crcy: Exchange Rate Ind., Balance Sheet | char | 1 | 0 | | | | Allow NULL? |
| 16 | XRINDGWIS | Goodwill in Local Crcy: Exchange Rate Ind., Income Statement | char | 1 | 0 | | | | Allow NULL? |
| 17 | CTKEYGWIS | Goodwill in Local Crcy: Currency Trl. Key, Income Statement | char | 1 | 0 | | | | Allow NULL? |
| 18 | GWTBEGFLG | Currency Translation for Goodwill at Beginning of Period | char | 1 | 0 | | | | Allow NULL? |
| 19 | GWPROCDA | Treatment of Goodwill in Increases in Direct Investment | char | 1 | 0 | | | | Allow NULL? |
| 20 | GWPROCIA | Treatment of Goodwill in Increases in Indirect Investment | char | 1 | 0 | | | | Allow NULL? |
| 21 | NGPROCDA | Neg.GW Treatment in Incr.in Direct Invest.(exc. First Cons) | char | 1 | 0 | | | | Allow NULL? |
| 22 | NGPROCIA | Neg.GW Treatment in Increase in Indirect Investment | char | 1 | 0 | | | | Allow NULL? |
| 23 | LDTYR | Fiscal Year of Legacy Data Transfer | nvarchar | 4 | 0 | | | | Allow NULL? |
| 24 | LDTPE | Period of Legacy Data Transfer | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | NINVFLG | Enable negative investments | char | 1 | 0 | | | | Allow NULL? |
| 26 | NMINFLG | No calculation of minority interest | char | 1 | 0 | | | | Allow NULL? |
| 27 | HRREV | Procedure for eliminating hidden reserves/contingencies(FVA) | char | 1 | 0 | | | | Allow NULL? |
| 28 | HRSHA | Scope of elimination of hidden reserves/contingencies | char | 1 | 0 | | | | Allow NULL? |
| 29 | HRSITYP | Subitem category for hidden reserves (fair value adjustment) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 30 | HRAQDSI | Subitem for transferring hidden reserves (fair value adj.) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | HRDPCSI | Subitem for amortization of hidden reserves (fair value adj) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | HRDPDSI | Subitem for writeups of hidden reserves (fair value adj.) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | NHSITYP | Subitem category for hidden contingencies (fair value adj.) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | NHAQCSI | Subitem for transferring hidden contingencies (fair val.adj) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | NHDPDSI | Subitem for changes to hidden contingencies - debit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | NHDPCSI | Subitem for changes to hidden contingencies - credit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | GWAYR | Life of goodwill amortization in years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 38 | GWAPE | Life of goodwill amortization in months | nvarchar | 3 | 0 | | | | Allow NULL? |
| 39 | GWABG | Start date for the amortization of new goodwill | char | 1 | 0 | | | | Allow NULL? |
| 40 | GWARFLG | Amortize new goodwill over remaining life | char | 1 | 0 | | | | Allow NULL? |
| 41 | GWALFLG | Threshold value for the amortization of goodwill | char | 1 | 0 | | | | Allow NULL? |
| 42 | GWALVAL | Threshold value for the amortization of goodwill | decimal | 17 | 2 | | | | |
| 43 | GWALCUR | Group currency for threshold for goodwill amortization | nvarchar | 5 | 0 | | | | Allow NULL? |
| 44 | GWAMETH | Amortization method | char | 1 | 0 | | | | Allow NULL? |
| 45 | GWRYR | Life of the periodic reduction of goodwill - years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | GWRPE | Life of periodic reduction of goodwill - months | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | GWRBG | Beginning date of the periodic reduction of new goodwill | char | 1 | 0 | | | | Allow NULL? |
| 48 | GWRRFLG | Reduce the new goodwill over its remaining life | char | 1 | 0 | | | | Allow NULL? |
| 49 | GWRLFLG | Threshold value for the periodic reduction of goodwill | char | 1 | 0 | | | | Allow NULL? |
| 50 | GWRLVAL | Threshold value for the periodic reduction of goodwill | decimal | 17 | 2 | | | | |
| 51 | GWRLCUR | Group currency for threshold for periodic reduction of GW | nvarchar | 5 | 0 | | | | Allow NULL? |
| 52 | GWRMETH | Amortization method | char | 1 | 0 | | | | Allow NULL? |
| 53 | NGAYR | Life of amortization of negative goodwill in years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 54 | NGAPE | Life of amortization of negative goodwill in months | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | NGABG | Beginning date of amortization of new negative goodwill | char | 1 | 0 | | | | Allow NULL? |
| 56 | NGARFLG | Amortization of new negative goodwill over remain. life | char | 1 | 0 | | | | Allow NULL? |
| 57 | NGALFLG | Threshold for amortization of negative goodwill | char | 1 | 0 | | | | Allow NULL? |
| 58 | NGALVAL | Threshold for amortization of negative goodwill | decimal | 17 | 2 | | | | |
| 59 | NGALCUR | Group currency f. threshold of neg. goodwill amortization | nvarchar | 5 | 0 | | | | Allow NULL? |
| 60 | NGAMETH | Amortization method | char | 1 | 0 | | | | Allow NULL? |
| 61 | NGRYR | Life of periodic reduction of negative goodwill - years | nvarchar | 2 | 0 | | | | Allow NULL? |
| 62 | NGRPE | Life of periodic reduction of negative goodwill - months | nvarchar | 3 | 0 | | | | Allow NULL? |
| 63 | NGRBG | Beginning date of the reduction of new negative goodwill | char | 1 | 0 | | | | Allow NULL? |
| 64 | NGRRFLG | Reduce new negative goodwill over its remaining life | char | 1 | 0 | | | | Allow NULL? |
| 65 | NGRLFLG | Threshold for periodic reduction of negative goodwill | char | 1 | 0 | | | | Allow NULL? |
| 66 | NGRLVAL | Threshold for periodic reduction of negative goodwill | decimal | 17 | 2 | | | | |
| 67 | NGRLCUR | Group currency of threshold for periodic reduction of neg.GW | nvarchar | 5 | 0 | | | | Allow NULL? |
| 68 | NGRMETH | Amortization method | char | 1 | 0 | | | | Allow NULL? |
