SAP ABAP Table ROIUY1_TX_GLO_H (Structure to store the GLO header.)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY1_TX_GLO_H	Table Relationship Diagram
Short Description	Structure to store the GLO header.

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	ST_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
2	REC_COUNT	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
3	PROD_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
4	REPORT_IND	☐	OIUREP_REPORT_IND	OIUREP_REPORT_IND	CHAR	1	0	Indicator (Current or Amended) Report
5	OIL_GAS	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
6	RPT_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
7	TR_NO	☐	OIU_TR_NO	OIU_TR_NO	CHAR	6	0	Tract Number
8	UNIT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
9	CO_TAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
10	CO_NM	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
11	OPER_TAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
12	PUR_TAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
13	ROY_PAYTAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
14	PREP_BY	☐	OIUY1_PREP_BY	CHAR40	CHAR	40	0	Report Prepared by(Name of the person)
15	TEL_NO	☐	OIUREP_CONTACT_TEL_NO	CHAR15	CHAR	15	0	Telephone no. of the contact person
16	EMAIL	☐	OIUREP_CONTACT_E_MAIL	OIUREP_CONTACT_E_MAIL	CHAR	50	0	E-mail of the Contact Person
17	SW_SWEET_FL	☐	OIUY1_SW_FLAG	OIUY1_SR	CHAR	1	0	Sweet or Sour Flag(Y/N)
18	BAN	☐	OIUH_BAN	CHAR4	CHAR	4	0	Blanket Authorization number
19	AMD_BAN	☐	OIUH_BAN	CHAR4	CHAR	4	0	Blanket Authorization number
20	DATE_PREP	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
21	AMD_DATE_PREP	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
22	AMD_DLN_RPT_NO	☐	OIUH_BAN	CHAR4	CHAR	4	0	Blanket Authorization number
23	DLN_RPT_NO	☐	OIUH_BAN	CHAR4	CHAR	4	0	Blanket Authorization number
24	OIL_COND	☐	OIUY1_PRD_REPORTED	CHAR1	CHAR	1	0	Production Reported (oil/condensate)
25	ROY_OBLIGATION	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
26	ENTL_FLAG	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
27	LSE_NM1	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
28	LSE_NM2	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
29	LSE_NM3	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
30	LSE_NM4	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
31	FL_NM1	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
32	FL_NM2	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
33	FL_NM3	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
34	FL_NM4	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
35	RRC_OIL_NO1	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
36	RRC_DIST_CD1	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
37	RRC_WL_LSE_NO1	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
38	RRC_OIL_NO2	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
39	RRC_DIST_CD2	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
40	RRC_WL_LSE_NO2	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
41	RRC_OIL_NO3	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
42	RRC_DIST_CD3	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
43	RRC_WL_LSE_NO3	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
44	RRC_OIL_NO4	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
45	RRC_DIST_CD4	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
46	RRC_WL_LSE_NO4	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
47	ANNUAL_REPORT	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
48	SWEET_PER	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
49	SOUR_PER	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
50	SALES_DATE	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
51	PUR_ID	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
52	RRC_OIL_NO5	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
53	RRC_DIST_CD5	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
54	RRC_WL_LSE_NO5	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
55	RRC_WL_LSE_NO6	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
56	RRC_WL_LSE_NO7	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
57	RRC_WL_LSE_NO8	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
58	RRC_WL_LSE_NO9	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
59	RRC_WL_LSE_NO10	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
60	RRC_OIL	☐			CHAR	700	0
61	RRC_GAS	☐			CHAR	700	0
62	OPERATOR_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1

History

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