| 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 | /1MD/0GCOA | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | KTOPL | Allow NULL? |
| 3 | /1MD/0GFRS | Financial Reporting Structure | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | USMDZ1_FRS | Allow NULL? |
| 4 | USMD_EDTN_NUMBER | Edition Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | USMD_EDITION_NUMBER | Allow NULL? |
| 5 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 6 | USMD_OBS_TCK | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 7 | /1MD/0GFRSFAPERM | Assignment of Functional Areas is Permitted (Indicator) | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FUNCAREAIND | Allow NULL? |
| 8 | /1MD/0GFRSUSEFSI | Fin.Statement Structure Uses Group Chart of Accounts (Ind.) | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_CCOAIND | Allow NULL? |
| 9 | USMD_ENT_CRTD_AT | Created On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CREATED_AT | |
| 10 | USMD_ENT_CRTD_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CREATED_BY | Allow NULL? |
| 11 | USMD_ENT_CHNG_AT | Changed On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CHANGED_AT | |
| 12 | USMD_ENT_CHNG_BY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CHANGED_BY | Allow NULL? |
| 13 | /1MD/0GFRSIASSET | Item key representing the assets | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_AKTVA_011 | Allow NULL? |
| 14 | /1MD/0GFRSILIAB | Item Key Representing the Liabilities | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_PSSVA_011 | Allow NULL? |
| 15 | /1MD/0GFRSILOSS | Item key representing the line item net loss | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_ERGAK_011 | Allow NULL? |
| 16 | /1MD/0GFRSINOASS | Item key representing the non-assignable accounts | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_DZUORD_011 | Allow NULL? |
| 17 | /1MD/0GFRSINOTES | Item key that represents notes to financial statements | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_ANHNG_011 | Allow NULL? |
| 18 | /1MD/0GFRSIPLI | Fin.statement key representing the P+L profit item | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_ERGGV_011 | Allow NULL? |
| 19 | /1MD/0GFRSIPROF | Fin.statement key representing the net profit/yr | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_ERGPA_011 | Allow NULL? |
