| 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 | TTDS | MANDT | Allow NULL? |
| 2 | TPLST | Transportation planning point | nvarchar | 4 | 0 | CHAR | (N' ') | No | TTDS | TPLST | Allow NULL? |
| 3 | TPSCON | OIL-TPI: External TPS Control Settings (8-Flag String) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | OIK_TPSCON | Allow NULL? |
| 4 | SHTYP | OIL-TPI: Default Bulk Shipment Type for Inbound Shipments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TOIGS | OIK_TDSTYP | Allow NULL? |
| 5 | TPSTSO | OIL-TPI: Tank ID Req Mode - Sales Order | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_TPSTSO | Allow NULL? |
| 6 | TPSTSD | OIL-TPI: Tank ID Req Mode - Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_TPSTSD | Allow NULL? |
| 7 | TPSTDC | OIL-TPI: Tank ID Req Mode - Delivery Confirmation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_TPSTSC | Allow NULL? |
| 8 | UOMVOL | OIL-TPI: Volume Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMVOL | Allow NULL? |
| 9 | UOMMAS | OIL-TPI: Weight Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMMAS | Allow NULL? |
| 10 | UOMLEN | OIL-TPI: Length Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMLEN | Allow NULL? |
| 11 | UOMVFR | OIL-TPI: Volume Flow Rate Unit of Measure Used by Ext. TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMVFR | Allow NULL? |
| 12 | UOMMFR | OIL-TPI: Mass Flow Rate Unit of Measure Used by Ext. TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMMFR | Allow NULL? |
| 13 | UOMTIM | OIL-TPI: Time Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMTIM | Allow NULL? |
| 14 | UOMTMP | OIL-TPI: Temperature Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMTMP | Allow NULL? |
| 15 | UOMDIS | OIL-TPI: Distance Unit of Measure Used by External TPS | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | OIK_UOMDIS | Allow NULL? |
| 16 | DLOCTP | OIL-TPI: Default Receiving Location Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIK_DLOCTP | Allow NULL? |
| 17 | DABTNR | OIL-TPI: Default Contact Person Department | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TSAB | OIK_DABTNR | Allow NULL? |
| 18 | DPARFN | OIL-TPI: Default MRN Partner Role/Relation Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | OIFBRF1 | OIK_DPARFN | Allow NULL? |
| 19 | IFWAIT | OIL-TPI: Interface Wait Time Between Retries (in Seconds) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | OIK_IFWAIT | Allow NULL? |
| 20 | IFRTRY | OIL-TPI: Number of Transmission Retries Before Termination | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OIK_IFRTRY | Allow NULL? |
| 21 | KSCHL_O | Output type for transportation planning systems | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | NA_KSCHL_T | Allow NULL? |
| 22 | DR_VEH | OIL-TPI: Deactivate Driver/Vehicle Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_DR_VEH | Allow NULL? |
| 23 | EXT_NUM | OIL-TPI: Use External Number for Document Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_EXT_NUM | Allow NULL? |
| 24 | OIK_EQ_A | OIL-TPI: Check equal assignm. with loading or sched. date | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_EQ_A | Allow NULL? |
| 25 | MAX_STAT | OIL-TPI: Max. Default Status | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_MAX_STAT | Allow NULL? |
| 26 | MANETA | OIL-TPI: Manual Entry of ETA In SPW | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_MANETA | Allow NULL? |
| 27 | DEFTRIP | OIL-TPI: Don't default trip sequence in SPW | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_DEFTRIP | Allow NULL? |
| 28 | DISPSUM | OIL-TPI: Don't show the quantity sum line in SPW | char | 1 | 0 | CHAR | (N' ') | Yes | | OIK_DISPSUM | Allow NULL? |
