| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPTraders and Schedulers Workbench |
1 | OIJNOMC | OIL-TSW: Nomination copy table | 72 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
2 | OIJNOMI | Nomination Item | 72 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
3 | OIJNOMIVERS | Nomination Item Version Table | 74 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
4 | OIJ_SCHED | Planned Schedule Lines | 123 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
5 | TOIJ_EL_PR_REL | Nomination Relevance<->Prorate Calculation | 3 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
6 | TOIJ_EL_PR_RT | Prorate Calculation Routine Type | 1 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |
7 | TOIJ_EL_PR_RTT | Description of Prorate Calculation Routine Type | 2 | PRORATE_ROUTINE | Prorate Calculation Routine Type | nvarchar | 6 | 0 | | |