OIUREP_RT_HIST

MMS-2014 - Royalty Transaction (Pending) History | #transactional | Component: Royalty Reporting

🔑 Keys (5)
💰 Amounts (10)
∑ Quantities (12)
📅 Dates (1)
☰ Categorical (13)
Other (20)
🔗 Relations (36)

Column Name	Description
MANDT FK	Client
BUKRS FK	Company Code
SALES_YEAR	MMS-2014 - Year
SALES_MONTH	MMS-2014 - Month	Show values
RTP_LINE_NUM	MMS-2014 - Line Number

Column Name	Description
💲 Production: MMS-2014 - Sales Currency (SALES_CUR):
SALES_AMT	Production: MMS-2014 - 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
💲 Production: MMS-2014 - Deduction Reimbursement Currency (DED_REMB_CUR):
DED_REMB_AMT	Production: MMS-2014 - Deduction Reimbursement Amount
💲 Production: MMS-2014 - Tax Currency (TAX_CUR):
TAX_AMT	Production: MMS-2014 - Tax Amount
💲 Production: MMS-2014 - Tax Reimbursement Currency (TAX_REMB_CUR):
TAX_REMB_AMT	Production: MMS-2014 - Tax Reimbursement Amount
💲 MMS-2014 - JE Offset Currency (MMS_ROY_CUR):
MMS_ROY_AMT	MMS-2014 - JE Offset Amount
💲 Production: MMS-2014 - MMS Sales Currency (MMS_SA_CUR):
MMS_SA_AMT	Production: MMS-2014 - MMS Sales Amount

Column Name	Description
📏 Production: MMS-2014 - Sales Qty Unit (SALES_QY_U):
SALES_QY	Sales Quantity
📏 Production: MMS-2014 - Sales Gravity Qty Unit (SALES_GV_QY_U):
SALES_GV_QY	Production: MMS-2014 - Sales Gravity Qty
📏 Production: MMS-2014 - Sales BTU Qty Unit (SALES_BTU_QY_U):
SALES_BTU_QY	Production: MMS-2014 - Sales BTU Quantity
📏 Pressure Base Unit (SALES_PS_BASE_U):
SALES_PS_BASE_QY	Pressure Base
📏 Production: MMS-2014 - Royalty Quantity Unit (ROY_QY_U):
ROY_QY	Production: MMS-2014 - Royalty Quantity
📏 Production: MMS-2014 - MMS Royalty Quantity Unit (MMS_ROY_QY_U):
MMS_ROY_QY	Production: MMS-2014 - MMS Royalty Quantity
📏 Pressure Base Unit (MMS_PS_BASE_QY_U):
MMS_PS_BASE_QY	Pressure Base
📏 Production: MMS-2014 - MMS Sales Quantity Unit (MMS_SA_QY_U):
MMS_SA_QY	Production: MMS-2014 - MMS Sales Quantity
📏 Production: MMS-2014 - Adjusted Sales Quantity Unit (ADJ_SA_QY_U):
ADJ_SA_QY	Production: MMS-2014 - Adjusted Sales Quantity
📏 Production: MMS-2014 - Adjusted Royalty Quantity Unit (ADJ_ROY_QY_U):
ADJ_ROY_QY	Production: MMS-2014 - Adjusted Royalty Quantity
📏 Production: MMS-2014 - Adjusted BTU Quantity Unit (ADJ_BTU_QY_U):
ADJ_BTU_QY	Production: MMS-2014 - Adjusted BTU 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
PAY_METHOD_CD	Production: MMS-2014 - Payment Method Code	Show values
PU_AFFIL_FL	Production: MMS-2014 - Purchaser Affiliation Flag	Show values
ADJ_CD	Production: MMS-2014 - Adjustment Reason Code	Show values
HISTORY_FL	Production: MMS-2014 - History Flag	Show values
TRIBAL_ALLOT_CD	Production: MMS-2014 - Tribal/Allottee Code	Show values
COMP_ROY_FL	Production: MMS-2014 - Compensatory Royalty Flag	Show values
ROY_IN_KIND_FL	Production: MMS-2014 - Royalty In Kind Flag	Show values
EXTRACTED_FL	MMS-2014: Extracted	Show values
EXTRACT_RUN_TYPE	Defines whether the run is direct pay or not	Show values

Column Name	Description	Domain name
PAYOR_NO	Production: MMS-2014 - Payor
API_WELL_NO	API well number	OIU_WLAPI
API_WELL_CM_NO	API well completion number	OIU_API_WC_NO
PU_SEQ_NO	Purchasing Representative Interest Sequence No	OIU_PU_REP_ISQ_NO
OWN_ISQ_NO	Owner Interest Sequence Number	OIU_OWN_ISQ_NO
GL_ACCTID_NO	Account ID	CHAR10
NWK_NO	Network Number	OIUREP_MMS_2014_NWK_NO
SUB_NWK_NO	Sub Network Number	OIUREP_MMS_2014_SUB_NWK_NO
INT_TYPE_CD	Interest Type Code	OIUREP_MMS_2014_INT_TYPE_CD
INT_SEQ_NO	Interest Sequence Number	OIUREP_MMS_2014_INT_SEQ_NO
REPORT_PART_FAC	Production: MMS-2014 - Report Participation Factor
PAY_CD	Production: MMS-2014 - Payment Code
MANUAL_CREATE_FL	null
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
COST_CENTER	PRA Cost Center	OIUCM_KOSTL
VL_TYPE_CD	Volume Type Code	OIU_VL_TYPE_CD
ALT_CT_NO	ONRR MPP: Pricing Contract Number	VBELN

Master Data Relations	Join Conditions
Production: MMS-2014 - Adjusted BTU Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.ADJ_BTU_QY_U == T006.MSEHI`
Production: MMS-2014 - Adjusted Royalty Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.ADJ_ROY_QY_U == T006.MSEHI`
Production: MMS-2014 - Adjusted Sales Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.ADJ_SA_QY_U == T006.MSEHI`
Production: MMS-2014 - Agreement Number ? Client MMS-2014 - Lease Number Production: MMS-2014 - Federal or Indian Code Production: MMS-2014 - Agreement Number	`OIUREP_RT_HIST.[column in domain "OIUREP_MMS_2014_AGREEMENT_NO"] == OIUREP_LEASE.AGREEMENT_NO` `OIUREP_RT_HIST.MANDT == OIUREP_LEASE.MANDT` `OIUREP_RT_HIST.LEASE_NO == OIUREP_LEASE.PAYORXREF_REC_NO` `OIUREP_RT_HIST.FED_INDIAN_CD == OIUREP_LEASE.LEASE_NO` `OIUREP_RT_HIST.AGREEMENT_NO == OIUREP_LEASE.FED_INDIAN_CD`
Company Code	`OIUREP_RT_HIST.MANDT == T001.MANDT` `OIUREP_RT_HIST.BUKRS == T001.BUKRS`
Contract Number	`OIUREP_RT_HIST.MANDT == OIUCM_CONTRACT.MANDT` `OIUREP_RT_HIST.CT_NO == OIUCM_CONTRACT.VBELN`
Production: MMS-2014 - Deduction Reimbursement Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.DED_REMB_CUR == TCURC.WAERS`
Division of interest (DOI) MMS-2014 - Venture Division of interest (DOI) Company Code	`OIUREP_RT_HIST.MANDT == OIU_DO_DI.MANDT` `OIUREP_RT_HIST.VNAME == OIU_DO_DI.VNAME` `OIUREP_RT_HIST.DOI_NO == OIU_DO_DI.DOI_NO` `OIUREP_RT_HIST.BUKRS == OIU_DO_DI.BUKRS`
Production: MMS-2014 - Gas MMBTU Qty Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.GAS_MMBTU_QY_U == T006.MSEHI`
MMS-2014 - Lease Number MMS-2014 - Lease Number Client	`OIUREP_RT_HIST.LEASE_NO == OIUREP_FEDINDIAN.LEASE_NO` `OIUREP_RT_HIST.MANDT == OIUREP_FEDINDIAN.MANDT`
Client	`OIUREP_RT_HIST.MANDT == T000.MANDT`
Material Number	`OIUREP_RT_HIST.MANDT == OIU_CM_MAT_PRCD.MANDT` `OIUREP_RT_HIST.MATNR == OIU_CM_MAT_PRCD.MATNR`
Pressure Base Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.MMS_PS_BASE_QY_U == T006.MSEHI`
MMS-2014 - JE Offset Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.MMS_ROY_CUR == TCURC.WAERS`
Production: MMS-2014 - MMS Royalty Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.MMS_ROY_QY_U == T006.MSEHI`
Production: MMS-2014 - MMS Sales Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.MMS_SA_CUR == TCURC.WAERS`
Production: MMS-2014 - MMS Sales Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.MMS_SA_QY_U == T006.MSEHI`
PRA owner	`OIUREP_RT_HIST.MANDT == LFA1.MANDT` `OIUREP_RT_HIST.OWN_NO == LFA1.LIFNR`
Production: MMS-2014 - Manufacturing UOM Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.PROC_ALW_DE_CUR == TCURC.WAERS`
Production: MMS-2014 - Royalty Value Less Allows Curr	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.ROY_LS_ALLOW_CUR == TCURC.WAERS`
Production: MMS-2014 - Royalty Value Prior to Allows. Curr	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.ROY_PR_ALW_CUR == TCURC.WAERS`
Production: MMS-2014 - Royalty Quantity Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.ROY_QY_U == T006.MSEHI`
Production: MMS-2014 - Sales BTU Qty Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.SALES_BTU_QY_U == T006.MSEHI`
Production: MMS-2014 - Sales Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.SALES_CUR == TCURC.WAERS`
Production: MMS-2014 - Sales Gravity Qty Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.SALES_GV_QY_U == T006.MSEHI`
Pressure Base Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.SALES_PS_BASE_U == T006.MSEHI`
Production: MMS-2014 - Sales Qty Unit	`OIUREP_RT_HIST.MANDT == T006.MANDT` `OIUREP_RT_HIST.SALES_QY_U == T006.MSEHI`
Production: MMS-2014 - Sales Type Code	`OIUREP_RT_HIST.MANDT == OIUREP_SALESTY.MANDT` `OIUREP_RT_HIST.SALES_TYPE_CD == OIUREP_SALESTY.SALES_TYPE_CD`
Suspense Reason Code	`OIUREP_RT_HIST.MANDT == OIU_CM_SUSP.MANDT` `OIUREP_RT_HIST.SUSPEND_RSN_CD == OIU_CM_SUSP.SUSP_CD`
Production: MMS-2014 - Tax Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.TAX_CUR == TCURC.WAERS`
Production: MMS-2014 - Tax Reimbursement Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.TAX_REMB_CUR == TCURC.WAERS`
MMS-2014 - Transportation Allowance Currency	`OIUREP_RT_HIST.MANDT == TCURC.MANDT` `OIUREP_RT_HIST.TRNSP_ALW_DE_CUR == TCURC.WAERS`
MMS-2014 - Venture MMS-2014 - Venture Company Code	`OIUREP_RT_HIST.MANDT == OIU_DO_JV.MANDT` `OIUREP_RT_HIST.VNAME == OIU_DO_JV.VNAME` `OIUREP_RT_HIST.BUKRS == OIU_DO_JV.BUKRS`
Well Completion Number Well ID number Well Completion Number	`OIUREP_RT_HIST.MANDT == OIU_PR_WC.MANDT` `OIUREP_RT_HIST.WL_NO == OIU_PR_WC.WL_NO` `OIUREP_RT_HIST.WC_NO == OIU_PR_WC.WC_NO`
Well ID number	`OIUREP_RT_HIST.MANDT == OIU_PR_WELL.MANDT` `OIUREP_RT_HIST.WL_NO == OIU_PR_WELL.WL_NO`

Other Relations \| to Master Data Relations ↑	Join Conditions
Production: MMS-2014 - Indian Tribe Number Production: MMS-2014 - Indian Tribe Number Client	`OIUREP_RT_HIST.INDIAN_TRIBE_NO == OIUREP_INDIAN_TR.INDIAN_TRIBE_NO` `OIUREP_RT_HIST.MANDT == OIUREP_INDIAN_TR.MANDT`