| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPRoyalty Reporting |
1 | OIUREPP_LEASE | MMS-2014 - Lease PPA | 14 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
2 | OIUREPP_OWNER | MMS-2014 - Owner PPA | 9 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
3 | OIUREP_LEASE | MMS-2014 - Lease | 14 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
4 | OIUREP_MMS_REJS | MMS-2014 - Extraction Rejects | 83 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
5 | OIUREP_OWNER | MMS-2014 - Owner | 9 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
6 | OIUREP_RTPEND | MMS-2014 - Royalty Transaction Pending | 82 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |
7 | OIUREP_RT_HIST | MMS-2014 - Royalty Transaction (Pending) History | 82 | TRIBAL_ALLOT_CD | Production: MMS-2014 - Tribal/Allottee Code | nvarchar | 1 | 0 | | |