| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_5_WCDVLH | fill hedaer for well completion | 8 | ORIG_MP_NO | delivery network for is oil | nvarchar | 20 | 0 | | |
TOPProduction and Revenue Accounting |
2 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 45 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
3 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 25 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
4 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 11 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
5 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 12 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
6 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 12 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
7 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 44 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
8 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 24 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
9 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 24 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
10 | OIU_RV_VXDS | Valuation Cross Reference Date Stamp | 15 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
11 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 10 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
12 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 10 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
13 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 11 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
14 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 11 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
15 | OIU_SB_CTRMP | Volumes for sale | 5 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
16 | OIU_SB_CTRMP_T | Volumes for sale | 5 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
17 | OIU_SB_CTRWC | Volumes for sale | 6 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
18 | OIU_SB_CTRWC_T | Volumes for sale | 6 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
19 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 10 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
20 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 10 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
21 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 11 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
22 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 11 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
TOPRevenue |
23 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 31 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
24 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 37 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
TOPValuation |
25 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 31 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
26 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 339 | ORIG_MP_NO | Measurement point number | nvarchar | 20 | 0 | | |
27 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 37 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
28 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 20 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
29 | OIUVL_GASDTL_CUR | Gas statement Detail | 4 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
30 | OIUVL_GASDTL_HST | Gas statement Detail | 4 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
31 | OIUVL_OILTKT_CUR | Oil Ticket Detail | 5 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |
32 | OIUVL_OILTKT_HST | Oil Ticket Current | 5 | ORIG_MP_NO | Original measurement point number | nvarchar | 20 | 0 | | |