| 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) | 3 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| TOPBulk Distribution Requirements Planning |
| 2 | OIIGMMH | GMM: Meter history | 21 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| TOPTraders and Schedulers Workbench |
| 3 | OIJNE | Nomination Events | 38 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 4 | OIJNOMSUBITEMS | Nomination Sub-Item | 19 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 5 | OIJTE | TSW Ticket Events | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 6 | OIJ_EL_DOC_FLOW | OIL TSW: Document flow | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 7 | OIJ_EL_ERROR_LOG | OIL-TSW: Error log for ticketing process | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 8 | OIJ_EL_TCKET_UOM | Universal ticket additional units of measure | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 9 | OIJ_EL_TICKET_H | Universal ticket table | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 10 | OIJ_EL_TICKET_I | Universal ticket item table | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 11 | OIJ_EL_TKT_I_O1 | Appendix: TSW Ticket item - Conversion Parameters | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 12 | OIJ_EL_TKT_I_O2 | Appendix: TSW Ticket item - Additional Quantities | 2 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
| 13 | OIJ_TKT_TMST_PR | Ticket Timestamp Transfer Control Table | 1 | TICKET_KEY | OIL-TSW: Ticket key | nvarchar | 20 | 0 | | |
