| 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 | ORDID | Internal Number (UID) for an Order in APO | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/OM_ORDERUID | Allow NULL? |
| 3 | SIMID | Name of Planning Version | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/OM_VRSIOID | Allow NULL? |
| 4 | ORDTYPE | Type of Order Object in liveCache | varbinary | 1 | 0 | RAW | | Yes | | /SAPAPO/OM_ORDER_TYPE | |
| 5 | ORDNO | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_ORDNO | Allow NULL? |
| 6 | APPLI | Application in APO | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_APO_APPLI | |
| 7 | UPDIN | Method (controls deleting, changing and creating of objects) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_METHOD | Allow NULL? |
| 8 | TRPID | Internal Number of Source of Supply | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_TR_TRPID | Allow NULL? |
| 9 | TRPID_TYPE | Source of Supply Category | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /SAPAPO/OM_TR_TRPRODTYPE | Allow NULL? |
| 10 | PRODUCABLE | Convertible Order | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_UMSKZ | Allow NULL? |
| 11 | OUTPUT_FIXED | Order Status Output Firmed (Receipt Quantities Firmed) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_OUTPUT_FIRMED | Allow NULL? |
| 12 | INPUT_FIXED | Order Status Input Firmed (Bill of Materials Firmed) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_INPUT_FIRMED | Allow NULL? |
| 13 | PART_DELIVERED | Partially Delivered | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_PART_DELIVERED | Allow NULL? |
| 14 | FINAL_DELIVERY | Final Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_FINAL_DELIVERY | Allow NULL? |
| 15 | UNPLANNED | Status 'Deallocated' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_UNPLANNED | Allow NULL? |
| 16 | RELEASED | Status 'Released' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_RELEASED | Allow NULL? |
| 17 | DATE_FIXED | Object has the status 'Fixed' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_FIXED | Allow NULL? |
| 18 | STARTED | Status 'Started' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_STARTED | Allow NULL? |
| 19 | IS_ISSUED | Order components already issued? | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_IS_ISSUED | |
| 20 | PART_CONFIRMED | Status 'Partial Confirmation' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_PART_CONFIRMED | Allow NULL? |
| 21 | FINAL_CONFIRMED | Status 'Final Confirmation' | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_FINAL_CONFIRMED | Allow NULL? |
| 22 | TTYPE | Means of Transport | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_SNPTTYPE | Allow NULL? |
| 23 | TPRIO | Transfer Priority | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/OM_SNPTPRIO | Allow NULL? |
| 24 | TROID | Transport Order ID | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/TROID_OM | Allow NULL? |
| 25 | STRAT | Rqmts Strategy | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_STRA1 | Allow NULL? |
| 26 | LOCID | Internal Location Number (Customer, Vendor, or Plant) | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_LOCID | Allow NULL? |
| 27 | OLTPTRANSFER | Mode for Transferring Orders to OLTP System | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_OLTPTRANSFER | |
| 28 | CNVIN | Conversion Indicator for Orders | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/OM_CNVIN | Allow NULL? |
| 29 | QTY_EFFECT_INVLD | Quantity Validity of Source of Supply Used | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_QTY_EFF_INVALID | |
| 30 | IPPE_PPM_CHANGED | PPM/IPPE Status Indicator Obsolete | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_IPPE_PPM_CHANGED | |
| 31 | CTM_STATUS | Status of an Order Regarding CTM | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_CTM_STATUS | |
| 32 | ATP_ORDER_STATUS | ATP: Status of an Order | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_ATPORDSTAT | |
| 33 | TCCTMS | ATP: Total Confirmation Date (Time Stamp) | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPAPO/OM_TCCTMS | |
| 34 | MES_STATUS | Status Indicator for Flexible Manufacturing | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_MES_STATUS | |
| 35 | NOTEEXISTS | Does a Document Exist for this Order? | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_NOTEEXISTS | |
| 36 | ORDERTYPE_STATUS | Order-Type-Dependent Status Indicator | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /SAPAPO/OM_ORDERTYPE_STATUS | |
