| 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 | 83 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
2 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 84 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
3 | OIKCF | TAS - Control Field Data | 19 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
4 | OIKCFW | TAS - Control Field Data | 19 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
5 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 50 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
6 | OIKLIDR | TD - TAS Reference Table | 50 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
7 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 50 | TRIP | Trip Number | nvarchar | 5 | 0 | | |
TOPTraders and Schedulers Workbench |
8 | OIGSV | TD Vehicles in Transport/Shipment | 47 | TRIP | Trip Number | nvarchar | 5 | 0 | | |