| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBalancing |
1 | OIUBL01_PRD_GRPD | Ballancing Product Group Detail - Product code Xref | 4 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
TOPCheck Input |
2 | OIUCI_CDEXD | CDEX Detail | 9 | PD_CD | CDEX Product Code | nvarchar | 2 | 0 | | |
3 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 19 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
4 | OIUCI_PDX | Purchaser DOI Cross Reference | 13 | PD_CD | Product | nvarchar | 3 | 0 | | |
TOPCheck Write |
5 | OIUCW_EXTD | Extended Details from Payment Run | 18 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
6 | OIUCW_PAYMENT | Payment Details from Payment Run | 11 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
7 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 7 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
TOPContractual Allocation |
8 | OIUCA_ENT_VT | CA Allocation Entitlement Volume Types | 5 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
TOPOwnership |
9 | OIUOW_DOACC | DOI Owner Override Account Codes | 3 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
10 | OIUOW_DOACC_WK | DOI Owner Override Account Codes Worktable | 3 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
11 | OIUCM_CMPNT | Common table for cross-referencing product codes and compo | 2 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
12 | OIU_CM_MAT_PRCD | Material and Product Code (processing) Xref | 4 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
13 | OIU_CM_PDCD | Product Codes - Tblcm003 | 2 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
14 | OIU_CM_PDCD_TX | Product Codes - Tblcm003 - Text | 3 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
15 | OIU_PR_WVMTD | Well Completion Volumes Measurement Type Determination | 3 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
TOPRevenue |
16 | OIUAR_BAL_TRFR | Accounts Receivable Balance Transfer | 10 | PD_CD | Product | nvarchar | 3 | 0 | | |
17 | OIUAR_REC_BAL | Accounts Receivable Balance | 9 | PD_CD | Product | nvarchar | 3 | 0 | | |
18 | OIUAR_REC_BAL_H | Accounts Receivable Balance History | 9 | PD_CD | Product | nvarchar | 3 | 0 | | |
19 | OIUAR_RESPID | Accounts Receivable Responsibility ID | 4 | PD_CD | Product | nvarchar | 3 | 0 | | |
20 | OIUE1_LSSL_SUM | Legal Suspense Summary | 6 | PD_CD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | |
21 | OIUE2_ESCH_DTL | Proc 2.0 - Escheat - Owner Details | 7 | PD_CD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | |
22 | OIUE2_ESCH_DTLH | Proc 2.0 - Escheat - Owner Detail History | 7 | PD_CD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | |
23 | OIUE2_ESCROW_DTL | Proc 2.0 - WY Escrow - Owner Details | 7 | PD_CD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | |
24 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 20 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
25 | OIUH_NM_PDCD_XRF | New Mexico Product Code Cross Reference (TBLTR091) | 2 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
26 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 18 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
27 | OIUH_RV_JEINTF | PRA Journal Entries | 19 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
TOPRoyalty Reporting |
28 | OIUREP_CODE_XREF | Reg Reporting Product/Volume Type to Report Code Cross Ref | 7 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
29 | OIUREP_STAT_SPLT | Regulatory Reporting: Well Status Split table | 9 | PD_CD | Minor Product Code | nvarchar | 2 | 0 | | |
TOPTax Reporting |
30 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 15 | PD_CD | Full three char. product code (Major and Detail Products) | nvarchar | 3 | 0 | | |
31 | OIUX4_BALANCE | Taxes Payable Balance | 5 | PD_CD | Product | nvarchar | 3 | 0 | | |
32 | OIUX4_BALANCE_H | Taxes Payable Balance History | 5 | PD_CD | Product | nvarchar | 3 | 0 | | |
33 | OIUX4_BAL_CTGZN | Taxes Payable Balance Categorization | 5 | PD_CD | Product | nvarchar | 3 | 0 | | |
34 | OIUX4_COMMENTS | Taxes Payable Comments | 5 | PD_CD | Product | nvarchar | 3 | 0 | | |
TOPValuation |
35 | OIURV_CRH_HST | Combined Run Header History | 6 | PD_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
36 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 21 | PD_CD | Product Code | nvarchar | 3 | 0 | | |
37 | OIURV_DOC_OOBJE | Out Of Balance JEs | 11 | PD_CD | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
38 | OIURV_DUAL_JEBR | Dual Accounting JE Backout / Rebook | 8 | PD_CD | OIUH_CHAR3 | nvarchar | 3 | 0 | | |
39 | OIU_RV_MKTRAN | Transaction Code Cross Reference With MarketingType Code | 4 | PD_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |