| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTraders and Schedulers Workbench |
1 | OIJBRDACTUALS | IS-OIL TSW: Table to store the actuals | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
2 | OIJBRDDOC | Rundown item / document X-ref table for Batch - WILL EXPIR | 12 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
3 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
4 | OIJDOCFL | OIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
5 | OIJERRLOG | TSW: Error log of create/change documents | 4 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
6 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 11 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
7 | OIJNE | Nomination Events | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
8 | OIJNOMC | OIL-TSW: Nomination copy table | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
9 | OIJNOMCOMM | Nomination Partner Communication | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
10 | OIJNOMI | Nomination Item | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
11 | OIJNOMIVERS | Nomination Item Version Table | 4 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
12 | OIJNOMIWL | OIL-TSW: Nomination item worklist entries | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
13 | OIJNOMR | Nomination Reference Documents | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
14 | OIJNOMST | Nomination status (Header and Item) | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
15 | OIJNOMSUBITEMS | Nomination Sub-Item | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
16 | OIJRDACTUALS | IS-OIL TSW: Table to store the actuals | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
17 | OIJRDDOC | Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE | 12 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
18 | OIJRDNOM | Stock Projection item / nomination X-ref table | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
19 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
20 | OIJWL | OIL-TSW: Worklist | 9 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
21 | OIJ_EL_DFLOW_SUB | TSW - Document flow for sub items | 4 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
22 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 6 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
23 | OIJ_EL_ELOG_SUB | TSW: Error log for ticketing process at sub item | 4 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
24 | OIJ_EL_ERROR_LOG | OIL-TSW: Error log for ticketing process | 8 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
25 | OIJ_EL_TICKET_I | Universal ticket item table | 14 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
26 | OIJ_PEG | obsolete table (will be cleaned up) | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
27 | OIJ_REPORT_QUAN | TSW: Reported Nomination quantities into/out of inventory | 3 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
28 | OIJ_SCHED | Planned Schedule Lines | 9 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
29 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 18 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |
30 | ROIJRDACT | IS-OIL TSW: Table to store the actuals X-ref table | 7 | NOMIT | Nomination Key Item | nvarchar | 10 | 0 | | |