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