| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRevenue |
1 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 39 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
2 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 12 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
TOPValuation |
3 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 39 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
4 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 51 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
5 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 12 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
6 | OIUVL_SCAUDIT | Settlement statement batch | 13 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
7 | OIUVL_SEV | Severance tax | 34 | SYSTEM_SRCE_CD | Valuation Transaction Source Code | nvarchar | 2 | 0 | | |
8 | OIUVL_SSTH | Settlement statement header | 12 | SYSTEM_SRCE_CD | Originating PRA application area | nvarchar | 2 | 0 | | |