| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInterface to Terminal Automation System |
1 | OIK01 | IS-OIL/TAS: LID Document Data | 80 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
2 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 81 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
3 | OIKCF | TAS - Control Field Data | 16 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
4 | OIKCFW | TAS - Control Field Data | 16 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
5 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 47 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
6 | OIKLIDR | TD - TAS Reference Table | 47 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
7 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 47 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
8 | OIKVD | TPI: Vehicle/Driver assignment | 4 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
9 | OIJEV | TD-Vehicle ~ Berth Master Data Events | 6 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
10 | OIGD | TD Driver | 2 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
11 | OIGDH | TD Driver Shift | 2 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
12 | OIGDL | TD Driver's license data | 2 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |
13 | OIGSVD | TD Driver per Vehicle on a Shipment | 4 | DRIVERCODE | TD driver number | nvarchar | 10 | 0 | | |