| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | CNVTDMS_05_NETW | fill header table for network delivery | 4 | PRD_DT | production date | nvarchar | 8 | 0 | | |
TOPProduction and Revenue Accounting |
2 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 17 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
3 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 10 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
4 | OIUXI_PPNH | XI: Prior Period Notification Header | 5 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
5 | OIU_PR_DNSTH | Delivery Network Status Header | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
6 | OIU_PR_HPPNH | Volumetric Historical PPN Header | 4 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
7 | OIU_PR_MPALF | MP Allocation Factor | 5 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
8 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 16 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
9 | OIU_PR_PPNH | Prior Period Notification Header | 4 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
10 | OIU_PR_RRWC | Regulatory Reporting Reallocated Well Completions | 4 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
11 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 9 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
12 | OIU_PR_WCALF | WC Allocation Factor | 6 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
13 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 9 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
14 | OIU_RV_NPC | Valuation Network Processing Control - Table | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
15 | OIU_RV_VLRVS | Valuation Reversal Notificaton | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
16 | OIU_RV_VPPN | Valuation Prior Period Notification | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
17 | OIU_RV_VPPNM | Manually Created Valuation Prior Period Notifications | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
18 | OIU_RV_VPPNU | Valuation Prior Period Notification | 3 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
TOPRoyalty Reporting |
19 | OIUREP_RWC | WCs that have been changed since previous report run | 6 | PRD_DT | Production date | nvarchar | 8 | 0 | | |
TOPValuation |
20 | OIURV_DOC_DTL_RV | Valuation Reversal Notificaton | 6 | PRD_DT | Production date | nvarchar | 8 | 0 | | |