| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 9 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
2 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 19 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
3 | OIU_PR_MPTRNH | PRA: Measurement Point Transporter Xref | 7 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
4 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 8 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
5 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 18 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
6 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 18 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
7 | OIU_PR_WCTRNH | PRA: Well Completion Transporter Xref | 7 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
TOPRevenue |
8 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 80 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
TOPValuation |
9 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 21 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
10 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 80 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
11 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 43 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
12 | OIUVL_GASDTL_CUR | Gas statement Detail | 10 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
13 | OIUVL_GASDTL_HST | Gas statement Detail | 10 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
14 | OIUVL_GASRPTD | Gas statement report detail | 11 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
15 | OIUVL_OILRPTD | Oil statement report detail | 9 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
16 | OIUVL_OILTKT_CUR | Oil Ticket Detail | 14 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |
17 | OIUVL_OILTKT_HST | Oil Ticket Current | 14 | TRNSP_REF_NO | Transporter Reference Number | nvarchar | 25 | 0 | | |