| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREPP_LEASE | MMS-2014 - Lease PPA | 5 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
2 | OIUREP_LEASE | MMS-2014 - Lease | 5 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
3 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 13 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
4 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 11 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
5 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 11 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
6 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 12 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |
7 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 12 | AGREEMENT_NO | Production: MMS-2014 - Agreement Number | nvarchar | 11 | 0 | | |