| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREPP_LEASE | MMS-2014 - Lease PPA | 2 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |
2 | OIUREPP_PRPAYXRF | MMS-2014 - Property / Payor XRef PPA | 8 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |
3 | OIUREPP_WCPAYXRF | MMS-2014 - Well Completion / Payor XRef PPA | 7 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |
4 | OIUREP_LEASE | MMS-2014 - Lease | 2 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |
5 | OIUREP_PRPAYXREF | MMS-2014 - Property / Payor XRef | 8 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |
6 | OIUREP_WCPAYXREF | MMS-2014 - Well Completion / Payor XRef | 7 | PAYORXREF_REC_NO | Production: MMS-2014 - Payor XRef Record Number | nvarchar | 20 | 0 | | |