SAP ABAP Table ROIUREP_TX_PR_DETAIL_EDI (Regulatory Repoting: Texas PR Detail Structure EDI)

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_TX_PR_DETAIL_EDI	Table Relationship Diagram
Short Description	Regulatory Repoting: Texas PR Detail Structure EDI

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	REC_UNIQUE	☐	ROIUREP_REC_UNIQUE		NUMC	20	0	Regulatory Reporting: Unique Record ID
2	OPER_NO	☐	ROIUREP_OPER_NO		STRU	0	0
3	VALUE_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
4	VALUE_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
5	VALUE_3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
6	VALUE_4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
7	VALUE_5	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
8	VALUE_6	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
9	DISTRICT_NO	☐	ROIUREP_DISTRICT_NO		STRU	0	0
10	VALUE_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
11	VALUE_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
12	LSE_TYPE	☐	OIUREP_LEASE_TYPE		CHAR	1	0	Regulatory Reoprting: Lease Type (Oil/Gas/Permit)
13	RRC_OIL_GAS_NO	☐	OIUREP_TX_OIL_GAS_NO		NUMC	6	0	Regulatory Reporting: Oil/Gas Id Number
14	DRILL_PRMT_NO	☐	OIUREP_TX_DRILL_PERMIT	OIUREP_TX_DRILL_PERMIT	CHAR	6	0	Regulatory Reporting: Texas Drilling Permit Number
15	API_NO	☐	OIUREP_TX_API_NO		CHAR	8	0	Regulatory Reporting: API Number
16	AC_INDICATOR	☐	OIU_REPCA_IND		CHAR	1	0	Current/Amended Report Indicator
17	LSE_TOT_ID	☐	OIUREP_TX_LSE_TOT_ID		CHAR	1	0	Regulatory Reporting: Lease Total Line Identicator
18	CMGL_PRMT_NO	☐	OIUREP_TX_CMGL_PERMIT		CHAR	5	0	Texas Commingled Permit Number
19	CMGL_PRMT_EXP	☐	OIUREP_CMGL_PRMT_EXPL		CHAR	50	0	Regulatory Reporting: Commingled Permit Number Remarks
20	PROD_YEAR	☐	ROIUREP_PROD_YEAR		STRU	0	0
21	VALUE_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
22	VALUE_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
23	VALUE_3	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
24	VALUE_4	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
25	PROD_MONTH	☐	ROIUREP_PROD_MONTH		STRU	0	0
26	VALUE_1	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
27	VALUE_2	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
28	GAS_PROD	☐	OIUREP_CH_GAS_PROD		NUMC	9	0	Regulatory Reporting: Gas Production
29	GAS_DISP_LSE	☐	OIUREP_CH_GAS_DISP_LSE		NUMC	9	0	Regulatory Reporting: Gas Disposition Lease Field Fuel Sys.
30	GAS_DISP_TRMN	☐	OIUREP_CH_GAS_DISP_TRMN		NUMC	9	0	Regulatory Reporting: Gas Disposition Transmission Line
31	GAS_DISP_PLANT	☐	OIUREP_CH_GAS_DISP_PLANT		NUMC	9	0	Regulatory Reporting: Gas Disposition Processing Plant
32	GAS_DISP_VENTED	☐	OIUREP_CH_GAS_DISP_VENTED		NUMC	9	0	Regulatory Reporting: Gas Disposition Vented or Flared
33	GAS_DISP_VENTED_EXP	☐	OIUREP_VENTED_EXPL		CHAR	20	0	Regulatory Reporting: Gas Vent/Flare Remar
34	GAS_DISP_LIFT	☐	OIUREP_CH_GAS_DISP_LIFT		NUMC	9	0	Regulatory Reporting: Gas Disposition Lift
35	GAS_DISP_PRESSURE	☐	OIUREP_CH_GAS_DISP_PRESSURE		NUMC	9	0	Regulatory Reporting: Gas Disposition Pressure maintenance
36	GAS_DISP_CARBON	☐	OIUREP_CH_GAS_DISP_CARBON		NUMC	9	0	Regulatory Reporting: Gas Disposition Carbon black
37	GAS_DISP_CARB_PLT_NM	☐	OIUREP_GAS_DISP_CARBON_PLT_NM		CHAR	50	0	Regulatory Reporting: Gas Dispostion Carbon Black Plant Name
38	GAS_DISP_UNDERGROUND	☐	OIUREP_CH_GAS_DISP_UNDERGROUND		NUMC	9	0	Regulatory Reporting: Gas Disposition Underground store
39	OIL_PROD	☐	OIUREP_OIL_PROD		NUMC	7	0	Regulatory Reporting: Oil Production
40	OIL_DISP_PIPELINE	☐	OIUREP_OIL_DISP_PIPELINE		NUMC	7	0	Regulatory Reporting: Oil Disposition Pipeline
41	OIL_DISP_TRUCK	☐	OIUREP_OIL_DISP_TRUCK		NUMC	7	0	Regulatory Reporting: Oil Disposition Truck
42	OIL_DISP_TANK	☐	OIUREP_OIL_DISP_TANK		NUMC	7	0	Regulatory Reporting: Oil Disposition Tank
43	OIL_DISP_NET_TANK	☐	OIUREP_OIL_DISP_NET_TANK		NUMC	7	0	Regulatory Reporting: Oil Disposition Net tank cleaning
44	OIL_DISP_NET_TANK_EXP	☐	OIUREP_NET_TANK_EXPL		CHAR	50	0	Regulatory Reporting: Oil Disposition Net Tank Remarks
45	OIL_DISP_CIRC	☐	OIUREP_OIL_DISP_CIRC		NUMC	7	0	Regulatory Reporting: Oil Disposition Circulating
46	OIL_DISP_CIRC_EXP	☐	OIUREP_CIRC_EXPL		CHAR	50	0	Regulatory Reporting: Oil Disposition Circulatioin Remarks
47	OIL_DISP_LOST	☐	OIUREP_OIL_DISP_LOST		NUMC	7	0	Regulatory Reporting: Oil Disposition Lost
48	OIL_DISP_SEDMNT	☐	OIUREP_OIL_DISP_SEDMNT		NUMC	7	0	Regulatory Reporting: Oil Disposition Sedimentation
49	OIL_DISP_SEDMNT_EXP	☐	OIUREP_SEDMNT_EXPL		CHAR	50	0	Regulatory Reporting: Dispostition Sedimentation Re
50	OIL_DISP_OPER_CHG	☐	OIUREP_OIL_DISP_OPER_CHG		NUMC	7	0	Regulatory Reporting: Oil Disposition Operator Change
51	OIL_DISP_ROAD_OIL	☐	OIUREP_OIL_DISP_ROAD_OIL		NUMC	7	0	Regulatory Reporting: Oil Disposition Road Oil
52	OIL_DISP_LEASE_USE	☐	OIUREP_OIL_DISP_LEASE_USE		NUMC	7	0	Regulatory Reporting: Oil Disposition Lease Use
53	OIL_DISP_LOST_FORM	☐	OIUREP_OIL_DISP_LOST_FORM		NUMC	7	0	Regulatory Reporting: Oil Disposition Lost to Formation
54	OIL_DISP_OTHER_NM	☐	OIUREP_OIL_DISP_OTHER_NM		NUMC	7	0	Regulatory Reporting: Oil Disposition Other by name
55	OIL_DISP_OTHER_NM_EXP	☐	OIUREP_OTHER_EXPL		CHAR	50	0	Regulatory Reoprting: Other Explanation
56	OIL_DISP_SKIM	☐	OIUREP_OIL_DISP_SKIM		NUMC	7	0	Regulatory Reporting: Oil Disposition Skim
57	END_INV	☐	OIUREP_END_INV		NUMC	7	0	Regulatory Reporting: Ending Inventory
58	FIELD_NAME	☐	OIUREP_FLD_NAME		CHAR	32	0	Regulatory Reporting: Field Name
59	LEASE_NAME	☐	OIUREP_LEASE_NM		CHAR	32	0	Regulatory Reoprting: Lease Name
60	GAS_WL_NO	☐	OIUREP_TX_GAS_WL_NO	CHAR6	CHAR	6	0	Texas Gas Well number

History

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