| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | TPSCON | OIL-TPI: External TPS Control Settings (8-Flag String) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | SHTYP | OIL-TPI: Default Bulk Shipment Type for Inbound Shipments | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | TPSTSO | OIL-TPI: Tank ID Req Mode - Sales Order | char | 1 | 0 | | | | Allow NULL? |
| 6 | TPSTSD | OIL-TPI: Tank ID Req Mode - Delivery | char | 1 | 0 | | | | Allow NULL? |
| 7 | TPSTDC | OIL-TPI: Tank ID Req Mode - Delivery Confirmation | char | 1 | 0 | | | | Allow NULL? |
| 8 | UOMVOL | OIL-TPI: Volume Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 9 | UOMMAS | OIL-TPI: Weight Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 10 | UOMLEN | OIL-TPI: Length Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | UOMVFR | OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 12 | UOMMFR | OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 13 | UOMTIM | OIL-TPI: Time Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | UOMTMP | OIL-TPI: Temperature Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | UOMDIS | OIL-TPI: Distance Unit of Measure Used by External TPS | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | DLOCTP | OIL-TPI: Default Receiving Location Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | DABTNR | OIL-TPI: Default Contact Person Department | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | DPARFN | OIL-TPI: Default MRN Partner Role/Relation Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | IFWAIT | OIL-TPI: Interface Wait Time Between Retries (in Seconds) | nvarchar | 6 | 0 | | | | Allow NULL? |
| 20 | IFRTRY | OIL-TPI: Number of Transmission Retries Before Termination | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | KSCHL_O | Output type for transportation planning systems | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | DR_VEH | OIL-TPI: Deactivate Driver/Vehicle Assignment | char | 1 | 0 | | | | Allow NULL? |
| 23 | EXT_NUM | OIL-TPI: Use External Number for Document Creation | char | 1 | 0 | | | | Allow NULL? |
| 24 | OIK_EQ_A | OIL-TPI: Check equal assignm. with loading or sched. date | char | 1 | 0 | | | | Allow NULL? |
| 25 | MAX_STAT | OIL-TPI: Max. Default Status | char | 1 | 0 | | | | Allow NULL? |
| 26 | MANETA | OIL-TPI: Manual Entry of ETA In SPW | char | 1 | 0 | | | | Allow NULL? |
| 27 | DEFTRIP | OIL-TPI: Don't default trip sequence in SPW | char | 1 | 0 | | | | Allow NULL? |
| 28 | DISPSUM | OIL-TPI: Don't show the quantity sum line in SPW | char | 1 | 0 | | | | Allow NULL? |
