| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRevenue |
1 | OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula | 10 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |
TOPValuation |
2 | OIURV_CRH_HST | Combined Run Header History | 24 | ENTL_GR_VAL_AM | Local amount | decimal | 11 | 2 | | |
3 | OIURV_DOC_CRH | Oil and Gas appl table | 20 | ENTL_GR_VAL_AM | Local amount | decimal | 11 | 2 | | |
4 | OIURV_DOC_FRMHDR | Valuation Transaction Level 3 - Formula | 10 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |
5 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 70 | ENTL_GR_VAL_AM | JE Transaction Quantity | decimal | 11 | 2 | | |
6 | OIURV_DOC_RUNTKT | Valuation Transaction - Run Ticket | 17 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |
7 | OIUVL_GASDTL_CUR | Gas statement Detail | 19 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |
8 | OIUVL_GASDTL_HST | Gas statement Detail | 19 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |
9 | OIUVL_GASRPTD | Gas statement report detail | 21 | ENTL_GR_VAL_AM | Entitled Gross Value Amount | decimal | 13 | 2 | | |