| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREP_ADJCD_XRF | MMS-2014 - Reversal Rsn to Adjustment Reason Code XREF | 3 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |
2 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 72 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |
3 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 17 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |
4 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 17 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |
5 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 71 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |
6 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 71 | ADJ_CD | Production: MMS-2014 - Adjustment Reason Code | nvarchar | 2 | 0 | | |