| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPData Staging |
1 | RSTRANCLUSTINFO | Information for a data flow comparison | 8 | TGTTYPE | BW: Object Type (TLOGO) | nvarchar | 4 | 0 | | |
TOPTraders and Schedulers Workbench |
2 | OIJBRDH | RD header f.batch:Don't use(obsolete) & don't delete(XPRA) | 78 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
3 | OIJLOCMAT | OIL-TSW: Location Rundown/Planning material table | 67 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
4 | OIJRDH | Rundown header: Don't use (obsolete) & don't delete (XPRA) | 77 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
5 | OIJTGTYP | OIL-TSW: Target stock calculation type | 2 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
6 | OIJTGTYPTX | OIL-TSW: Target stock calculation type texts | 3 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
7 | OIJTSMAT | OIL-TSW: TS Rundown/Planning material table | 66 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |
8 | OIJ_RDHEAD | Stock Projection header | 80 | TGTTYPE | OIL-TSW: Target stock calculation type | nvarchar | 3 | 0 | | |