| 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 | 5 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
2 | OIU_RV_VLXAS | Valuation Cross Reference Association | 10 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
3 | OIU_RV_VLXAS_NEW | Valuation Cross Reference Association - New | 10 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPRevenue |
4 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 30 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
5 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 27 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPValuation |
6 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 30 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
7 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 22 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
8 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 27 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
9 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 19 | NI_OWN_ISQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |