OIUREPP_LEASE

MMS-2014 - Lease PPA | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
PAYORXREF_REC_NO Production: MMS-2014 - Payor XRef Record Number
LEASE_NO FK MMS-2014 - Lease Number
FED_INDIAN_CD Production: MMS-2014 - Federal or Indian Code Show values
AGREEMENT_NO FK Production: MMS-2014 - Agreement Number
EFF_FROM_DT Effective from date
Column Name Description
Column Name Description
Column Name Description
EFF_FROM_DT Effective from date
EFF_TO_DT Effective To Date
Column Name Description
FED_INDIAN_CD Production: MMS-2014 - Federal or Indian Code Show values
PAY_METHOD_CD Production: MMS-2014 - Payment Method Code Show values
COMP_ROYALTY_FL Production: MMS-2014 - Compensatory Royalty Flag Show values
TRIBAL_ALLOT_CD Production: MMS-2014 - Tribal/Allottee Code Show values
REPORT_API_WELL MMS-2014: Report API Well Number Show values
Column Name Description Domain name
LEASE_RECORD_NO Production: MMS-2014 - Lease Record Number
ALLOCATION_FAC Production: MMS-2014 - Lease/Agreement Allocation Factor
REPORT_PART_FAC Production: MMS-2014 - Report Participation Factor
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
CHANGE_USER Name of Person Who Changed Object USNAM
CHANGE_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Production: MMS-2014 - Agreement Number
  • Effective from date
  • Production: MMS-2014 - Payor XRef Record Number
  • MMS-2014 - Lease Number
  • Production: MMS-2014 - Federal or Indian Code
  • Production: MMS-2014 - Agreement Number
MMS-2014 - Lease Number
  • MMS-2014 - Lease Number
  • Client
Client OIUREPP_LEASE.MANDT == T000.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Production: MMS-2014 - Indian Tribe Number
  • Production: MMS-2014 - Indian Tribe Number
  • Client