| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_NOMTK | TDMS Header for TSW Nomination(IS OIL) | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
TOPTraders and Schedulers Workbench |
2 | OIJ03_LOV | TSW: Table for Left on Vehicle Entries | 5 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
3 | OIJBRDACTUALS | IS-OIL TSW: Table to store the actuals | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
4 | OIJBRDDOC | Rundown item / document X-ref table for Batch - WILL EXPIR | 11 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
5 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
6 | OIJDOCFL | OIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
7 | OIJERRLOG | TSW: Error log of create/change documents | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
8 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 10 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
9 | OIJNE | Nomination Events | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
10 | OIJNOMC | OIL-TSW: Nomination copy table | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
11 | OIJNOMCOMM | Nomination Partner Communication | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
12 | OIJNOMH | Nomination Header | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
13 | OIJNOMHATLOAD | Nomination Hatch load sequence plan | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
14 | OIJNOMHATPLAN | Nomination: hatch plan | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
15 | OIJNOMHVERS | Nomination Header Version Table | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
16 | OIJNOMHWL | OIL-TSW: Nomination header worklist entries | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
17 | OIJNOMI | Nomination Item | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
18 | OIJNOMIVERS | Nomination Item Version Table | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
19 | OIJNOMIWL | OIL-TSW: Nomination item worklist entries | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
20 | OIJNOMI_LDS | Load / Discharge scheduling for nominations | 5 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
21 | OIJNOMM | Nomination Material Balance | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
22 | OIJNOMR | Nomination Reference Documents | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
23 | OIJNOMST | Nomination status (Header and Item) | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
24 | OIJNOMSUBITEMS | Nomination Sub-Item | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
25 | OIJRDACTUALS | IS-OIL TSW: Table to store the actuals | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
26 | OIJRDDOC | Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE | 11 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
27 | OIJRDNOM | Stock Projection item / nomination X-ref table | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
28 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
29 | OIJWL | OIL-TSW: Worklist | 8 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
30 | OIJ_EL_DFLOW_SUB | TSW - Document flow for sub items | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
31 | OIJ_EL_DOC_H_REF | Oil TSW: Document header reference to nomination; not used | 4 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
32 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 5 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
33 | OIJ_EL_ELOG_SUB | TSW: Error log for ticketing process at sub item | 3 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
34 | OIJ_EL_ERROR_LOG | OIL-TSW: Error log for ticketing process | 7 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
35 | OIJ_EL_TICKET_I | Universal ticket item table | 13 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
36 | OIJ_PEG | obsolete table (will be cleaned up) | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
37 | OIJ_REPORT_QUAN | TSW: Reported Nomination quantities into/out of inventory | 2 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
38 | OIJ_SCHED | Planned Schedule Lines | 8 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
39 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 17 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |
40 | ROIJRDACT | IS-OIL TSW: Table to store the actuals X-ref table | 6 | NOMTK | Nomination (technical) Key | nvarchar | 20 | 0 | | |