| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIU_RV_VCRWI | Valuation Cross Reference Working Interest | 4 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
2 | OIU_RV_VCRWI_NEW | Valuation Cross Reference Working Interest - New | 4 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
3 | OIU_RV_VLXAS | Valuation Cross Reference Association | 4 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
4 | OIU_RV_VLXAS_NEW | Valuation Cross Reference Association - New | 4 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
TOPRevenue |
5 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 25 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
6 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 19 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
TOPValuation |
7 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 25 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
8 | OIURV_DOC_OOBJE | Out Of Balance JEs | 16 | WI_OWN_NO | OIUH_CHAR6 | nvarchar | 6 | 0 | | |
9 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 17 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
10 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 19 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
11 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 14 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
12 | OIUVL_GASDTL_CUR | Gas statement Detail | 5 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
13 | OIUVL_GASDTL_HST | Gas statement Detail | 5 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
14 | OIUVL_GASRPTD | Gas statement report detail | 4 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |
15 | OIUVL_SCAUDIT | Settlement statement batch | 9 | WI_OWN_NO | Working Interest Owner | nvarchar | 10 | 0 | | |