| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | PO_NUMBER | Purchasing Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PO_ITEM_NO | Item Number of Purchasing Document | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | PO_SCHED_NO | Delivery Schedule Line Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | REC_PLANT | Receiving Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | SUP_PLANT | Issuing Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | SUP_VENDOR | Vendor Account Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | DELIV_DATE | Delivery Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | ATP_RESULT | Result of Availability Check | char | 1 | 0 | | | | Allow NULL? |
| 10 | SUBST_CTRL | Substitution Control | char | 1 | 0 | | | | Allow NULL? |
| 11 | CTRL_TYPE_ENH | Substitution Control Enhanced | char | 1 | 0 | | | | Allow NULL? |
| 12 | MATNR_ORIG | Original Material | nvarchar | 18 | 0 | | | | Allow NULL? |
| 13 | QUANTITY_ORIG | Original Material Quantity | decimal | 13 | 3 | | | | |
| 14 | UOM_ORIG | Original Material Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | MATNR_SUBST | Substitute Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 16 | QUANTITY_SUBST | Substitute Material Quantity | decimal | 13 | 3 | | | | |
| 17 | UOM_SUBST | Substitute Material Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | DATE_SUBST | Date of Substitution | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | TIME_SUBST | Time of Substitution | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | TSTAMP_SUBST | Substitution Time Stamp | decimal | 21 | 7 | | | | |
| 21 | APPLICATION | Calling Application in Substitution Process | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | SWITCH_TYPE | Switch Type: 1= Switchover; 2 = Switch Back | char | 1 | 0 | | | | Allow NULL? |
| 23 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | | | | Allow NULL? |
| 25 | EVALUATION_DATE | Evaluation Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 26 | SWITCH_PER_START | Switchover Period Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | SWITCH_PER_END | Switchover Period End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | TRANSFERRED | Indicator Transfer Data Record | char | 1 | 0 | | | | Allow NULL? |
| 29 | DATE_TRANS | Transfer Date of Switch Information | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | PACKAGE_ID | Package Identifier | nvarchar | 35 | 0 | | | | Allow NULL? |
