| 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 | 33 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
2 | OIUREP_TIKBACKUP | Backup tik table for old tax reporting SOL | 30 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
3 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
4 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
TOPRevenue |
5 | OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula | 9 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
TOPTax Reporting |
6 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
7 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
8 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 37 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
9 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
10 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 22 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
TOPValuation |
11 | OIURV_CRH_HST | Combined Run Header History | 22 | ACTL_GR_VAL_AM | Local amount | decimal | 11 | 2 | | |
12 | OIURV_DOC_CRH | Oil and Gas appl table | 18 | ACTL_GR_VAL_AM | Local amount | decimal | 11 | 2 | | |
13 | OIURV_DOC_FRMHDR | Valuation Transaction Level 3 - Formula | 9 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
14 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 69 | ACTL_GR_VAL_AM | JE Transaction Quantity | decimal | 11 | 2 | | |
15 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 16 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
16 | OIUVL_GASDTL_CUR | Gas statement Detail | 18 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
17 | OIUVL_GASDTL_HST | Gas statement Detail | 18 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
18 | OIUVL_GASRPTD | Gas statement report detail | 20 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |
19 | OIUVL_SEV | Severance tax | 27 | ACTL_GR_VAL_AM | Actual Gross Value Amount | decimal | 13 | 2 | | |