| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIndustry Solution Oil |
1 | TOI0_REL_PL | IS-OIL: Relevance customizing for planned orders | 14 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
TOPInterface to Terminal Automation System |
2 | TOIKCCGREL | TPI: Customer capacity group for Relevancy Type | 2 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
TOPRevenue |
3 | OIUH_DD_CONFIG | DD names per program with Open Mode (I/O) for QSAM files | 7 | RELEVANCE_TYPE | File Relevance Type | nvarchar | 1 | 0 | | |
TOPTraders and Schedulers Workbench |
4 | OIJ_SPREL | Stock projection relevance | 3 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
5 | TOI0_REL_MM | Relevance customizing for MM Documents | 25 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
6 | TOI0_REL_NOM | IS-OIL: Relevance customizing for Nominations | 23 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
7 | TOI0_REL_PP | IS-OIL: Relevance customizing for PP Documents | 17 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
8 | TOI0_REL_RES | Relevance customizing for Reservations | 21 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
9 | TOI0_REL_SD | IS-OIL: Relevance customizing for SD Documents | 28 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
10 | TOI0_REL_TC | TSW relevance table for trading contract | 6 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
11 | TOI0_REL_VAL | IS-Oil: Valid relevance values | 3 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
12 | TOI0_REL_VALT | IS-Oil: Relevance description | 4 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
13 | TOIJ_EL_PR_REL | Nomination Relevance<->Prorate Calculation | 2 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
14 | TOIJ_IFAPO_PEG | APO SNP TSW Order transfer - Define auto pegging | 3 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
15 | TOIJ_LAYT_RELV | Assign laytime filter to relevance type | 3 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |
TOPTransportation Planning Interface |
16 | TOIKTPIREL | TPI: Transportation Planning Point for Relevancy Type | 2 | RELEVANCE_TYPE | IS-Oil: Relevance type | nvarchar | 6 | 0 | | |