| 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 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001W | WERKS_D | Allow NULL? |
| 3 | AUART | Order Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T003O | AUFART | Allow NULL? |
| 4 | USERN | User name | nvarchar | 12 | 0 | CHAR | (N' ') | No | * | USERN | Allow NULL? |
| 5 | PROFWOC | Profile rels.& graphic / General order | nvarchar | 7 | 0 | CHAR | (N' ') | No | TCN41 | PROFILWOC | Allow NULL? |
| 6 | PROFEXT | External procurement profile | nvarchar | 7 | 0 | CHAR | (N' ') | No | TPEXT | PROFILEXT | Allow NULL? |
| 7 | PROFMAT | External material profile | nvarchar | 7 | 0 | CHAR | (N' ') | No | TPEXT | PROFILMAT | Allow NULL? |
| 8 | MGVRG | Operation Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | MGVRG | |
| 9 | MEINH | Unit of Measure for Activity/Operation | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VORME | Allow NULL? |
| 10 | SCREENTY | Scenario or Subscreen Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TQBT | SCRTP | Allow NULL? |
| 11 | SEL_OPR | Include task list with operation selection | char | 1 | 0 | CHAR | (N' ') | Yes | | SEL_OPR | Allow NULL? |
| 12 | WCENTER | Include task list with work center selection | char | 1 | 0 | CHAR | (N' ') | Yes | | WCENTER | Allow NULL? |
| 13 | NEW_NUM | Include task list with renumbering | char | 1 | 0 | CHAR | (N' ') | Yes | | NEW_NUM | Allow NULL? |
| 14 | ONE_OPR | Include task list only once completely | char | 1 | 0 | CHAR | (N' ') | Yes | | ONE_OPR | Allow NULL? |
| 15 | SEQUENC | Sorted inclusion of operations in the order | char | 1 | 0 | CHAR | (N' ') | Yes | | SEQUENC | Allow NULL? |
