| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TKNUM | Shipment Number (Vehicle Space Optimization) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | CHANGE | Control Display/Change for External OCX (VSO) | char | 1 | 0 | | | | Allow NULL? |
| 4 | LANGUAGE | Language of the Tool for VSO (acc. to ISO 639) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 5 | OPT_MOD | Optimization Model for Vehicle Space Optimization | nvarchar | 2 | 0 | | | | Allow NULL? |
| 6 | REST_SEP | Pack Remaining Material Separately (VSO) | char | 1 | 0 | | | | Allow NULL? |
| 7 | WEIGHT_CHK | Weight Check (Vehicle Space Optimization) | char | 1 | 0 | | | | Allow NULL? |
| 8 | CONTACT_COEF_CHK | Contact Coefficient Check in Vehicle Space Optimization | char | 1 | 0 | | | | Allow NULL? |
| 9 | CONTACT_COEF | Contact Coefficient in Percent (VSO) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | UNLOAD_SEQ_CHK | Follow Unloading Sequence for Loading (VSO) | char | 1 | 0 | | | | Allow NULL? |
| 11 | CALC_LAYER_CHK | Calculate Layer Pattern of Packaging Material (VSO) | char | 1 | 0 | | | | Allow NULL? |
| 12 | MAX_ITER | Maximum Number of Iterations of VSO | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | MAX_ITER_WO_IMPR | Maximum Number of Iterations without Improvement (VSO) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 14 | MAX_SECONDS | Maximum Calculation Time of VSO in Seconds | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | NO_GRAPHIC_CHK | Supression of the Graphic of Vehicle Space Optimization | char | 1 | 0 | | | | Allow NULL? |
| 16 | LMH_CHK | Load-Related Calculation Type of Vehicle Space Optimization | char | 1 | 0 | | | | Allow NULL? |
| 17 | DW_FORK | Fork Lift Uses Double Fork Width (VSO) | char | 1 | 0 | | | | Allow NULL? |
| 18 | MEASURE_UNIT | Determination of the Unit of Measure System of VSO | char | 1 | 0 | | | | Allow NULL? |
| 19 | ABM_UNIT | Unit of Measure for Legs (Length, Width, Height) for VSO | nvarchar | 3 | 0 | | | | Allow NULL? |
| 20 | ABM_CONV_Z | Numerator for Converting Measure (VSO) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | ABM_CONV_N | Denominator for Converting Measure (VSO) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 22 | GEW_UNIT | Weight Unit for Vehicle Space Optimization | nvarchar | 3 | 0 | | | | Allow NULL? |
| 23 | GEW_CONV_Z | Numerator for Converting Weights (VSO) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | GEW_CONV_N | Denominator for Converting Weights (VSO) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | CREATION_DATE | Created on (Vehicle Space Optimization) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | GUID | GUID in 'RAW' format | varbinary | 16 | 0 | | | | |
| 28 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | | | | |