| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPProduction and Revenue Accounting |
1 | OIU_DO_DP | DOI Accounting Information | 24 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
2 | OIU_RV_VLDP | Valuation Division Order Prior Period Process | 10 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
3 | OIU_RV_VLTXNS | Valuation Transactions | 23 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
TOPRevenue |
4 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 23 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
5 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 37 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
TOPValuation |
6 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 23 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
7 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 37 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |
8 | OIURV_DOC_RDSUM | RD summary(VL interface records to RD) | 337 | DOI_SUM_FL | OIUH_CHAR1 | nvarchar | 1 | 0 | | |
9 | OIUVL_SCAUDIT | Settlement statement batch | 19 | DOI_SUM_FL | Summarize RD to DOI Level Flag | nvarchar | 1 | 0 | | |