Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
---|---|---|---|---|---|---|---|---|---|---|
Interface 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 |