| 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 | PZLFH | Item counter for production resources/tools | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | LOEKZ | Deletion Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | PARKZ | Indicator: inactive changes | char | 1 | 0 | | | | Allow NULL? |
| 7 | DATUI | Date record created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | USERI | User who created record | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | DATUC | Changed On | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | USERC | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 11 | OBJTY | Object types of the CIM resource | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | OBJID | Object ID of the resource | nvarchar | 8 | 0 | | | | Allow NULL? |
| 13 | PLNTY_KEY | Task List Type | char | 1 | 0 | | | | Allow NULL? |
| 14 | PLNNR_KEY | Key for Task List Group | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | PZLFH_KEY | Item counter for production resources/tools | nvarchar | 8 | 0 | | | | Allow NULL? |
| 16 | ZAEHL_KEY | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 17 | OBJCT | Object of a task list | char | 1 | 0 | | | | Allow NULL? |
| 18 | APLZL | Internal counter | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | PSNFH | Item Number for Production Resource/Tool | nvarchar | 4 | 0 | | | | Allow NULL? |
| 20 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 21 | STEUF | Control key for management of production resources/tools | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | KZKBL | Indicator: Create load records for prod. resources/tools | char | 1 | 0 | | | | Allow NULL? |
| 23 | BZOFFB | Reference date to start of production resource/tool usage | nvarchar | 2 | 0 | | | | Allow NULL? |
| 24 | OFFSTB | Offset to start of production resource/tool usage | decimal | 5 | 0 | | | | |
| 25 | EHOFFB | Offset unit for start of prod. resource/tool usage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 26 | BZOFFE | Reference date for end of production resource/tool usage | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | OFFSTE | Offset to finish of production resource/tool usage | decimal | 5 | 0 | | | | |
| 28 | EHOFFE | Offset unit for end of production resource/tool usage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 29 | FSFHD | Earliest scheduled start (date) for PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | FSFHZ | Earliest scheduled start (time) for PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 31 | FEFHD | Earliest scheduled finish (date) of PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | FEFHZ | Earliest scheduled end (time) of PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 33 | SSFHD | Latest scheduled start (date) for PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | SSFHZ | Latest scheduled start (time) for PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 35 | SEFHD | Latest scheduled finish (date) of PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | SEFHZ | Latest scheduled end (time) for PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 37 | ISFHD | Actual start (date) of PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 38 | ISFHZ | Actual start (time) of PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 39 | IEFHD | Actual finish (date) of PRT usage | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | IEFHZ | Actual finish (time) of PRT usage | nvarchar | 6 | 0 | | | | Allow NULL? |
| 41 | DAUFL | Duration of PRT usage | float | 15 | 16 | | | | |
| 42 | DAUEH | Time unit for duration of PRT usage | nvarchar | 3 | 0 | | | | Allow NULL? |
| 43 | MGEINH | Quantity unit of production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 44 | MGVGW | Standard value for the PRT quantity | decimal | 9 | 3 | | | | |
| 45 | MGSOLEH | Quantity unit of production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | MGSOL | Total planned quantity of production resource/tool | decimal | 9 | 3 | | | | |
| 47 | MGISTEH | Quantity unit of production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 48 | MGIST | Confirmed quantity of production resource/tool | decimal | 9 | 3 | | | | |
| 49 | MGRSTEH | Quantity unit of production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | MGRST | Remaining quantity of the production resource/tool | decimal | 9 | 3 | | | | |
| 51 | MGAUSEH | Quantity unit of production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 52 | MGAUS | Quantity of checked-out production resources/tools | decimal | 9 | 3 | | | | |
| 53 | MGFORM | Formula for calculating the total quantity of PRT | nvarchar | 6 | 0 | | | | Allow NULL? |
| 54 | EWEINH | Usage value unit of the production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 55 | EWVGW | Standard usage value for production resources/tools | decimal | 9 | 3 | | | | |
| 56 | EWSOLEH | Usage value unit of the production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 57 | EWSOL | Total planned usage value of production resource/tool | decimal | 9 | 3 | | | | |
| 58 | EWISTEH | Usage value unit of the production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 59 | EWIST | Actual usage value for production resource/tool | decimal | 9 | 3 | | | | |
| 60 | EWRSTEH | Usage value unit of the production resource/tool | nvarchar | 3 | 0 | | | | Allow NULL? |
| 61 | EWRST | Remaining usage value of the production resource/tool | decimal | 9 | 3 | | | | |
| 62 | EWFORM | Formula for calculating the total usage value of PRT | nvarchar | 6 | 0 | | | | Allow NULL? |
| 63 | TXTSP | Language Key | char | 1 | 0 | | | | Allow NULL? |
| 64 | KTSCH | Standard text key for production resources/tools | nvarchar | 7 | 0 | | | | Allow NULL? |
| 65 | TXTZ1 | First line of text for production resources/tools | nvarchar | 40 | 0 | | | | Allow NULL? |
| 66 | OBJTYPE | Change indicator | char | 1 | 0 | | | | Allow NULL? |
| 67 | CH_PROC | Process that has lead to the change of an object | char | 1 | 0 | | | | Allow NULL? |
| 68 | AENNR | Change Number | nvarchar | 12 | 0 | | | | Allow NULL? |
| 69 | ORGAUFPL | Routing number of operations in the order | nvarchar | 10 | 0 | | | | Allow NULL? |
| 70 | ORGPZLFH | Item counter for production resources/tools | nvarchar | 8 | 0 | | | | Allow NULL? |
