| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIU_RV_VLTXNS | Valuation Transactions | 19 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
TOPRevenue |
2 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 19 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
3 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 24 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
4 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 18 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
TOPValuation |
5 | OIURV_CRH_HST | Combined Run Header History | 18 | LVL_CD | OIUH_CHAR2 | nvarchar | 2 | 0 | | |
6 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 19 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
7 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 24 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
8 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 23 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
9 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 18 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |
10 | OIURV_DOC_VOLUNT | Valuation Document Concept - Volume Unit | 13 | LVL_CD | Level Code | nvarchar | 2 | 0 | | |