| 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 | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
2 | OIUREP_ARCVOLHIS | Archived Reported Volume Data by Reporting Entities | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
3 | OIUREP_ROYHISTBK | Backup table for OIUREP_ROYHIST | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
4 | OIUREP_VOLHISTBK | Backup table for OIUREP_VOLHIST | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
5 | OIUX1_ARCH_MKTH | Reporting history for marketing costs for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
6 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
7 | OIUX1_ARCH_VOLH | Reported Volume Data by PUID | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
8 | OIUX1_ARCH_XMPH | Reporting history for tax exemptions | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
9 | OIUX2_PUID_MKTH | Reporting history for marketing costs for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
10 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
11 | OIUX2_PUID_XMPH | Reporting history for tax exemptions | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
12 | OIUREP_AGY_VLTP | Agency defined Volume Types | 2 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
13 | OIUREP_AGY_VTPTX | Text table for Agency defined Volume Type | 3 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
14 | OIUREP_ROYHIST | Reported Royalty and Volume Data by Reporting Entities | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
15 | OIUREP_ROY_DATA | Reported Royalty and Volume Data by Reporting Entities | 13 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
16 | OIUREP_VLTP_XREF | Cross reference between Agency defined & PRA volume types | 3 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
17 | OIUREP_VOLHIST | Reported Volume Data by Reporting Entities | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
18 | OIUREP_VOL_DATA | Reported Volume Data by Reporting Entities | 13 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
TOPTax Reporting |
19 | OIUX1_PUID_MKTH | Reporting history for marketing costs for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
20 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
21 | OIUX1_PUID_VOLH | Reported Volume Data by PUID | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
22 | OIUX1_PUID_XMPH | Reporting history for tax exemptions | 8 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
23 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 13 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
24 | OIUX1_RPT_VOLH | Reported Volume Data by Reporting Entities | 14 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |
25 | OIUX2_PUID_VOLH | Reported Volume Data by PUID | 9 | AGENCY_VOL_TYPE | Agency defined Volume type | nvarchar | 2 | 0 | | |