| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | VSNMR | Number or description of a version | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | AUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | APLZL | General counter for order | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | SLWID | Key word ID for user-defined fields | nvarchar | 7 | 0 | | | | Allow NULL? |
| 6 | USR00 | User field with 20 characters | nvarchar | 20 | 0 | | | | Allow NULL? |
| 7 | USR01 | User field with 20 characters | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | USR02 | User field with 10 characters | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | USR03 | User field with 10 characters | nvarchar | 10 | 0 | | | | Allow NULL? |
| 10 | USR04 | User field for quantity (length 10.3) | decimal | 13 | 3 | | | | |
| 11 | USE04 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | USR05 | User field for quantity (length 10.3) | decimal | 13 | 3 | | | | |
| 13 | USE05 | User field: Unit for quantity fields | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | USR06 | User-defined field for values (length 10,3) | decimal | 13 | 3 | | | | |
| 15 | USE06 | User field: Unit for value fields | nvarchar | 5 | 0 | | | | Allow NULL? |
| 16 | USR07 | User-defined field for values (length 10,3) | decimal | 13 | 3 | | | | |
| 17 | USE07 | User field: Unit for value fields | nvarchar | 5 | 0 | | | | Allow NULL? |
| 18 | USR08 | User field for date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | USR09 | User field for date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | USR10 | User-defined field: Indicator for reports | char | 1 | 0 | | | | Allow NULL? |
| 21 | USR11 | User-defined field: Indicator for reports | char | 1 | 0 | | | | Allow NULL? |
| 22 | VNAME | Joint Venture | nvarchar | 6 | 0 | | | | Allow NULL? |
| 23 | RECID | Recovery Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | ETYPE | Equity type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | JV_OTYPE | Joint Venture Object Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | JV_JIBCL | JIB/JIBE Class | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | JV_JIBSA | JIB/JIBE Subclass A | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | JV_OCO | JV original cost object | char | 1 | 0 | | | | Allow NULL? |
| 29 | DUMMY_CI_AFVU | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 30 | SPARAMETER1 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | | | | Allow NULL? |
| 31 | SPARAMETER2 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | | | | Allow NULL? |
| 32 | SPARAMETER3 | Scheduling Parameters for External Scheduling | nvarchar | 4 | 0 | | | | Allow NULL? |
| 33 | /MRSS/ID_PROFILE | Requirements Profile Was Changed Manually | char | 1 | 0 | | | | Allow NULL? |
| 34 | /MRSS/PROF_KEY | Profile Key | nvarchar | 10 | 0 | | | | Allow NULL? |
| 35 | /MRSS/PROF_GUID | Character field, length 32 | nvarchar | 32 | 0 | | | | Allow NULL? |
| 36 | /MRSS/ACT_TYPE | Process variant | char | 1 | 0 | | | | Allow NULL? |
| 37 | /MRSS/ORDER_PROB | Order probability in percent | nvarchar | 3 | 0 | | | | Allow NULL? |
| 38 | /MRSS/INIT_DONE | Internal initialization carried out once | char | 1 | 0 | | | | Allow NULL? |
| 39 | /MRSS/DATACHANGE | Data was changed in the controls on the user screen | char | 1 | 0 | | | | Allow NULL? |
| 40 | /MRSS/DEM_COUNT | Counter for Demands in Operation | nvarchar | 4 | 0 | | | | Allow NULL? |
| 41 | /MRSS/SUPERV_CNT | Number of Site Supervisors | nvarchar | 2 | 0 | | | | Allow NULL? |
| 42 | /MRSS/RULE_ID | Time Rule Id | nvarchar | 25 | 0 | | | | Allow NULL? |
| 43 | /MRSS/SALES_ORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 44 | /MRSS/REFF_RCNT | Determination of Remaining Demand: No. of Resources | nvarchar | 3 | 0 | | | | Allow NULL? |
| 45 | /MRSS/REFF_E_BEG | Time stamp: start | nvarchar | 14 | 0 | | | | Allow NULL? |
| 46 | /MRSS/REFF_E_END | Time stamp: end | nvarchar | 14 | 0 | | | | Allow NULL? |
| 47 | /MRSS/REFF_L_BEG | Time stamp: start | nvarchar | 14 | 0 | | | | Allow NULL? |
| 48 | /MRSS/REFF_L_END | Time stamp: end | nvarchar | 14 | 0 | | | | Allow NULL? |
| 49 | /MRSS/RELEVANT | Operation Set as MRS-Relevant | char | 1 | 0 | | | | Allow NULL? |
| 50 | /MRSS/TEAM_PLAN | Team Planning flag for Demand | char | 1 | 0 | | | | Allow NULL? |
| 51 | /MRSS/SINGL_RES | Combine Operations and Assign Same Resource | char | 1 | 0 | | | | Allow NULL? |
| 52 | /MRSS/TO_BEGDAT | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | /MRSS/TO_BEGTIM | Field of type TIMS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 54 | /MRSS/TO_ENDDAT | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | /MRSS/TO_ENDTIM | Field of type TIMS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 56 | /MRSS/TO_DURAT | Character Field Length = 10 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 57 | /MRSS/TO_DUNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 58 | /MRSS/TO_DISTAN | 19 Characters | nvarchar | 19 | 0 | | | | Allow NULL? |
| 59 | /MRSS/TO_MANUAL | Boolean Variable | char | 1 | 0 | | | | Allow NULL? |
| 60 | /MRSS/FR_BEGDAT | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | /MRSS/FR_BEGTIM | Field of type TIMS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 62 | /MRSS/FR_ENDDAT | Field of type DATS | nvarchar | 8 | 0 | | | | Allow NULL? |
| 63 | /MRSS/FR_ENDTIM | Field of type TIMS | nvarchar | 6 | 0 | | | | Allow NULL? |
| 64 | /MRSS/FR_DURAT | Character Field Length = 10 | nvarchar | 10 | 0 | | | | Allow NULL? |
| 65 | /MRSS/FR_DUNIT | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 66 | /MRSS/FR_DISTAN | 19 Characters | nvarchar | 19 | 0 | | | | Allow NULL? |
| 67 | /MRSS/FR_MANUAL | Boolean Variable | char | 1 | 0 | | | | Allow NULL? |
| 68 | ILART_OP | Maintenance activity type | nvarchar | 3 | 0 | | | | Allow NULL? |
| 69 | FERC_IND | Regulatory indicator | nvarchar | 4 | 0 | | | | Allow NULL? |
