| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUREP_ARCROYHIS | Archived Reported Royalty and Volume Data | 11 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 10 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
3 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 11 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
4 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 10 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
TOPRoyalty Reporting |
5 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 11 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
6 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 15 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
7 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 10 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |
8 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 14 | UNIT_PROPERTY_NO | Joint Venture | nvarchar | 6 | 0 | | |