| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_OIJBR | TDMS Header for SPW(IS Oil and Gas) | 3 | TSYST | Transport system | nvarchar | 10 | 0 | | |
2 | OIJTS_EXT | Transport system (IS-Oil TSW standard/core object ) | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
TOPLogistics - General |
3 | OIJTS | Transport system (IS-Oil TSW standard/core object ) | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
4 | B452 | TranSys | 4 | TSYST | Transport system | nvarchar | 10 | 0 | | |
5 | B453 | Shpm.type/Carrier/Inspector/Shipper/TranSys/TrspPlanPt | 8 | TSYST | Transport system | nvarchar | 10 | 0 | | |
6 | OIJ03_LOV | TSW: Table for Left on Vehicle Entries | 3 | TSYST | Transport system | nvarchar | 10 | 0 | | |
7 | OIJ03_LOVGLREF | TSW Gain loss/LOV Reference table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
8 | OIJBRD | OIL-TSW: Rundown table for Batch | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
9 | OIJBRDACTUALS | IS-OIL TSW: Table to store the actuals | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
10 | OIJBRDDOC | Rundown item / document X-ref table for Batch - WILL EXPIR | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
11 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
12 | OIJBRDNOM | Stock Projection item / nomination X-ref table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
13 | OIJCLIPBOARD | Clipboard Table for Railcar | 3 | TSYST | Transport system | nvarchar | 10 | 0 | | |
14 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 24 | TSYST | Transport system | nvarchar | 10 | 0 | | |
15 | OIJNOMH | Nomination Header | 29 | TSYST | Transport system | nvarchar | 10 | 0 | | |
16 | OIJNOMHVERS | Nomination Header Version Table | 31 | TSYST | Transport system | nvarchar | 10 | 0 | | |
17 | OIJPLANWL | OIJ-TSW: Worklist entries for planning | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
18 | OIJPLCAL | OIL-TSW: Planning Calendar Definitions | 4 | TSYST | Transport system | nvarchar | 10 | 0 | | |
19 | OIJPLCALT | OIL_TSW: Planning Calendar Texts | 5 | TSYST | Transport system | nvarchar | 10 | 0 | | |
20 | OIJRD | OIL-TSW: Rundown table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
21 | OIJRDACTUALS | IS-OIL TSW: Table to store the actuals | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
22 | OIJRDDOC | Rundown item / document X-ref table/ WILL EXPIRE IN FUTURE | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
23 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
24 | OIJRDNOM | Stock Projection item / nomination X-ref table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
25 | OIJRDPLAN | OIL-TSW: Rundown planning proposal drill-down | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
26 | OIJRDWL | Worklist items per Stock Projection object item | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
27 | OIJRRA | OIL-TSW: Partner roles | 11 | TSYST | Transport system | nvarchar | 10 | 0 | | |
28 | OIJTSLOC | OIL-TSW: transport system/location assignment table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
29 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
30 | OIJTSMATSEQ | Disallowed Material sequence within Transport system | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
31 | OIJWL | OIL-TSW: Worklist | 4 | TSYST | Transport system | nvarchar | 10 | 0 | | |
32 | OIJ_EL_CP_LAYT | Charter party and laytime and demurrage agreement | 69 | TSYST | Transport system | nvarchar | 10 | 0 | | |
33 | OIJ_EL_DOC_I_REF | Document item reference to nomination | 10 | TSYST | Transport system | nvarchar | 10 | 0 | | |
34 | OIJ_EL_DOC_MOT | Oil TSW: TSW Relevance of order item | 8 | TSYST | Transport system | nvarchar | 10 | 0 | | |
35 | OIJ_EL_TICKET_H | Universal ticket table | 9 | TSYST | Transport system | nvarchar | 10 | 0 | | |
36 | OIJ_LB_OPENINV | Opening inventory table for Location Balancing. | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
37 | OIJ_RDHEAD | Stock Projection header | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
38 | OIJ_SCHED | Planned Schedule Lines | 37 | TSYST | Transport system | nvarchar | 10 | 0 | | |
39 | OIJ_SIM_SCHED | obsolete table (will be cleaned up) | 6 | TSYST | Transport system | nvarchar | 10 | 0 | | |
40 | ROIJRDACT | IS-OIL TSW: Table to store the actuals X-ref table | 2 | TSYST | Transport system | nvarchar | 10 | 0 | | |
41 | S430 | SIS: (OIL-TSW) Sales document statistics by TSW object | 4 | TSYST | Transport system | nvarchar | 10 | 0 | | |
42 | S431 | PURCHIS: (OIL-TSW) Purchasing document stats by TSW object | 4 | TSYST | Transport system | nvarchar | 10 | 0 | | |
43 | TOI0_REL_NOM | IS-OIL: Relevance customizing for Nominations | 7 | TSYST | Transport system | nvarchar | 10 | 0 | | |
44 | TOIJ03_GL_ACT | Activate Gain Loss and Left on Vehicle | 3 | TSYST | Transport system | nvarchar | 10 | 0 | | |