| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCheck Input |
1 | OIUCI_CDEXD | CDEX Detail | 24 | REJ_RSN_CD | Reject reason | nvarchar | 3 | 0 | | |
2 | OIUCI_CDEXH | CDEX Header | 18 | REJ_RSN_CD | Reject reason | nvarchar | 3 | 0 | | |
3 | OIUCI_DOC_CIREJ | Contains VL/RD rejects to be reported to Check Input | 10 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
TOPProduction and Revenue Accounting |
4 | OIU_CM_REJCD | Reject Reason Code Table - TBLRV027 | 1 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
5 | OIU_CM_REJCD_TX | Reject Code Text - TBLRV027 | 2 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
6 | OIU_RV_RVT | Rejected Valuation Transactions | 16 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
7 | OIU_RV_VLRPT | Valuation Reporting | 19 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
TOPRevenue |
8 | OIURV03_DTL_BK | Valuation Transactions Level 1 - Vltxns | 33 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
9 | OIURV03_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 35 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
10 | OIURV03_VOLDTL | Valuation Transaction Level 2 -Volume | 84 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
TOPValuation |
11 | OIURV_DOC_DTL_BK | Valuation Transactions Level 1 - Vltxns | 33 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
12 | OIURV_DOC_DTL_RV | Valuation Reversal Notificaton | 19 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
13 | OIURV_DOC_DTL_ZE | Valuation Transactions Level 1 - Zero Volume | 35 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
14 | OIURV_DOC_VOLDTL | Valuation Transaction Level 2 -Volume | 84 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
15 | OIURV_SSTD | Settlement statement detail | 6 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
16 | OIUVL_PPN_REJSEL | PPN - Reject Selection | 5 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |
17 | OIUVL_SCREJ | screj | 6 | REJ_RSN_CD | Rejection Reason Code | nvarchar | 3 | 0 | | |