| 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/0FCOA | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | /1MD/MD______01L | USMDA1_COA | Allow NULL? |
| 3 | /1MD/0FACCOUNT | Account | nvarchar | 10 | 0 | CHAR | (N' ') | No | /1MD/MD______01S | USMDA1_ACCOUNT | Allow NULL? |
| 4 | /1MD/0FCOMPCODE | 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/0FACCAUTHGP | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | USMDA1_AUTHGRP | Allow NULL? |
| 9 | /1MD/0FACCAUTPOS | Indicator: Is account only posted to automatically? | char | 1 | 0 | CHAR | (N' ') | Yes | | XINTB | Allow NULL? |
| 10 | /1MD/0FACCBALLC | Indicator: Only Manage Balances in Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | XSALH | Allow NULL? |
| 11 | /1MD/0FACCCASHFL | Cash receipt account / cash disbursement account | char | 1 | 0 | CHAR | (N' ') | Yes | | XGKON | Allow NULL? |
| 12 | /1MD/0FACCCBLPOS | Indicator: Is Account Blocked for Posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEB | Allow NULL? |
| 13 | /1MD/0FACCCDEL | Indicator: Account marked for deletion? | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV | Allow NULL? |
| 14 | /1MD/0FACCCICFRE | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZINRT | Allow NULL? |
| 15 | /1MD/0FACCCTCOPT | Indicator: Tax code is not a required field | char | 1 | 0 | CHAR | (N' ') | Yes | | XMWNO | Allow NULL? |
| 16 | /1MD/0FACCCURR | Account currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS_SKB1 | Allow NULL? |
| 17 | /1MD/0FACCLIDISP | Indicator: Can Line Items Be Displayed by Account? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKRES | Allow NULL? |
| 18 | /1MD/0FACCOPNITM | Indicator: Open Item Management? | char | 1 | 0 | CHAR | (N' ') | Yes | | XOPVW | Allow NULL? |
| 19 | /1MD/0FACCRECIND | Account is reconciliation account | char | 1 | 0 | CHAR | (N' ') | Yes | | MITKZ | Allow NULL? |
| 20 | /1MD/0FACCVALGRP | Valuation Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BEWGP | Allow NULL? |
| 21 | USMD_ENT_CRTD_AT | Created On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CREATED_AT | |
| 22 | USMD_ENT_CRTD_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CREATED_BY | Allow NULL? |
| 23 | USMD_ENT_CHNG_AT | Changed On | decimal | 15 | 0 | DEC | ((0)) | Yes | | USMD_ENTITY_CHANGED_AT | |
| 24 | USMD_ENT_CHNG_BY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | USMD_ENTITY_CHANGED_BY | Allow NULL? |
| 25 | /1MD/0FACCALTACC | Alternative account number in company code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ALTKT_SKB1 | Allow NULL? |
| 26 | /1MD/0FEXCHRACCC | Key for Exchange Rate Differences in Foreign Currency Accts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KDFSL | Allow NULL? |
| 27 | /1MD/0FFICOAACCC | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | KTOPL | Allow NULL? |
| 28 | /1MD/0FFSTGACCC | Field status group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FSTAG | Allow NULL? |
| 29 | /1MD/0FFSTVACCC | Field Status Variant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FSTVA | Allow NULL? |
| 30 | /1MD/0FICALCACCC | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VZSKZ | Allow NULL? |
| 31 | /1MD/0FPLGRPACCC | Planning group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | FDGRV | Allow NULL? |
| 32 | /1MD/0FPLLEVACCC | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | FDLEV | Allow NULL? |
| 33 | /1MD/0FTAXCTACCC | Tax Category in Account Master Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | USMDA1_TAXCAT | Allow NULL? |
| 34 | /1MD/0FVALAACCC | Valuation Area for FI Year-End Closing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BWBER | Allow NULL? |
