| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | OIGVNHI | Vehicle Name History Table | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
2 | OIGVNHISTORY | Vehicle Name History Table | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
3 | OIGVNHI_T | OIL-TSW : Vehicle name history text table | 3 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
TOPClaims Management |
4 | ICLPART | Participants | 24 | VEHICLE | Vehicle | nvarchar | 4 | 0 | | |
5 | ICSPART | Participant in Claim | 24 | VEHICLE | Vehicle | nvarchar | 4 | 0 | | |
TOPDownloadUpload |
6 | /DSD/HH_RAHD | DSD Route Settlement: Tour Header Data | 5 | VEHICLE | Vehicle Number | nvarchar | 18 | 0 | | |
TOPInterface to Terminal Automation System |
7 | OIK01 | IS-OIL/TAS: LID Document Data | 79 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
8 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 80 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
9 | OIKCF | TAS - Control Field Data | 15 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
10 | OIKCFW | TAS - Control Field Data | 15 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
11 | OIKDCSTEP | Delivery confirmation steps (temporary data) | 5 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
12 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 46 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
13 | OIKLIDR | TD - TAS Reference Table | 46 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
14 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 46 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
15 | OIKVD | TPI: Vehicle/Driver assignment | 5 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
16 | TOIKTRVS | LID TAS relevance determination Shipment | 5 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
TOPRemote Logistics Management |
17 | OIO_SH_VOYAGE | Voyages | 6 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
18 | OIO_VMIS_RESC | RLM VMIS: Rescue Material on Vehicle | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
TOPService Station Retailing |
19 | OIREUPLKXXXX | SSR PC: Template for generated DTF tables (header) | 40 | VEHICLE | SSR PC: Number of the vehicle (fleet cards) | nvarchar | 6 | 0 | | |
TOPStock Visibility |
20 | /DSD/SV_ERROR_HD | DSD SV Error Table Movement Header | 4 | VEHICLE | Vehicle Number | nvarchar | 18 | 0 | | |
21 | /DSD/SV_LC_HD | DSD LC: Loading Confirmation Header | 9 | VEHICLE | Vehicle | nvarchar | 18 | 0 | | |
22 | /DSD/SV_MM_HD | DSD SV Material Movement Header | 4 | VEHICLE | Vehicle Number | nvarchar | 18 | 0 | | |
23 | /DSD/SV_QUANT | DSD SV Truck Stock | 2 | VEHICLE | Vehicle Number | nvarchar | 18 | 0 | | |
TOPTour Status |
24 | /DSD/ST_STATUS | Current tour status | 9 | VEHICLE | Vehicle | nvarchar | 18 | 0 | | |
TOPTraders and Schedulers Workbench |
25 | OIGSV | TD Vehicles in Transport/Shipment | 4 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
26 | OIGV | TD Vehicle Header | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
27 | OIGVT | TD Vehicle Header Text | 3 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
28 | OIGVTU | TD Vehicle - Transport Unit Assignment | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
29 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 21 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
30 | OIJ_EL_CP_LAYT | Charter party and laytime and demurrage agreement | 8 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
31 | OIJ_EL_TICKET_I | Universal ticket item table | 18 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
32 | OIJ_IF_CIF_IMV | IMod Reference Table for TD Vehicle | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
33 | TOIJ03_GL_ACT | Activate Gain Loss and Left on Vehicle | 4 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |
TOPTransportation and Distribution |
34 | OIGVL | TD Licenses Needed for Vehicle | 2 | VEHICLE | TD Vehicle Number | nvarchar | 10 | 0 | | |