| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIU_RV_VCRNI | Valuation Cross Reference Non-Working Interest (Settlement | 4 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
2 | OIU_RV_VLXAS | Valuation Cross Reference Association | 9 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
3 | OIU_RV_VLXAS_NEW | Valuation Cross Reference Association - New | 9 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPRevenue |
4 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 29 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
5 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 26 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
TOPValuation |
6 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 29 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
7 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 21 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
8 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 26 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |
9 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 18 | NI_INT_TYPE_CD | Participant Interest Type | nvarchar | 2 | 0 | | |