| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUREP_TAXBACKUP | Backup tax table for old tax reporting SOL | 16 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
2 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 16 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
3 | OIU_RV_MULT_DN | Multiple DN for same well | 6 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
4 | OIU_RV_RVT | Rejected Valuation Transactions | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
5 | OIU_RV_VCRWI_NEW | Valuation Cross Reference Working Interest - New | 7 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
6 | OIU_RV_VLDP | Valuation Division Order Prior Period Process | 6 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
7 | OIU_RV_VLRPT | Valuation Reporting | 9 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
8 | OIU_RV_VLTXNS | Valuation Transactions | 13 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
9 | OIU_RV_VLXAS_NEW | Valuation Cross Reference Association - New | 14 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
TOPRevenue |
10 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 16 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
11 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 7 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
12 | OIURV03_MPWC_XRF | MP to Well Completion Split Out XRef | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
TOPTax Reporting |
13 | OIUX1_TRN_TAXHC | Tax transaction header for reporting | 8 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
14 | OIUX1_TRN_TAXHL | Tax transaction header for reporting | 8 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
15 | OIUX3_MIG_SA_DT | Tax Reporting - Migration Loaded Sales Dates | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
16 | OIUX3_MIG_VLDOC | Tax Reporting - Migration Loaded VL Docs | 5 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
TOPValuation |
17 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 16 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
18 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 7 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
19 | OIURV_DOC_HDR | Valuation Document Header | 6 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
20 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 26 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
21 | OIURV_SSTD | Settlement statement detail | 10 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
22 | OIUVL_GASDTL_CUR | Gas statement Detail | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
23 | OIUVL_GASDTL_HST | Gas statement Detail | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
24 | OIUVL_GASTAX_CUR | Gas Statement Tax Marketing | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
25 | OIUVL_GASTAX_HST | Gas Statement Tax Marketing | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
26 | OIUVL_OILTAX_CUR | Oil Run Statement Tax Marketing | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
27 | OIUVL_OILTAX_HST | Oil Run Statement Tax Marketing | 3 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
28 | OIUVL_OILTKT_CUR | Oil Ticket Detail | 4 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
29 | OIUVL_OILTKT_HST | Oil Ticket Current | 4 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
30 | OIUVL_RPT | Valuation reporting header | 4 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
31 | OIUVL_SCAUDIT | Settlement statement batch | 8 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
32 | OIUVL_SEV | Severance tax | 2 | SALE_DT | Sales Date / Month | nvarchar | 8 | 0 | | |
33 | OIUVL_TTRD | Tax Tier Rate - Data | 4 | SALE_DT | Sales date | nvarchar | 8 | 0 | | |
34 | OIUVL_TTRPD | Tax Tier Rate by Project - Data | 2 | SALE_DT | Sales date | nvarchar | 8 | 0 | | |