| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIUX1_ARCH_TAXH | Tax transaction header for reporting | 35 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
2 | OIUX2_PUID_TAXH | Tax transaction header for reporting | 35 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPRevenue |
3 | OIURV03_FRMHDR | Valuation Transaction Level 3 - Formula | 8 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
4 | OIURV03_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 13 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPTax Reporting |
5 | OIUX1_ADJ_TAXDC | Tax adjustments detail for reporting | 35 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
6 | OIUX1_PUID_TAXH | Tax transaction header for reporting | 35 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
7 | OIUX1_RPT_TAXH | Tax transaction header for reporting | 45 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
8 | OIUX1_TRN_TAXDC | Tax transaction detail for reporting | 35 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
9 | OIUX1_TRN_TAXDL | Tax transaction detail for reporting | 30 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
TOPValuation |
10 | OIURV_DOC_FRMHDR | Valuation Transaction Level 3 - Formula | 8 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
11 | OIURV_DOC_FRMMKT | Valuation Transactions Level 3 - Marketing Detail | 20 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
12 | OIURV_DOC_FRMTAX | Valuation Transactions Level 3 - Formula Tax Detail | 13 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
13 | OIUVL_GASDTL_CUR | Gas statement Detail | 20 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
14 | OIUVL_GASDTL_HST | Gas statement Detail | 20 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |
15 | OIUVL_SCAUDIT | Settlement statement batch | 31 | GR_VAL_CURR | Currency Key | nvarchar | 5 | 0 | | |