| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCheck Input |
1 | OIUCI_DOC_CIREJ | Contains VL/RD rejects to be reported to Check Input | 9 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
2 | OIUCI_JE | Incoming Check Journalized. Temporary hold | 38 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
3 | OIUCI_SPC_DIST | Purchaser DOI Cross Reference | 11 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPCheck Write |
4 | OIUCW_EXTD | Extended Details from Payment Run | 8 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
5 | OIUCW_PAYMENT | Payment Details from Payment Run | 28 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
6 | OIU_CW_SUM_PAY | Summarized Payable Table for Check Write | 10 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPProduction and Revenue Accounting |
7 | OIUPH_RV_RJE | Journal Entry (PDM Shadow) | 89 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
TOPRevenue |
8 | OIUE2_JEINTF | Proc 2.0 - JE Interface Table | 39 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
9 | OIUH_RV_ARINTF | PRA Journal Entries to A/R interface table | 37 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
10 | OIUH_RV_BR | Bearer | 7 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
11 | OIUH_RV_DO | DOI Owner | 8 | OWN_INT_SEQ_NO | OWNER INTEREST SEQUENCE NUMBER | nvarchar | 2 | 0 | | |
12 | OIUH_RV_EXSL | Journal Entry Expense Subledger Table | 14 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
13 | OIUH_RV_EXSL_H | Oil and Gas appl table | 14 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
14 | OIUH_RV_INSL | Journal Entry Income Subledger Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
15 | OIUH_RV_INSL_H | Oil and Gas appl table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
16 | OIUH_RV_JE | Journal Entry | 87 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
17 | OIUH_RV_JEINTF | PRA Journal Entries | 38 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
18 | OIUH_RV_LSSL | Journal Entry Legal Suspense Subledger Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
19 | OIUH_RV_LSSL_H | Oil and Gas appl table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
20 | OIUH_RV_MSSL | Journal Entry Miscellaneous Subledger Table | 20 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
21 | OIUH_RV_MSSL_H | Oil and Gas appl table | 20 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
22 | OIUH_RV_OPSL | Journal Entry Owner Payable Subledger Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
23 | OIUH_RV_OPSL_H | Oil and Gas OPSL History Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
24 | OIUH_RV_RJE | Journal Entry | 88 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
25 | OIUH_RV_STSL | Journal Entry Statistical Subledger Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
26 | OIUH_RV_STSL_H | Oil and Gas appl table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
TOPRoyalty Reporting |
27 | OIUH_TEMP_OPSL | Journal Entry Owner Payable Subledger Table | 17 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
28 | OIUREP_XTRCT_ROY | Extract Royaty Data for the current reporting period | 37 | OWN_INT_SEQ_NO | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
TOPTax Reporting |
29 | OIUX3_JEINTF | Tax Reporting - JE Interface Table | 47 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |
TOPValuation |
30 | OIURV_DOC_JEINTF | Revenue Document Concept - JEINTF temp table | 40 | OWN_INT_SEQ_NO | Owner Interest Sequence Number | nvarchar | 2 | 0 | | |