| 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 | * | MANDT | Allow NULL? |
| 2 | DOCTYPE | Document Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | /OPT/DOCTYPE | Allow NULL? |
| 3 | DOCID | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | No | | AWKEY | Allow NULL? |
| 4 | LINEID | Counter | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | /OPT/COUNTER | Allow NULL? |
| 5 | APPR_LEVEL | Approval Level | nvarchar | 3 | 0 | NUMC | (N'000') | No | | /OPT/A_APPR_LEVEL_DE | Allow NULL? |
| 6 | PACK_NUM | Line Item Approval for Packing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /OPT/LIAP_PACK | Allow NULL? |
| 7 | OPT_USERID | Open Text User Mapping Object ID | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | * | /ORS/UMOID | Allow NULL? |
| 8 | STATUS | Line Item Approval status for Matrix | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/LIAP_STATUS | Allow NULL? |
| 9 | APPR_LIMIT | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 10 | APPR_VALUE | Amount in document currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | WRBTR | |
| 11 | GL_AFS_ACTIVE | Activation Type for AFS - Automatic | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/A_DETYPE_CUST_AFS | Allow NULL? |
| 12 | GL_AFS_FM | Activate AFS for whole process flow - Finder | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | /OPT/A_DEAUT_AFS_FM | Allow NULL? |
| 13 | GL_AFS_TYPE | AFS Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/AFS_TYPE | Allow NULL? |
| 14 | GL_APPR_CLASS | Approver Class | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /OPT/APPR_CLASS | Allow NULL? |
| 15 | GL_USERMAP_CLASS | Usermap Class | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /OPT/USRMAP_CLASS | Allow NULL? |
| 16 | GL_CODER_DET | Coder Determination | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/CODER_DET | Allow NULL? |
| 17 | GL_CODER_FM | Coder Determination Fuction Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | /OPT/CODER_FM | Allow NULL? |
| 18 | GL_FWD_OPTION | AFS Automatic Forward Option | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/APPR_FWD_OPTION | Allow NULL? |
| 19 | GL_FWD_FM | AFS Forward Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | /OPT/AFS_FWD_FM | Allow NULL? |
| 20 | GL_REJ_PROC_TYPE | Reject Process Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/REG_PROC_TYPE | Allow NULL? |
| 21 | GL_REJECT_FM | Rejection Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | /OPT/REJ_FM | Allow NULL? |
| 22 | GL_AFS_BASE_AMT | Amount Base (Net/Gross) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/AMOUNT_BASE | Allow NULL? |
| 23 | GL_AFS_CURR_TYPE | COA Curreny (Company Code Default / Fixed EUR) | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/CURRENCY_TYPE | Allow NULL? |
| 24 | GL_MULTI_AGENT | Multi Agent assignement Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /OPT/MULTI_FLAG | Allow NULL? |
| 25 | GL_AFS_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 26 | EXPENSE_TYPE | Invoice Approval Expense Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | /ORS/EXPENSE | Allow NULL? |
| 27 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 28 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 29 | WBS_ELEMENT | Work Breakdown Structure Element (WBS Element) | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | PS_POSID | Allow NULL? |
| 30 | INTERNAL_ORDER | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | AUFNR | Allow NULL? |
| 31 | GL_ACCT | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 32 | ACTIVITY_TYPE | Activity Type | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | LSTAR | Allow NULL? |
| 33 | NETWORK_NO | Network Number for Account Assignment | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | NPLNR | Allow NULL? |
| 34 | PROFIT_CENTER | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 35 | REAL_ESTATE_CON | Real Estate Contract Number | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | RECNNR | Allow NULL? |
| 36 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 37 | ASSIGNMENT | Assignment Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | DZUONR | Allow NULL? |
| 38 | EARMARKED_FUND | Document Number for Earmarked Funds | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KBLNR | Allow NULL? |
| 39 | COST_OBJECT | Cost Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | KSTRG | Allow NULL? |
| 40 | FUND_CENTER | Funds Center | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | FISTL | Allow NULL? |
| 41 | BUSINESS_AREA | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
