SAP ABAP Table ROIUREP_CO_FORM7_DETAIL (Regulatory Reporting Colorado Form 7 Detail)

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_CO_FORM7_DETAIL	Table Relationship Diagram
Short Description	Regulatory Reporting Colorado Form 7 Detail

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	FORM_NAME	☐			CHAR	2	0
5	PROD_MONTH	☐	OIU_REPMONTH	AM_MONAT	NUMC	2	0	Reporting Month
6	PROD_YEAR	☐	OIU_REPYEAR	GJAHR	NUMC	4	0	Reporting Year
7	OPER_NBR	☐	OIUREP_CO_OPER_NBR		NUMC	6	0	Reg.Reporting OGCC Operator Number
8	OPER_NBRB	☐	OIUREP_CO_OPER_NBRB		CHAR	1	0	Reg.Reporting OGCC Operator Number Suffix
9	OPERATOR_NAME	☐	OIUREP_CO_OPERATOR		CHAR	50	0	Reg.Reporting - Operator Name
10	ADDRESS	☐	OIUREP_CO_ADDRESS		CHAR	50	0	Reg.Reporting - Colorado Address
11	CITY	☐	OIUREP_CO_CITY		CHAR	30	0	Reg.Reporting - Colorado city
12	STATE	☐	OIUREP_CO_STATE		CHAR	2	0	Reg.Reporting - State (used in Colorado Form 7)
13	ZIP	☐	OIUREP_CO_ZIP		CHAR	10	0	Reg.Reporting - Colorado ZIP (format 99999-9999)
14	PHONEAC	☐	OIUREP_PHONEAC		NUMC	3	0	Reg.Reporting - Phone Area Code
15	PHONENBR	☐	OIUREP_PHONENBR		CHAR	8	0	Reg.Reporting - Phone Number (format 999-9999)
16	FAXAC	☐	OIUREP_FAXAC		NUMC	3	0	Reg.Reporting - Colorado Fax Area Code
17	FAXNBR	☐	OIUREP_FAXNBR		CHAR	8	0	Reg.Reporting - Fax Number (format 999-9999)
18	REVISED	☐	OIUREP_CO_REVISED		CHAR	1	0	Reg.Reporting - Revised Flag
19	API_CTY	☐	OIUREP_API_CTY		CHAR	3	0	Reg.Reporting - API Cty
20	API_SEQ	☐	OIUREP_API_SEQ		CHAR	5	0	Reg.Reporting - API Sequence
21	API_SIDT	☐	OIUREP_API_SIDT		CHAR	2	0	Reg.Reporting - API Side Track
22	WL_NAME_NBR	☐	OIUREP_CO_WL_NAME_NBR		CHAR	25	0	Reg.Reporting - Colorado Well Number
23	FORM_CD	☐	OIUREP_CO_FORM_CD		CHAR	5	0	Reg.Reporting - CO Formation Code
24	WELL_STAT	☐	OIUREP_WELL_STAT	OIUREP_WELL_STAT	CHAR	2	0	MMS Well Status Code (OGOR-A)
25	DAYS_PROD	☐	OIUREP_OGA_DAYS_PROD		NUMC	2	0	Days Produced
26	QQ	☐	OIUREP_CO_QQ		CHAR	5	0	Reg.Reporting - CO Quarter
27	SEC	☐	OIUREP_CO_SEC		CHAR	2	0	Reg.Reporting - CO Section
28	TWP	☐	OIUREP_CO_TWP		CHAR	6	0	Reg.Reporting - CO Township
29	RNG	☐	OIUREP_CO_RNG		CHAR	6	0	Reg.Reporting - CO Rng
30	BEG_INV	☐	OIUREP_CO_BEG_INV_VOL		DEC	9	0	Reg.Reporting - CO Beginning Inventory Volume
31	OIL_PROD	☐	OIUREP_OGA_PROD_VOL_OILCOND		DEC	9	0	Production Volume Oil/Conensate
32	OIL_SOLD	☐	OIUREP_CO_OIL_SOLD		DEC	9	0	Reg.Reporting - CO Oil volume sold
33	OIL_ADJ	☐	OIUREP_CO_OIL_ADJ		DEC	9	0	Reg.Reporting - CO Oil volume adjusted
34	END_INV	☐	OIUREP_OGC_END_INV_VOL	OIUREP_QUAN_10_WITH_SIGN	DEC	8	0	OGOR-C Ending Inventory Volume
35	GAS_PROD	☐	OIUREP_OGA_PROD_VOL_GAS		DEC	9	0	OGOR-A Production Volume Gas
36	GAS_FLARED	☐	OIUREP_CO_GAS_FLARED		DEC	9	0	Reg.Reporting - CO Gas Volume flared
37	GAS_USED	☐	OIUREP_CO_GAS_USED		DEC	9	0	Reg.Reporting - CO Gas Volume used
38	GAS_SHRINK	☐	OIUREP_CO_GAS_SHRINK		DEC	9	0	Reg.Reporting - CO Gas shrinkage volume
39	GAS_SOLD	☐	OIUREP_CO_GAS_SOLD		DEC	9	0	Reg.Reporting - CO Gas volume sold
40	OIL_GRAV	☐	OIUREP_CO_OIL_GRAV		DEC	4	1	Oil API Gravity
41	GAS_BTU	☐	OIUREP_CO_GAS_BTU		DEC	4	0	Gas BTU
42	WATER_PROD	☐	OIUREP_OGA_PROD_VOL_WATER		DEC	9	0	OGOR-A Production Volume Water
43	WATER_DISP_CD	☐	OIUREP_CO_WATER_DISP_CD		CHAR	1	0	Reg.Reporting - CO Water Disposition Code
44	WATER_TBG_PRES	☐	OIUREP_CO_WATER_TBG_PRES		DEC	9	0	Reg.Reporting - CO Water Tubing Pressure
45	WATER_CSG_PRES	☐	OIUREP_CO_WATER_CSG_PRES		DEC	9	0	Reg.Reporting - CO Water Casinghead Pressure
46	GAS_TBG_PRES	☐	OIUREP_CO_GAS_TBG_PRES		DEC	9	0	Reg.Reporting - CO Gas Tubing Pressure
47	GAS_CSG_PRES	☐	OIUREP_CO_GAS_CSG_PRES		DEC	9	0	Reg.Reporting - CO Gas Casinghead Pressure
48	PRINT_NAME	☐	OIUREP_PRINT_NAME		CHAR	25	0	Regulatory Reoprting: Print name
49	SIGNED	☐	OIUREP_SIGNED		CHAR	1	0	Regulatory Reoprting: Signed
50	TITLE	☐	OIUREP_TITLE		CHAR	25	0	Regulatory Reoprting: Title
51	SIGNED_DATE	☐	OIUREP_DATE_MMDDYYYY		CHAR	10	0	Regulatory Reoprting: Date in format MM/DD/YYYY

History

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