| 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 | 5 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
2 | OIJBRDDOC | Rundown item / document X-ref table for Batch - WILL EXPIR | 13 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
3 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 9 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
4 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 9 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
5 | OIJNE | Nomination Events | 5 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
6 | OIJNOMH | Nomination Header | 6 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
7 | OIJNOMHVERS | Nomination Header Version Table | 8 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
8 | OIJNOMM | Nomination Material Balance | 4 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
9 | OIJRDACTUALS | IS-OIL TSW: Table to store the actuals | 5 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
10 | OIJRDDOC | Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE | 13 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
11 | OIJRDNOM | Stock Projection item / nomination X-ref table | 9 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
12 | OIJSUBITEMEVENTS | Nomination Sub Item Events | 6 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
13 | OIJWL | OIL-TSW: Worklist | 7 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
14 | OIJ_EL_DOC_H_REF | Oil TSW: Document header reference to nomination; not used | 5 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
15 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 9 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
16 | OIJ_EL_TICKET_I | Universal ticket item table | 12 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
17 | OIJ_SCHED | Planned Schedule Lines | 14 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
18 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 16 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |
19 | ROIJRDACT | IS-OIL TSW: Table to store the actuals X-ref table | 5 | NOMNR | Nomination number | nvarchar | 20 | 0 | | |