| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCheck Input |
1 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 165 | TRNSP_NO | Transporter Number | nvarchar | 6 | 0 | | |
TOPContractual Allocation |
2 | OIUCA_CTMP | PRA: Transporter Contract Measurement Point XRef | 2 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
3 | OIUCA_CTWC | PRA: Transporter Contract Well Completion XRef | 2 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
TOPProduction and Revenue Accounting |
4 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 8 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
5 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 18 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
6 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 12 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
7 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 13 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
8 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 13 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
9 | OIU_PR_MPTRNH | PRA: Measurement Point Transporter Xref | 4 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
10 | OIU_PR_MPVL | PRA: Measurement Point Volumetric Data | 7 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
11 | OIU_PR_TWCDVH | Temporary Well Completion Volumes | 17 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
12 | OIU_PR_WCDVLH | Well Completion Disposition Volumes Header | 17 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
13 | OIU_PR_WCTRNH | PRA: Well Completion Transporter Xref | 5 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
14 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 11 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
15 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 11 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
16 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 12 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
17 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 12 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
18 | OIU_SB_CAMPH | Contract volumes by measurement point header | 7 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
19 | OIU_SB_CTRMP | Volumes for sale | 6 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
20 | OIU_SB_CTRMP_T | Volumes for sale | 6 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
21 | OIU_SB_CTRWC | Volumes for sale | 7 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
22 | OIU_SB_CTRWC_T | Volumes for sale | 7 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
23 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 11 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
24 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 11 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
25 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 12 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
26 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 12 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
TOPRevenue |
27 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 166 | TRNSP_NO | Transporter Number | nvarchar | 6 | 0 | | |
28 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 164 | TRNSP_NO | Transporter Number | nvarchar | 6 | 0 | | |
29 | OIUH_RV_JEINTF | PRA Journal Entries | 165 | TRNSP_NO | Transporter Number | nvarchar | 6 | 0 | | |
30 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 79 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
TOPValuation |
31 | OIURV_DOC_FRMMKT | Valuation Transactions Level 3 - Marketing Detail | 9 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
32 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 167 | TRNSP_NO | Transporter Number | nvarchar | 6 | 0 | | |
33 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 20 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
34 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 79 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
35 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 42 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
36 | OIUVL_GASDTL_CUR | Gas statement Detail | 9 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
37 | OIUVL_GASDTL_HST | Gas statement Detail | 9 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
38 | OIUVL_GASRPTD | Gas statement report detail | 10 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
39 | OIUVL_OILRPTD | Oil statement report detail | 8 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
40 | OIUVL_OILTKT_CUR | Oil Ticket Detail | 13 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |
41 | OIUVL_OILTKT_HST | Oil Ticket Current | 13 | TRNSP_NO | Transporter number | nvarchar | 10 | 0 | | |