OIUH_RV_ROYH - New Mexico Royalty History

New Mexico Royalty History information is stored in SAP table OIUH_RV_ROYH.
It is part of development package OIU_H in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "PRA Hybrid Solution".

Fields for table OIUH_RV_ROYH

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DUMMY_SEQ_FIELD	OIUH_CHAR10	X	OIUH_CHAR10	CHAR	20
ROYH_SYS_NO	OIUH_DEC18		OIUH_DEC18	DEC	10
OYH_OR_LVL_1_NO	OIUH_CHAR3		OIUH_CHAR3	CHAR	6
ROYH_MP_NO9	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_MP_NO	OIUH_CHAR6		OIUH_CHAR6	CHAR	12
ROYH_WL_NO9	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_WL_NO	OIUH_CHAR6		OIUH_CHAR6	CHAR	12
ROYH_WC_NO9	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_WC_NO	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
ROYH_PR_NO9	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_PR_NO	OIUH_CHAR8		OIUH_CHAR8	CHAR	16
ROYH_DOI_NO9	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_DOI_NO	OIUH_CHAR5		OIUH_CHAR5	CHAR	10
ROYH_MAJ_PD_CD	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_PD_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
ROYH_NM_PD_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
ROYH_SA_DT	OIUH_CHAR14		OIUH_CHAR14	CHAR	28
ROYH_CT_NO	Contract ID		OIUH_CONTRACT_ID	CHAR	12
ROYH_ST_RPT_NO	OIUH_CHAR13		OIUH_CHAR13	CHAR	26
OYH_NM_OGRID_NO	OIUH_CHAR6		OIUH_CHAR6	CHAR	12
ROYH_TXN_CD	OIUH_CHAR2		OIUH_CHAR2	CHAR	4
ROYH_NO_PU_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_PPA_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_RVRS_FL	OIUH_CHAR1		OIUH_CHAR1	CHAR	2
ROYH_TRANS_AM	Local amount		OIUH_CURR11_2	CURR	6
ROYH_GRVA_AM	Local amount		OIUH_CURR11_2	CURR	6
ROYH_NGL_GR_QY	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
ROYH_MCF_GR_QY	OIUH_DEC11_2		OIUH_DEC11_2	DEC	6
YH_TRANS_DED_AM	Local amount		OIUH_CURR11_2	CURR	6
OYH_PRCS_DED_AM	Local amount		OIUH_CURR11_2	CURR	6
ROYH_AVG_BTU_QY	OIUH_DEC7_3		OIUH_DEC7_3	DEC	4
ROYH_BTU_QY	OIUH_DEC7_3		OIUH_DEC7_3	DEC	4
YH_OBAL_DECM_QY	OIUH_DEC9_8		OIUH_DEC9_8	DEC	5
ROYH_VER_NO	OIUH_DEC5		OIUH_DEC5	DEC	3
ROYH_USER_ID	OIUH_CHAR8		OIUH_CHAR8	CHAR	16
ROYH_TIMESTAMP	OIUH_CHAR14		OIUH_CHAR14	CHAR	28