OIUREP_MASTER - Regulatory Reporting Master Data

Regulatory Reporting Master Data information is stored in SAP table OIUREP_MASTER.
It is part of development package OIU_REP in software component IS-OIL-PRA-REP-ROY. This development package consists of objects that can be grouped under "Production, Tax & Royalty Reporting".

Fields for table OIUREP_MASTER

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		ROIUREP_MASTERKEY	0
.INCLUDE		X		ROIUREP_REPORTKEY	0
MANDT	Client	X	MANDT	CLNT	6	T000
AGENCY	Agency for Reporting	X	OIUREP_AGENCY	CHAR	6	OIUREP_REPORTS
REP_NAME	Regulatory Report Name	X	OIU_REP_REPNAME	CHAR	80	OIUREP_REPORTS
WL_NO	Well ID number	X	OIU_WL_NO	CHAR	30	OIU_PR_WELL
WC_NO	Well Completion Number	X	OIU_WC_NO	CHAR	10	OIU_PR_WC
EFF_FROM_DT	Effective from date	X	OIU_EFF_FROM_DT	DATS	16
.INCLUDE				ROIU_REP_MASTERGEN	0
EFF_TO_DT	Effective To Date		OIU_EFF_TO_DT	DATS	16
EFF_TO_CD	Checkbox		XFELD	CHAR	2
TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
USERID	User Name		SYUNAME	CHAR	24
.INCLUDE				ROIU_REP_MASTERTX	0
DIST_NO	District number for Texas Reg ID		OIU_REP_DIST_NO	CHAR	6
GAS_WL_NO	Regulatory Reporting: Gas Well Number		OIUREP_GAS_WL_NO	CHAR	12
CMGL_PRMT_NO	Commingled Permit Number		OIUREP_CMGL_PRMT_NO	CHAR	16
RPT_CD	Texas Report Code		OIUREP_RPT_CD	CHAR	2
RRC_GAS_WL_NO	Texas Railroad Commission Gas Well number		OIUREP_RRCGAS_WL_NO	CHAR	32
RRC_OIL_NO	Reg Reporting - TX H-10 Lease Number		OIUREP_TX_LEASE_NO	CHAR	10
RRC_SP_DSC_TX	30 Characters		CHAR30	CHAR	60
UNITZ_FLG	Checkbox		XFELD	CHAR	2
GAS_RRC_ID_NO	Regulatory Reporting: Gas RRC ID		OIUREP_TX_GAS_RRC_ID_NO	NUMC	12
P1B_RRC_OIL_LSE	Texas P-1B RRC Oil Lease		OIUREP_TX_P1B_RRC_OIL_LSE	NUMC	10
PARTIALLY_UNTZ	Texas P-1B Partially Unitized		OIUREP_TX_PARTIALLY_UNITIZED	CHAR	2
SPECIAL_PROJECT	Texas P-1B Special Project		OIUREP_TX_SPECIAL_PROJECT	CHAR	12
DRILL_PRMT_NO	Regulatory Reporting: Texas Drilling Permit Number		OIUREP_TX_DRILL_PERMIT	CHAR	12
OPER_LSE_NO	Operator Lease Number (internal id)		OIUREP_OPER_LSE_NO	CHAR	40
LSE_NO	Lease Number (Externally-Issued ID)		OIUREP_LSE_NO	CHAR	22
AGY_LSE_NO	Agency Lease Number (externally issued id)		OIUREP_AGY_LSE_NO	CHAR	50
MMS_ACT_CD	MMS Well Status Action Code (OGOR-A)		OIUREP_MMS_ACTION_CD	CHAR	2
MMS_GRP_API_WL	API well number group		OIUREP_WLAPI_GRP	CHAR	24
MMS_GRP_API_WC	API well completion number group		OIUREP_API_WC_NO_GRP	CHAR	6
OPER_WELL_NO	OGOR-A Operator Well Number		OIUREP_OGA_OPER_WELL_NO	CHAR	30
MMS_WELL_STAT	MMS Well Status Code (OGOR-A)		OIUREP_WELL_STAT	CHAR	4
MMS_REAS_CD	MMS Well Status Reason Code (OGOR-A)		OIUREP_MMS_REAS_CD	CHAR	4
.INCLUDE				ROIU_REP_MASTERNM	0
OP_WL_NO	Operator Well number (9-Character, NM)		OIU_REP_OP_WL_NO	CHAR	18
NM_POOL_CD	Pool Code (Reg ID)		OIUREP_NM_POOL	CHAR	12
NM_ST_PR_NO	NM State Property Number		OIUREP_PR_NO	NUMC	12
UNIT_NO	Unit No (NM Reg ID)		OIUREP_UNIT_NO	CHAR	2
OGRID_NO	OGRID number		OIUREP_OGRID_NO	NUMC	12
H2O_POD_NO	Reg.Reporting New Mexico - H2O POD Code		OIUREP_NM_H2O_POD_CD	CHAR	14
CA_H2O_SRCE_CD	Regulatory Rep: California H2O Source Code		OIUREP_CA_H2O_SRCE_CD	CHAR	2
CA_H2O_DISP_CD	Regulatory Rep: California H2O Disposition Code		OIUREP_CA_H2O_DISP_CD	CHAR	2
FIELD_NO	Reg. ID specific field number - override		OIUREP_FIELD_NO	CHAR	16
UNIT_NUMBER	Unit Number (WY Form 2)		OIUREP_UNIT_NUM	CHAR	22
INJ_SRCE_CD	Injection Source		OIUREP_INJ_SRCE_CD	CHAR	2
ALLOW_QTY	Daily production allowable quantity		OIUREP_ALLOW_QTY	QUAN	7
ALLOW_UOM	Unit of measure of production allowable		OIUREP_ALLOW_UOM	UNIT	6
AGY_WELL_ID	Agency well ID		OIUREP_AGY_WELL_ID	CHAR	12
START_CUM_ALLOW	Starting cummulative over/under allowance		OIUREP_START_CUM_ALLOW	QUAN	7
.INCLUDE				ROIU_REP_MASTERND	0
ND_WELL_NAME	Well Description		OIU_WL_DE_CONV	CHAR	70
ND_WELL_NO	Well ID number		OIU_WL_NO	CHAR	30
ND_WL_FILE_NO	Regulatory Reporting - North Dakota Well File Number		OIUREP_ND_WELL_FILE_NO	CHAR	12
UIC_NO	Reg. Reporting - ND Undergound Injection Control Number		OIUREP_ND_UIC_NO	CHAR	22
ST_RESVR_CD	Regulatory Reporting: Wyoming Form 2 Reservoir Code		OIUREP_WY_RESERVOIR_CD	CHAR	8
RESVR_CD	Regulatory Reporting: Wyoming Form 2 Reservoir Code		OIUREP_WY_RESERVOIR_CD	CHAR	8
PROJ_CD	Regulatory Reporting: Wyoming Form 2 Project Code		OIUREP_WY_PROJECT_CD	CHAR	6
CONS_DIST_NO	Regulatory Reporting - Conservation District Number		OIUREP_CONS_DIST_NO	CHAR	8
AREA_CD	Regulatory Reporting - Area Code		OIUREP_AREA_CD	CHAR	2
WL_SERIAL_NO	Well Serial Number		OIUREP_WL_SER_NO	CHAR	12
COMNG_FAC_NO	Regulatory Reporting - Commingling Facility Number		OIUREP_COMM_FAC_NO	CHAR	12
LUW_NO	Regulatory Reporting - Lease Unit / Well No		OIUREP_LUW_NO	CHAR	12
INAC_STATUS_CD	Inactive Status Code		OIUREP_INAC_STATUS_CD	CHAR	4
INAC_FUTURE_CD	Inactive Future Code		OIUREP_INAC_FUTURE_CD	CHAR	8
INAC_ABANDON	Inactive Abandon Date		OIUREP_INAC_ABANDON	DATS	16
SPLIT_GUID	GUID in 'CHAR' Format in Uppercase		GUID_32	CHAR	64
INACTIVE_FLAG	Report on inactive well report only		OIUREP_INACTIVE_FLAG	CHAR	2
OVERRIDE_GRP	Override Group		OIUREP_OVERRIDE_GRP	CHAR	10
ND_PIPE_OR_TRUCK	Regulatory Reporting - North Dakota Pipeline or Truck		OIUREP_ND_PIPE_OR_TRUCK	CHAR	2
ND_CTB_NO	Regulatory Reporting - North Dakorta Central Tank Battery		OIUREP_ND_CTB_NO	CHAR	22
FLPT_CD	Regulatory Reporting - Field Plant Code		OIUREP_FLPT_CD	CHAR	8
OIU_PRI_GEO_LOC	Primary geographical location (PRI geo. loc.)		OIU_PRI_GEO_LOC	CHAR	4
.INCLUDE				ROIUREP_MASTER_GEN_DIS	0
ADD_HDR1	Additional Master Data-Header Data		OIU_HDR_DATA	CHAR	70
ADD_HDR2	Additional Master Data-Header Data		OIU_HDR_DATA	CHAR	70
ADD_DTL1	Additional Master Data		OIU_ADD_DATA2	CHAR	30
ADD_DTL2	Additional Master Data		OIU_ADD_DATA3	CHAR	60
ADD_DTL3	Additional Master Data		OIU_ADD_DATA2	CHAR	30
ADD_DTL4	Additional Master Data		OIU_ADD_DATA3	CHAR	60
ADD_DTL5	Additional Master Data		OIU_ADD_DATA1	CHAR	20
ADD_DTL6	Additional Master Data		OIU_ADD_DATA1	CHAR	20
ADD_DTL7	Additional Master Data		OIU_ADD_DATA1	CHAR	20
ADD_DTL8	Additional Master Data		OIU_ADD_DATA1	CHAR	20
ADD_DTL9	Additional Master Data		OIU_ADD_DATA1	CHAR	20
ADD_DTL10	Additional Master Data		OIU_ADD_DATA1	CHAR	20
CA_WELL_DESIGNATION	CA : Well Designation Code		OIUREP_CA_WL_DESIGNATION	CHAR	90
CA_AREA_CD	CA: Area Code		OIUREP_CA_AREA_CD	CHAR	6
API_WL_OVERRIDE	CCO: API Well Override Group		OIUREP_API_WL_OVERRIDE	CHAR	24
.INCLU--AP				/PRA/S_CBM_OGOR_MASTER	0
CBM_INDICATOR	Coal Bed Methane Indicator		/PRA/CBM_INDICATOR	CHAR	2
.INCLU--AP				/PRA/S_PR_WELLC	0
API_SIDT	Reg.Reporting - API Side Track		OIUREP_API_SIDT	CHAR	4