| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | CNVTDMS_05_TICK | TDMS Header for TSW Ticket(IS OIL) | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| TOPBulk Distribution Requirements Planning |
| 2 | OIIGMMH | GMM: Meter history | 24 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 3 | OIJNOMSUBITEMS | Nomination Sub-Item | 22 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 4 | OIJTE | TSW Ticket Events | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 5 | OIJ_EL_DOC_FLOW | OIL TSW: Document flow | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 6 | OIJ_EL_ERROR_LOG | OIL-TSW: Error log for ticketing process | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 7 | OIJ_EL_TCKET_UOM | Universal ticket additional units of measure | 6 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 8 | OIJ_EL_TICKET_H | Universal ticket table | 4 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 9 | OIJ_EL_TICKET_I | Universal ticket item table | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 10 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 11 | OIJ_EL_TKT_I_O2 | Appendix: TSW Ticket item - Additional Quantities | 5 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
| 12 | OIJ_TKT_TMST_PR | Ticket Timestamp Transfer Control Table | 4 | TICKET_PURPOSE | OIL-TSW: Ticket Purpose | nvarchar | 1 | 0 | | |
