| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPRoyalty Reporting |
| 1 | OIUREPP_PRPAYXRF | MMS-2014 - Property / Payor XRef PPA | 9 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 2 | OIUREPP_WCPAYXRF | MMS-2014 - Well Completion / Payor XRef PPA | 8 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 3 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 7 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 4 | OIUREP_MRT_HIST | MMS-2014 MMS Royalty Transaction Processed History | 5 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 5 | OIUREP_MRT_PEND | MMS-2014 MMS Royalty Transaction Processed - Pending | 5 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 6 | OIUREP_PAYOR | MMS-2014 - Payor / Company Code XRef | 2 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 7 | OIUREP_PRPAYXREF | MMS-2014 - Property / Payor XRef | 9 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 8 | OIUREP_RECOUP | MMS-2014 - Recoupable Balance | 2 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 9 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 6 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 10 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 6 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
| 11 | OIUREP_WCPAYXREF | MMS-2014 - Well Completion / Payor XRef | 8 | PAYOR_NO | Production: MMS-2014 - Payor | nvarchar | 5 | 0 | | |
