| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | APPL | Commission Application (ICM) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 3 | ACCAS_TYID | Account Assignment Type Identification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | VERSION | Version of Master Data or Customizing Object | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | COSTCENTER | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | TAX_CODE | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | GROSS_AMT_MARK | Indicator: Amount is Gross Amount | char | 1 | 0 | | | | Allow NULL? |
| 8 | GL_ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | COSTELEMENT | Cost Element | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | COMPCODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | PMNT_BLOCK | Payment Block Key | char | 1 | 0 | | | | Allow NULL? |
| 12 | WAGETYPE | Wage Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 13 | COMPANYCODE | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | DOC_TYPE | Document Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | BUSI_BEGIN | Effective from | nvarchar | 14 | 0 | | | | Allow NULL? |
| 16 | BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 17 | TECH_BEGIN | Technically Valid From | nvarchar | 14 | 0 | | | | Allow NULL? |
| 18 | TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 19 | FLG_CANCEL_OBJ | Indicator: Object is Invalid | char | 1 | 0 | | | | Allow NULL? |
| 20 | FLG_CANCEL_VERS | Indicator: Version is Invalid | char | 1 | 0 | | | | Allow NULL? |
| 21 | CHG_TCODE | Transaction in Which the Change Was Made | nvarchar | 20 | 0 | | | | Allow NULL? |
| 22 | CHG_USR | Last user to change object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 23 | TRI_METH_TYP | Triggering Method | char | 1 | 0 | | | | Allow NULL? |
| 24 | TRI_METH_TARGET | Processing Target of Triggering Method | char | 1 | 0 | | | | Allow NULL? |
| 25 | STATUS_VERSION | Object Version Status | char | 1 | 0 | | | | Allow NULL? |
| 26 | STATUS_WORK | Object Version Processing Status | char | 1 | 0 | | | | Allow NULL? |