| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RVERS | Version: Selected FS items | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | ITCLG | Consolidation chart of accounts | nvarchar | 2 | 0 | | | | Allow NULL? |
| 4 | ITBG | Item for retained earnings on the balance sheet | nvarchar | 10 | 0 | | | | Allow NULL? |
| 5 | SITYP_BG | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | SITEM_BG | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | ITERG | Item for retained earnings on the income statement | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | SITYP_ERG | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | SITEM_ERG | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | ITLABD | Balance sheet item for deferred income taxes (debit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 11 | SITYP_LABD | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | SITEM_LABD | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | ITLABC | B/S item for provisions for deferred income taxes (credit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 14 | SITYP_LABC | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | SITEM_LABC | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 16 | ITLAGD | Income statement item: Deferred taxes (debit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 17 | SITYP_LAGD | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | SITEM_LAGD | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 19 | ITLAGC | Income statement item: deferred income taxes (credit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | SITYP_LAGC | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | SITEM_LAGC | Subitem | nvarchar | 10 | 0 | | | | Allow NULL? |
| 22 | CFWDIT | Unappr.retained earnings carryforward item (debit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 23 | CFWDST | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 24 | CFWDSI | Subitem - debit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | CFWCIT | Unappr.retained earnings carryforward item(credit) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | CFWCST | Subitem category | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | CFWCSI | Subitem - credit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 28 | NISTAT | Annual net income - statistical item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 29 | NICONT | Annual net income - offsetting item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | MISTAT | Minority interest in ANI - statistical item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 31 | MICONT | Minority interest in ANI - offsetting item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | NISADJ | Statistical item for adjusted annual net income | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | MISADJ | Statistical item for minority interest in adjusted ANI | nvarchar | 10 | 0 | | | | Allow NULL? |
| 34 | NISADJGW | Adjusted Annual Net Income, Statistical (Goodwill) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | MISADJGW | Minority Int. in Annual Net Income, Statistical (Goodwill) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 36 | NISADJEQ | Adjusted Annual Net Income, Statistical (Equity Method) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 37 | MISADJEQ | Minority Int. in Annual Net Income, Statistical (Equity M.) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 38 | NIAPUA | Annual Net Income from Push-down Method, Statistical Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 39 | MIAPUA | Minority Interest in ANI, Push-down Method, Statistical Item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 40 | GECONT | Overall statistical offsetting item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | TOTANI | Totals item for appropriation of retained earnings | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | NIPRFC | 'Annual net income prior to first consolidation' item | nvarchar | 10 | 0 | | | | Allow NULL? |
| 43 | NIPRCP | FS item: Annual net income prior to proportion change | nvarchar | 10 | 0 | | | | Allow NULL? |
| 44 | NIPU | Annual Net Income Item for Push-down Method | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | NIOC | Annual Net Income Item, Organizational Change | nvarchar | 10 | 0 | | | | Allow NULL? |
| 46 | NIMC | Annual Net Income Item for Method Change | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | NIMERG | Net Income Item for Merger | nvarchar | 10 | 0 | | | | Allow NULL? |
| 48 | NIDEMG | Net Income Item for Demerger | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | NIDIVP | Net Income Item for Partial Divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 50 | APPRMDI | Item: Transfers to Minority Interest | nvarchar | 10 | 0 | | | | Allow NULL? |
| 51 | APPRMDT | Subitem Category: Transfers to Minority Interest | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | APPRMDS | Subitem: Transfers to Minority Interest, Debit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 53 | APPRMCT | Subitem Category: Transfers to Minority Interest | nvarchar | 3 | 0 | | | | Allow NULL? |
| 54 | APPRMCS | Subitems Transfers to Minority Interest Credit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 55 | TRANMD | Item for transfers to minority interest in ret.earnings | nvarchar | 10 | 0 | | | | Allow NULL? |
| 56 | TRANMC | Item: Deductions from min.int. in ret. earnings | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | ELICOI | Item: clearing of consolidation of investments | nvarchar | 10 | 0 | | | | Allow NULL? |
| 58 | ELICOT | Subitem category: Clearing of consolidation of investments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | ELICDS | Subitem: Clearing of consolidation of investments - debit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 60 | ELICCS | Subitem: Clearing of consolidation of investments - credit | nvarchar | 10 | 0 | | | | Allow NULL? |
| 61 | HRMINIT | Item for minority interest in hidden reserves | nvarchar | 10 | 0 | | | | Allow NULL? |
| 62 | DIVSTDI | FS item: Losses from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 63 | DIVSTDT | Subitem category: Losses from divestitures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 64 | DIVSTDS | Subitem: Losses from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | DIVSTCI | FS item: Gains from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 66 | DIVSTCT | Subitem category: Gains from divestitures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 67 | DIVSTCS | Subitem: Gains from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 68 | DIVEQDI | FS item for divestiture expense from equity method | nvarchar | 10 | 0 | | | | Allow NULL? |
| 69 | DIVEQDT | Subitem category for divestiture expense from equity method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 70 | DIVEQDS | Subitem for divestiture expense from equity method | nvarchar | 10 | 0 | | | | Allow NULL? |
| 71 | DIVEQCI | FS item for divestiture revenue from equity method | nvarchar | 10 | 0 | | | | Allow NULL? |
| 72 | DIVEQCT | Subitem category for divestiture revenue from equity method | nvarchar | 3 | 0 | | | | Allow NULL? |
| 73 | DIVEQCS | Subitem for divestiture revenue from equity method | nvarchar | 10 | 0 | | | | Allow NULL? |
| 74 | DIVMIDI | Item: Expense for divestitures, minority share | nvarchar | 10 | 0 | | | | Allow NULL? |
| 75 | DIVMIDT | Subitem category: Minority share of losses from divestitures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 76 | DIVMIDS | Subitem: Minority share of losses from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 77 | DIVMICI | Item: Revenue from divestitures, minority share | nvarchar | 10 | 0 | | | | Allow NULL? |
| 78 | DIVMICT | Subitem category: Minority share of gains from divestitures | nvarchar | 3 | 0 | | | | Allow NULL? |
| 79 | DIVMICS | Subitem: Minority share of gains from divestitures | nvarchar | 10 | 0 | | | | Allow NULL? |
| 80 | DIVITEM | Clearing item for transaction currency difference split | nvarchar | 10 | 0 | | | | Allow NULL? |
| 81 | GPCNT1 | FS item for group share | nvarchar | 10 | 0 | | | | Allow NULL? |
| 82 | GPCNT2 | FS item for group share in voting stock | nvarchar | 10 | 0 | | | | Allow NULL? |
| 83 | GPCNT3 | Item for group share in non-voting stock | nvarchar | 10 | 0 | | | | Allow NULL? |
| 84 | GPCNT4 | Item for group share in annual net income | nvarchar | 10 | 0 | | | | Allow NULL? |
| 85 | GPCNT5 | Item for group share - direct investment | nvarchar | 10 | 0 | | | | Allow NULL? |
| 86 | INVEXT | Third-party Investment | nvarchar | 10 | 0 | | | | Allow NULL? |
| 87 | FGWBEG | Full Goodwill at Beginning of Period | nvarchar | 10 | 0 | | | | Allow NULL? |
| 88 | FGWEND | Full Goodwill at End of Period | nvarchar | 10 | 0 | | | | Allow NULL? |
| 89 | GWRESI | Item: Appropriations for Goodwill | nvarchar | 10 | 0 | | | | Allow NULL? |
| 90 | GWREST | Subitem Category: Appropriations for Goodwill | nvarchar | 3 | 0 | | | | Allow NULL? |
| 91 | GWRESS | Subitem: Appropriations for Goodwill | nvarchar | 10 | 0 | | | | Allow NULL? |
| 92 | GWTADI | Item: Currency Translation for Goodwill | nvarchar | 10 | 0 | | | | Allow NULL? |
| 93 | GWTADT | Subitem Category: Currency Translation for Goodwill | nvarchar | 3 | 0 | | | | Allow NULL? |
| 94 | GWTADS | Subitem: Currency Translation for Goodwill | nvarchar | 10 | 0 | | | | Allow NULL? |
| 95 | NIGWAQI | Item for goodwill accum.amortization item/neg. inv. BV | nvarchar | 10 | 0 | | | | Allow NULL? |
| 96 | NIGWAQT | Subitem cat. goodwill accum.amortization/neg. investment BV | nvarchar | 3 | 0 | | | | Allow NULL? |
| 97 | NIGWAQS | Subitem goodwill accum.amortization/negative investment BV | nvarchar | 10 | 0 | | | | Allow NULL? |
| 98 | NIGWAMI | Goodwill amortization item / negative investment book value | nvarchar | 10 | 0 | | | | Allow NULL? |
| 99 | NIGWAMT | SI cat. for goodwill amortization/neg. investment book value | nvarchar | 3 | 0 | | | | Allow NULL? |
| 100 | NIGWAMS | Subitem for Goodwill amortization/neg. investement bookvalue | nvarchar | 10 | 0 | | | | Allow NULL? |
| 101 | ITBAG | Balancing adjustment item for bus. area/profit center cons | nvarchar | 10 | 0 | | | | Allow NULL? |
| 102 | PIWDI | Item for Investment Amortization | nvarchar | 10 | 0 | | | | Allow NULL? |
| 103 | PIWDT | Subitem Category for Investment Amortization | nvarchar | 3 | 0 | | | | Allow NULL? |
| 104 | PIWDS | Subitem for Investment Amortization | nvarchar | 10 | 0 | | | | Allow NULL? |
| 105 | PIWUI | Item for Investment Writeup | nvarchar | 10 | 0 | | | | Allow NULL? |
| 106 | PIWUT | Subitem Category for Investment Writeup | nvarchar | 3 | 0 | | | | Allow NULL? |
| 107 | PIWUS | Subitem for Investment Writeup | nvarchar | 10 | 0 | | | | Allow NULL? |
| 108 | LDTEQI | Equity Item for Legacy Data Transfer | nvarchar | 10 | 0 | | | | Allow NULL? |
| 109 | LDTEQT | Subitem Category for Legacy Data Transfer | nvarchar | 3 | 0 | | | | Allow NULL? |
| 110 | LDTEQS | Subitem for Legacy Data Transfer | nvarchar | 10 | 0 | | | | Allow NULL? |
