| 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 | 9 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
2 | OIJDOCFL | OIL-TSW : TICKET DOCUMENT FLOW TABLE Obsolete, do not use | 2 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
3 | OIJERRLOG | TSW: Error log of create/change documents | 2 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
4 | OIJHCT01 | OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | 2 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
5 | OIJHUOM | OIL-TSW: Ticket additional units of measure | 2 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
6 | OIJRDACTUALS | IS-OIL TSW: Table to store the actuals | 9 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
7 | OIJ_EL_TICKET_H | Universal ticket table | 6 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |
8 | ROIJRDACT | IS-OIL TSW: Table to store the actuals X-ref table | 9 | TICKETNR | OIL-TSW: External ticket number | nvarchar | 20 | 0 | | |