SAP ABAP Table ROIUREP_OCC_1004_DTL (Regulatory Reporting - OCC Detail (Report Layout))

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUREP_OCC_1004_DTL	Table Relationship Diagram
Short Description	Regulatory Reporting - OCC Detail (Report Layout)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Regulatory Reporting: History Detail Keys
2	HEAD_SEQNR	☐	OIUREP_HEAD_SEQNR		NUMC	5	0	Regulatory Reporting Header Sequence Number
3	REC_TYPE	☐	OIUREP_OGR_REC_TYPE		CHAR	2	0	Detail Layout Record Type
4	FILLER_1	☐			CHAR	3	0
5	OCC_COUNTY_NO	☐	OIUREP_API_CTY		CHAR	3	0	Reg.Reporting - API Cty
6	OCC_PREFIX	☐	OIUREP_OCC_ALL_PRE		CHAR	2	0	Regulatory reporting - Oklahoma OCC prefix
7	OCC_ALLOW_NO	☐	OIUREP_OCC_ALL_NO		CHAR	6	0	Regulatory reporting - Oklahoma OCC Allowable No.
8	OCC_ALLOW_NO_SFX	☐	OIUREP_OCC_ALL_SUF	OIUREP_DIGITS	CHAR	1	0	Regulatory reporting - Oklahoma OCC allowable suffix
9	OCC_MERGE_NO	☐	OIUREP_OCC_MERGE_NO		NUMC	4	0	Regulatory reporting - Oklahoma OCC Merge Number
10	API_COUNTY_NO	☐	OIUREP_API_CTY		CHAR	3	0	Reg.Reporting - API Cty
11	API_WELL_NO	☐	OIUREP_API_SEQ		CHAR	5	0	Reg.Reporting - API Sequence
12	API_WELL_NO_SFX	☐	OIUREP_OCC_API_SFX	OIUREP_OCC_API_SFX	CHAR	1	0	Regulatory reporting - Oklahoma OCC API suffix number
13	OCC_OPERA_NO	☐	OIUREP_OCC_OPERA_NO		CHAR	5	0	Regulatory Reporting -OCC Operator Number
14	OCC_OPERA_NO_SFX	☐	OIUREP_OCC_OPERA_NO_SFX		CHAR	1	0	Regulatory Reporting - OCC Operator Number Suffix
15	PROD_CD	☐	OIUREP_NM_C115_PROD_CD		CHAR	1	0	Product Code
16	PROD_YEAR	☐	OIU_REPYEAR	GJAHR	NUMC	4	0	Reporting Year
17	PROD_MONTH	☐	OIU_REPMONTH	AM_MONAT	NUMC	2	0	Reporting Month
18	PROD_GAS_AMOUNT	☐	OIUREP_NM_C115_PROD_GAS		DEC	7	0	Production Volume Gas
19	OUTPUT_INDICATOR	☐	OIUREP_OCC_OUTPUT_INDICATOR		CHAR	1	0	Regulatotry Reporting - OCC Output Indicator
20	OPER_LSE_NO	☐	OIUREP_OCC_OPER_LSE_NO		CHAR	10	0	Operator Lease Number (internal id)
21	ALLOW_CLASS	☐	OIUREP_OCC_ALLOW_CLASS		CHAR	2	0	Regulatory Reporting - OCC Allowable Class
22	POOL_NO	☐	OIUREP_OCC_POOL_CD		CHAR	5	0	Regulatory reporting - Oklahoma OCC Pool Code
23	UNIT_WELL_NAME	☐	OIUREP_OCC_WELL_NM		CHAR	20	0	Regulatory Reporting - OCC Unit/Well name
24	WELL_NO	☐	OIUREP_AGY_WELL_ID		CHAR	6	0	Agency well ID
25	FORMATION_NAME	☐	OIUREP_OCC_FORMATION		CHAR	20	0	Regulatory Reporting - OCC Formation Name
26	FILLER_2	☐			CHAR	32	0
27	OCC_SECTION	☐	OIUREP_CO_SEC		CHAR	2	0	Reg.Reporting - CO Section
28	OCC_TOWNSHIP	☐	OIU_TWP_NO	CHAR3	CHAR	3	0	Township number
29	OCC_RANGE	☐	OIU_RNG_NO	CHAR3	CHAR	3	0	Range number
30	CIMARRON_MERIDIAN	☐	OIUREP_OCC_CM		CHAR	2	0	Regulatory Reporting - OCC Cimmarron Meridian
31	WC_NO	☐	OIUREP_WC_NO	CHAR2	CHAR	2	0	Well Completion No.

History

Last changed by/on	SAP	20050301
SAP Release Created in	46C