| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 18 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
2 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 19 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
3 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 18 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
4 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 26 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
5 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 26 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
6 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 25 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
7 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 25 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
8 | OIU_SB_ACTMP | Actual Owner Level Contractual Allocations results at MP's | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
9 | OIU_SB_ACTMP_T | Actual Owner Level Contractual Allocations results at MP's | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
10 | OIU_SB_ACTWC | Actual Owner Level Contractual Allocations results at WC's | 18 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
11 | OIU_SB_ACTWC_T | Actual Owner Level Contractual Allocations results at WC's | 18 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
12 | OIU_SB_RNAMP | Residue and NGL actual at a MP level | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
13 | OIU_SB_RNAMP_T | Temporary Residue and NGL actual at a MP level | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
14 | OIU_SB_RNAWC | Residue and NGL actual at a WC level | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
15 | OIU_SB_RNAWC_T | Temporary Residue and NGL actual at a WC level | 17 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
TOPRevenue |
16 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 56 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
TOPTax Reporting |
17 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 25 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
18 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 25 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
19 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 35 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
20 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 25 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
21 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 20 | ACTL_ENERGY_U | Actual Energy Unit | nvarchar | 3 | 0 | | |
TOPValuation |
22 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 56 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |
23 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 35 | ACTL_ENERGY_U | Measurement unit | nvarchar | 3 | 0 | | |