| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIU_PR_FRMH | Formula Rules Maintenance Header | 2 | FRML_NO | Formula number - Production | nvarchar | 8 | 0 | | |
2 | OIU_PR_MPAPD | Measure Point Allocation Profile Detail | 6 | FRML_NO | Formula number - Production | nvarchar | 8 | 0 | | |
3 | OIU_RV_FRML | Valuation Formula Id | 2 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
4 | OIU_RV_FRMLD | Valuation Formula Detail | 2 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
5 | OIU_RV_RVT | Rejected Valuation Transactions | 15 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
6 | OIU_RV_VCR | Valuation Cross Reference | 15 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
7 | OIU_RV_VLRPT | Valuation Reporting | 13 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
8 | OIU_RV_VLTXNS | Valuation Transactions | 18 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
9 | OIU_RV_VPPN | Valuation Prior Period Notification | 16 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
10 | OIU_RV_VPPNM | Manually Created Valuation Prior Period Notifications | 16 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
11 | OIU_RV_VPPNU | Valuation Prior Period Notification | 16 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
12 | OIU_RV_VXDS | Valuation Cross Reference Date Stamp | 13 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
TOPRevenue |
13 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 17 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
14 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 33 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
TOPValuation |
15 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 17 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
16 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 33 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |
17 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 16 | FRML_NO | Formula number | nvarchar | 8 | 0 | | |