| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUPH_RV_RJE | Journal Entry (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
2 | OIUP_ME_MEDOC | Measurement document header (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
3 | OIUP_ME_MEDOC_IT | Measurement document item (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
4 | OIUP_PR_MPVL | PRA: Measurement Point Volumetric Data (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
5 | OIUP_PR_WCDVLH | WC Disposition Volumes Header (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
6 | OIUP_PR_WCTST | Well Test (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
7 | OIUP_SB_ACTMP | Actual Owner Level CA results at MP's (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
8 | OIUP_SB_ACTWC | Actual Owner Level CA results at WC's (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
9 | OIUP_SB_ENTMP | MP level owner entitlements (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
10 | OIUP_SB_ENTWC | WC level owner entitlements (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
11 | OIUP_SB_RNAWC | Residue and NGL actual at a WC level (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |
12 | OIUP_SB_RNEWC | Residue and NGL entitlements at a WC level (PDM Shadow) | 2 | PDM_GUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | | |