| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREPP_LEASE | MMS-2014 - Lease PPA | 11 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
2 | OIUREPP_OWNER | MMS-2014 - Owner PPA | 6 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
3 | OIUREP_LEASE | MMS-2014 - Lease | 11 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
4 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 18 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
5 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 32 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
6 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 32 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
7 | OIUREP_OWNER | MMS-2014 - Owner | 6 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
8 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 17 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |
9 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 17 | PAY_METHOD_CD | Production: MMS-2014 - Payment Method Code | nvarchar | 1 | 0 | | |