OIUREP_MRT_HIST

MMS-2014 MMS Royalty Transaction Processed History | #transactional | Component: Royalty Reporting
Column Name Description
MANDT FK Client
DOC_ID Production: MMS-2104 - Document ID
DET_LINE_NO Line Number
Column Name Description
💲 Production: MMS-2014 - MMS Sales Currency (MMS_SA_CUR):
MMS_SA_AMT Production: MMS-2014 - MMS Sales Amount
💲 Production: MMS-2014 - Royalty Value Prior to Allows. Curr (ROY_PR_ALW_CUR):
ROY_PR_ALW_AMT Production: MMS-2014 - Royalty Value Prior to Allows. Amt
💲 MMS-2014 - Transportation Allowance Currency (TRNSP_ALW_DE_CUR):
TRNSP_ALW_DE_AMT Production: MMS-2014 - Transportation Allowance Amount
💲 Production: MMS-2014 - Manufacturing UOM Currency (PROC_ALW_DE_CUR):
PROC_ALW_DE_AMT Production: MMS-2014 - Manufacturing UOM Amount
💲 Production: MMS-2014 - Royalty Value Less Allows Curr (ROY_LS_ALLOW_CUR):
ROY_LS_ALLOW_AMT Production: MMS-2014 - Royalty Value Less Allows. Amt
Column Name Description
📏 Production: MMS-2014 - MMS Sales Quantity Unit (MMS_SA_QY_U):
MMS_SA_QY Production: MMS-2014 - MMS Sales Quantity
📏 Production: MMS-2014 - Gas MMBTU Qty Unit (GAS_MMBTU_QY_U):
GAS_MMBTU_QY Production: MMS-2014 - Gas MMBTU Qty
Column Name Description
SALES_DATE Sales Date / Month
Column Name Description
SALES_MONTH MMS-2014 - Month Show values
FED_INDIAN_CD Production: MMS-2014 - Federal or Indian Code Show values
MMS_PROD_CD Production: MMS Product Code Show values
TRANS_CD Production: MMS-2014 - Transaction Code Show values
ADJ_CD Production: MMS-2014 - Adjustment Reason Code Show values
PAY_METHOD_CD Production: MMS-2014 - Payment Method Code Show values
REVERSAL_FL Production: MMS-2014 - Reversal History Flag Show values
REVERSAL_MONTH MMS-2014 - Month Show values
Column Name Description Domain name
PAYOR_NO Production: MMS-2014 - Payor
SALES_YEAR MMS-2014 - Year
RESERV_SPACE Production: MMS-2104 - Reserve Space
API_WELL_NO API well number OIU_WLAPI
API_WELL_CM_NO API well completion number OIU_API_WC_NO
REVERSAL_YEAR MMS-2014 - Year
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Production: MMS-2014 - Agreement Number
  • ?
  • Client
  • MMS-2014 - Lease Number
  • Production: MMS-2014 - Federal or Indian Code
  • Production: MMS-2014 - Agreement Number
  • OIUREP_MRT_HIST.[column in domain "OIUREP_MMS_2014_AGREEMENT_NO"] == OIUREP_LEASE.AGREEMENT_NO
  • OIUREP_MRT_HIST.MANDT == OIUREP_LEASE.MANDT
  • OIUREP_MRT_HIST.LEASE_NO == OIUREP_LEASE.PAYORXREF_REC_NO
  • OIUREP_MRT_HIST.FED_INDIAN_CD == OIUREP_LEASE.LEASE_NO
  • OIUREP_MRT_HIST.AGREEMENT_NO == OIUREP_LEASE.FED_INDIAN_CD
Company Code
  • OIUREP_MRT_HIST.MANDT == T001.MANDT
  • OIUREP_MRT_HIST.BUKRS == T001.BUKRS
Production: MMS-2014 - Gas MMBTU Qty Unit
  • OIUREP_MRT_HIST.MANDT == T006.MANDT
  • OIUREP_MRT_HIST.GAS_MMBTU_QY_U == T006.MSEHI
MMS-2014 - Lease Number
  • MMS-2014 - Lease Number
  • Client
Client OIUREP_MRT_HIST.MANDT == T000.MANDT
Production: MMS-2014 - MMS Sales Currency
  • OIUREP_MRT_HIST.MANDT == TCURC.MANDT
  • OIUREP_MRT_HIST.MMS_SA_CUR == TCURC.WAERS
Production: MMS-2014 - MMS Sales Quantity Unit
  • OIUREP_MRT_HIST.MANDT == T006.MANDT
  • OIUREP_MRT_HIST.MMS_SA_QY_U == T006.MSEHI
Production: MMS-2014 - Manufacturing UOM Currency
  • OIUREP_MRT_HIST.MANDT == TCURC.MANDT
  • OIUREP_MRT_HIST.PROC_ALW_DE_CUR == TCURC.WAERS
Production: MMS-2014 - Royalty Value Less Allows Curr
  • OIUREP_MRT_HIST.MANDT == TCURC.MANDT
  • OIUREP_MRT_HIST.ROY_LS_ALLOW_CUR == TCURC.WAERS
Production: MMS-2014 - Royalty Value Prior to Allows. Curr
  • OIUREP_MRT_HIST.MANDT == TCURC.MANDT
  • OIUREP_MRT_HIST.ROY_PR_ALW_CUR == TCURC.WAERS
Production: MMS-2014 - Sales Type Code
MMS-2014 - Transportation Allowance Currency
  • OIUREP_MRT_HIST.MANDT == TCURC.MANDT
  • OIUREP_MRT_HIST.TRNSP_ALW_DE_CUR == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Production: MMS-2014 - Indian Tribe Number
  • Production: MMS-2014 - Indian Tribe Number
  • Client