| 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 | 7 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
2 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 7 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
3 | OIKCF | TAS - Control Field Data | 3 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
4 | OIKCFW | TAS - Control Field Data | 3 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
5 | OIKLID | TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | 3 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
6 | OIKLIDR | TD - TAS Reference Table | 4 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
7 | OIKLIDW | TAS LID Working version (NOTE: keep DB eq to DB OIKLID) | 3 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
8 | OIKLT | TAS Load ID Types | 2 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
9 | OIKLTC | Load ID Types | 2 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
10 | OIKLTT | Load ID - Type Texts | 3 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
11 | TOIKTRV | LID TAS relevance determination | 16 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |
12 | TOIKTRVS | LID TAS relevance determination Shipment | 10 | LIDTYPE | LOAD ID type | nvarchar | 6 | 0 | | |