1. Home
  2. Resources
  3. SAP Tables
  4. OIUREP_LEASE - MMS-2014 - Lease

SAP Table OIUREP_LEASE

MMS-2014 - Lease

OIUREP_LEASE (MMS-2014 - Lease) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIUREP_LEASE to other SAP tables.

OIUREP_LEASE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PAYORXREF_REC_NO Production: MMS-2014 - Payor XRef Record Number OIUREP_MMS_2014_PAYOR_REC_NO NUMC 20 0
LEASE_NO MMS-2014 - Lease Number OIUREP_MMS_2014_LEASE_NO OIUREP_FEDINDIAN CHAR 11 0
FED_INDIAN_CD Production: MMS-2014 - Federal or Indian Code OIUREP_MMS_2014_FED_INDIAN_CD CHAR 1 0
F Federal
I Indian
AGREEMENT_NO Production: MMS-2014 - Agreement Number OIUREP_MMS_2014_AGREEMENT_NO CHAR 11 0
EFF_FROM_DT Effective from date OIU_EFF_FROM_DT DATS 8 0
EFF_TO_DT Effective To Date OIU_EFF_TO_DT DATS 8 0
LEASE_RECORD_NO Production: MMS-2014 - Lease Record Number OIUREP_MMS_2014_LEASE_REC_NO NUMC 20 0
ALLOCATION_FAC Production: MMS-2014 - Lease/Agreement Allocation Factor OIUREP_MMS_2014_ALLOCATION_FAC DEC 9 8
REPORT_PART_FAC Production: MMS-2014 - Report Participation Factor OIUREP_MMS_2014_RPT_PART_FAC DEC 9 8
PAY_METHOD_CD Production: MMS-2014 - Payment Method Code OIUREP_MMS_2014_PAY_METHOD_CD CHAR 1 0
1 Checks to MMS
2 Indian Direct Pay
3 EFT Payment
4 Royalty-In-Kind
5 Checks to MMS for BIA
6 Other (reserved for future use)
7 Indian Lockbox
COMP_ROYALTY_FL Production: MMS-2014 - Compensatory Royalty Flag OIUREP_MMS_2014_COMP_ROY_FL CHAR 1 0
X Yes
NULL No
INDIAN_TRIBE_NO Production: MMS-2014 - Indian Tribe Number OIUREP_MMS_2014_INDN_TRIBE_NO OIUREP_INDIAN_TR CHAR 2 0
TRIBAL_ALLOT_CD Production: MMS-2014 - Tribal/Allottee Code OIUREP_MMS_2014_TRIB_ALLOT_CD CHAR 1 0
T Tribal
A Allottee
REPORT_API_WELL MMS-2014: Report API Well Number OIUREP_MMS_2014_REPORT_API_NO CHAR 1 0
X Yes
NULL No
OIU_CRUSER Name of Person who Created the Object ERNAM CHAR 12 0
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0
CHANGE_USER Name of Person Who Changed Object AENAM CHAR 12 0
CHANGE_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0

OIUREP_LEASE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIUREP_LEASE INDIAN_TRIBE_NO SYST MANDT OIUREP_INDIAN_TR MMS-2014 - Indian Tribes MANDT
OIUREP_LEASE INDIAN_TRIBE_NO OIUREP_LEASE INDIAN_TRIBE_NO OIUREP_INDIAN_TR MMS-2014 - Indian Tribes INDIAN_TRIBE_NO
OIUREP_LEASE LEASE_NO OIUREP_LEASE MANDT OIUREP_FEDINDIAN MMS-2014 - Federal or Indian Leases MANDT
OIUREP_LEASE LEASE_NO OIUREP_LEASE LEASE_NO OIUREP_FEDINDIAN MMS-2014 - Federal or Indian Leases LEASE_NO
OIUREP_LEASE MANDT OIUREP_LEASE MANDT T000 Clients MANDT