| 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) | 3 | DUMMY_SEQ_FIELD | System number | nvarchar | 20 | 0 | | |
TOPRevenue |
2 | OIUE2_RV_CR | Proc 2.0 - Check Register | 3 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
3 | OIUH_CM_EC | Oil and Gas appl table | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
4 | OIUH_CM_EM | Oil and Gas appl table | 1 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
5 | OIUH_CM_INSTL | Revenue Installation Parameters | 2 | DUMMY_SEQ_FIELD | System Number | nvarchar | 10 | 0 | | |
6 | OIUH_PR_WCAP | Oil and Gas appl table | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
7 | OIUH_RV_AC | Account Control | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
8 | OIUH_RV_BR | Bearer | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
9 | OIUH_RV_CCH | Obsolete (4.72)-keep for 1 minor release- Cdex Check History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
10 | OIUH_RV_CHDD | Check Deduction Detail | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
11 | OIUH_RV_CNL | Cdex New Lease | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
12 | OIUH_RV_CR | Check Register | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
13 | OIUH_RV_DOACC | DOI Owner Override Acct Codes | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
14 | OIUH_RV_DOH | DOI Owner History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
15 | OIUH_RV_DOIWC | DOI / WC Cross Reference | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
16 | OIUH_RV_DPACC | DOI Override Acct Codes | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
17 | OIUH_RV_DPPC | DOI Product Processed Control | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
18 | OIUH_RV_DPPN | Division Order Prior Period Notification | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
19 | OIUH_RV_DPUC | DOI Product Use Control | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
20 | OIUH_RV_DTWK | Deduction/Tax Work Table | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
21 | OIUH_RV_ESCBA | Escheated Business Associates | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
22 | OIUH_RV_EXTD | RDI - Check Detail Subset | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
23 | OIUH_RV_FOT | Foreign Owner Tax Rates | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
24 | OIUH_RV_GRP | Group Number And Description | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
25 | OIUH_RV_IVS | Invoice Selection | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
26 | OIUH_RV_MDOI | MP/DOI Cross Reference | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
27 | OIUH_RV_MTAD | Producers Mkting Tax Exemption Allowance Detail | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
28 | OIUH_RV_MVT | Manual Void Check Transactions | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
29 | OIUH_RV_OIC | Owner Interest Calculations | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
30 | OIUH_RV_ONAB | Owners Negative Account Balance | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
31 | OIUH_RV_OSTA | Owners State Tax Adjustments | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
32 | OIUH_RV_PAC | Property Affiliated Company | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
33 | OIUH_RV_PRX | Purchaser Remitter Cross Reference | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
34 | OIUH_RV_RDTL | Royalty Details | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
35 | OIUH_RV_RJE | Journal Entry | 2 | DUMMY_SEQ_FIELD | System number | nvarchar | 20 | 0 | | |
36 | OIUH_RV_ROYH | New Mexico Royalty History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
37 | OIUH_RV_RPGH | Royalty Production Gas History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
38 | OIUH_RV_RPOH | Royalty Production Oil History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
39 | OIUH_RV_RTD | RD DOI Transferee Detail | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
40 | OIUH_RV_RVH | Rpoyalty Reporting Value History | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
41 | OIUH_RV_SCD | Obsolete (4.72)-keep for 1 minor release - Suspended Check | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
42 | OIUH_RV_SS | Contract Spot Sale | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
43 | OIUH_RV_STR | Severence Tax Rates | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
44 | OIUH_RV_STS | Severence Tax Subsidiary | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
45 | OIUH_RV_STXR | State Tax Rates | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
46 | OIUH_RV_TAXHA | New Mexico Tax History For Affiliated Txns | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
47 | OIUH_RV_TAXHN | New Mexico Tax History For Non-Affiliated Txns | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
48 | OIUH_RV_TCD | Tax Calc Data | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
49 | OIUH_RV_TD | Tax Detail | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
50 | OIUH_RV_TEP | Tax Extract Profile | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
51 | OIUH_RV_THDR | Tax Header | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
52 | OIUH_RV_TPPN | Tr PPN | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
53 | OIUH_RV_TR | Tract Information | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |
54 | OIUH_RV_TRP | Tax And Royalty Profile | 2 | DUMMY_SEQ_FIELD | OIUH_CHAR10 | nvarchar | 10 | 0 | | |