| 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 | DIMEN | Dimension | nvarchar | 2 | 0 | CHAR | (N' ') | No | TF150 | FC_DIMEN | Allow NULL? |
| 3 | PURFLG | Purchase method of consolidation | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PURFLG | Allow NULL? |
| 4 | POOFLG | Pooling of interests | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_POOFLG | Allow NULL? |
| 5 | PROFLG | Proportional consolidation | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PROFLG | Allow NULL? |
| 6 | EQIFLG | Equity method | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_EQIFLG | Allow NULL? |
| 7 | MUTFLG | Mutual stock method | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_MUTFLG | Allow NULL? |
| 8 | CSTFLG | Cost method | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CSTFLG | Allow NULL? |
| 9 | MINFLG | Minority interest | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_MINFLG | Allow NULL? |
| 10 | CSHFLG | Statement of Stockholders' Equity | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CSHFLG | Allow NULL? |
| 11 | ANIFLG | Appropriation of retained earnings | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ANIFLG | Allow NULL? |
| 12 | HIRFLG | Fair value adjustments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HIRFLG | Allow NULL? |
| 13 | GWCTFLG | Goodwill in Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWCTFLG | Allow NULL? |
| 14 | IWDUFLG | Investment Amortization/Write-up | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_IWDUFLG | Allow NULL? |
| 15 | LDTFLG | Legacy Data Transfer | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_LDTFLG | Allow NULL? |
| 16 | DGWFLG | Separation of Goodwill from Investment | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DGWFLG | Allow NULL? |
| 17 | PDEFLG | Partial Divestiture as Equity Transaction | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PDEFLG | Allow NULL? |
| 18 | TDIFLG | Other Comprehensive Income in Total Divestiture | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_TDIFLG | Allow NULL? |
| 19 | MERFLG | Merger Activities | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_MERFLG | Allow NULL? |
| 20 | SCONMI | Minority Interest in Retained Earnings | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SCONMI | Allow NULL? |
| 21 | SAQOCI | Other Comprehensive Income in Step Acquisition | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SAQOCI | Allow NULL? |
| 22 | CCHFLG | Change of Control | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CCHFLG | Allow NULL? |
| 23 | GWNFLG | Goodwill Extraordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWNFLG | Allow NULL? |
| 24 | GWAFLG | Goodwill Ordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWAFLG | Allow NULL? |
| 25 | GWWFLG | Direct Writeoff of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWWFLG | Allow NULL? |
| 26 | GWDFLG | Direct elimination of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWDFLG | Allow NULL? |
| 27 | GWRFLG | Periodic reduction of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRFLG | Allow NULL? |
| 28 | NGNFLG | Extraordinary Amortization of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGNFLG | Allow NULL? |
| 29 | NGAFLG | Negative Goodwill Ordinary Amortization | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGAFLG | Allow NULL? |
| 30 | NGWFLG | Direct Writeoff of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGWFLG | Allow NULL? |
| 31 | NGDFLG | Direct Elimination of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGDFLG | Allow NULL? |
| 32 | NGRFLG | Periodic Reduction of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRFLG | Allow NULL? |
| 33 | NEQFLG | Negative stockholders' equity | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NEQFLG | Allow NULL? |
| 34 | HIRCUS | Customizing: Fair value adjustments | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_HIRCUS | Allow NULL? |
| 35 | GWNCUS | Customizing: Extraordinary Amortization of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWNCUS | Allow NULL? |
| 36 | GWACUS | Customizing: Ordinary Amortization of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWACUS | Allow NULL? |
| 37 | GWWCUS | Customizing: Direct Writeoff of Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWWCUS | Allow NULL? |
| 38 | GWDCUS | Customizing: Direct elimination of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWDCUS | Allow NULL? |
| 39 | GWRCUS | Customizing: Periodic reduction of goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_GWRCUS | Allow NULL? |
| 40 | NGNCUS | Customizing: Extraordinary Amortization of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGNCUS | Allow NULL? |
| 41 | NGACUS | Customizing: Ordinary Amortization of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGACUS | Allow NULL? |
| 42 | NGWCUS | Customizing: Direct Writeoff of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGWCUS | Allow NULL? |
| 43 | NGDCUS | Customizing: Direct Elimination of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGDCUS | Allow NULL? |
| 44 | NGRCUS | Customizing: Periodic Reduction of Negative Goodwill | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NGRCUS | Allow NULL? |
| 45 | NEQCUS | Customizing: Negative shareholders' equity | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_NEQCUS | Allow NULL? |
| 46 | PUAFLG | Push-down Method | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PUAFLG | Allow NULL? |
| 47 | OCFLG | Organizational Changes, No Effect on Earnings | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_OCFLG | Allow NULL? |
