| 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/0GACCOUNT | Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | /1MD/MD______03O | USMDZ1_ACCOUNT | Allow NULL? |
| 4 | /1MD/0GCOMPCODE | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | BUKRS | Allow NULL? |
| 5 | USMD_EDTN_NUMBER | Edition Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | USMD_EDITION_NUMBER | Allow NULL? |
| 6 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 7 | USMD_OBS_TCK | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 8 | /1MD/0GACCAUTHGP | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | USMDZ1_AUTHGRP | Allow NULL? |
| 9 | /1MD/0GACCAUTPOS | Indicator: Is account only posted to automatically? | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XINTB | Allow NULL? |
| 10 | /1MD/0GACCBALLC | Indicator: Only Manage Balances in Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XSALH | Allow NULL? |
| 11 | /1MD/0GACCCASHFL | Cash receipt account / cash disbursement account | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XGKON | Allow NULL? |
| 12 | /1MD/0GACCCBLPOS | Indicator: Is Account Blocked for Posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XSPEB | Allow NULL? |
| 13 | /1MD/0GACCCDEL | Indicator: Account marked for deletion? | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XLOEV | Allow NULL? |
| 14 | /1MD/0GACCEXCHRD | Key for Exchange Rate Differences in Foreign Currency Accts. | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | USMDZ1_EXCHRTDIF | Allow NULL? |
| 15 | /1MD/0GACCFSTGRP | Field Status Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FSTATGRP | Allow NULL? |
| 16 | /1MD/0GACCICFREQ | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | USMDZ1_DZINRT | Allow NULL? |
| 17 | /1MD/0GACCICIND | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VZSKZ | Allow NULL? |
| 18 | /1MD/0GACCINFKEY | Inflation Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | USMDZ1_INFKEY | Allow NULL? |
| 19 | /1MD/0GACCLIDISP | Indicator: Can Line Items Be Displayed by Account? | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XKRES | Allow NULL? |
| 20 | /1MD/0GACCOPNITM | Indicator: Open Item Management? | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_XOPVW | Allow NULL? |
| 21 | /1MD/0GACCPLLEV | Planning Level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | USMDZ1_FDLEV | Allow NULL? |
| 22 | /1MD/0GACCRECIND | Account is reconciliation account | char | 1 | 0 | CHAR | (N' ') | Yes | | USMDZ1_MITKZ | Allow NULL? |
| 23 | /1MD/0GACCSRTKEY | Sort key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | USMDZ1_DZUAWA | Allow NULL? |
| 24 | /1MD/0GACCTAXCAT | Tax Category in Account Master Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | USMDZ1_SMWSK | Allow NULL? |
| 25 | /1MD/0GACCTOLGRP | Tolerance Group for G/L Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | USMDZ1_TOLGRP | Allow NULL? |
| 26 | /1MD/0GACCTXCOPT | Indicator: Tax code is not a required field | char | 1 | 0 | CHAR | (N' ') | Yes | | XMWNO | Allow NULL? |
| 27 | /1MD/0GACCVALGRP | Valuation Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | USMDZ1_BEWGP | Allow NULL? |
| 28 | USMD_ENT_CRTD_AT | Created On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CREATED_AT | |
| 29 | USMD_ENT_CRTD_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CREATED_BY | Allow NULL? |
| 30 | USMD_ENT_CHNG_AT | Changed On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CHANGED_AT | |
| 31 | USMD_ENT_CHNG_BY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CHANGED_BY | Allow NULL? |
| 32 | /1MD/0GACCALTACC | Alternative Account Number in Company Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | USMDZ1_ALTKT | Allow NULL? |
| 33 | /1MD/0GACCBKACC | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HKTID | Allow NULL? |
| 34 | /1MD/0GCURRACC | Account currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS_SKB1 | Allow NULL? |
| 35 | /1MD/0GACCHOUSBK | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HBKID | Allow NULL? |
