SAP ABAP Table ROIUY1_TX_AM_H (Structure to store the AM 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_AM_H	Table Relationship Diagram
Short Description	Structure to store the AM 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	PROD_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	AMND_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
4	PUR_ID	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
5	REC_COUNT	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
6	REPORT_IND	☐	OIUREP_REPORT_IND	OIUREP_REPORT_IND	CHAR	1	0	Indicator (Current or Amended) Report
7	OIL_GAS	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
8	ALL_GAS	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
9	RPT_TYPE	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
10	TR_NO	☐	OIU_TR_NO	OIU_TR_NO	CHAR	6	0	Tract Number
11	UNIT_NO	☐	OIUH_CHAR4	CHAR4	CHAR	4	0	OIUH_CHAR4
12	OPERATOR_NO	☐	OIUH_CHAR6	CHAR6	CHAR	6	0	OIUH_CHAR6
13	REPORTER	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
14	OPER_TAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
15	OPERATOR_NAME	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
16	PUR_TAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
17	ROYAL_PD_BY	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
18	ROY_PAYTAXID	☐	OIUH_CO_REPORTING_NO	CHAR13	CHAR	13	0	Company Reporting No
19	PREP_BY	☐	OIUY1_PREP_BY	CHAR40	CHAR	40	0	Report Prepared by(Name of the person)
20	TEL_NO	☐	OIUREP_CONTACT_TEL_NO	CHAR15	CHAR	15	0	Telephone no. of the contact person
21	EMAIL	☐	OIUREP_CONTACT_E_MAIL	OIUREP_CONTACT_E_MAIL	CHAR	50	0	E-mail of the Contact Person
22	SW_SWEET_FL	☐	OIUY1_SW_FLAG	OIUY1_SR	CHAR	1	0	Sweet or Sour Flag(Y/N)
23	OIL_COND	☐	OIUY1_PRD_REPORTED	CHAR1	CHAR	1	0	Production Reported (oil/condensate)
24	LSE_NM1	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
25	LSE_NM2	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
26	LSE_NM3	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
27	LSE_NM4	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text
28	FL_NM1	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
29	FL_NM2	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
30	FL_NM3	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
31	FL_NM4	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
32	RRC_OIL_NO1	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
33	RRC_DIST_CD1	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
34	RRC_WL_LSE_NO1	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
35	RRC_OIL_NO2	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
36	RRC_DIST_CD2	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
37	RRC_WL_LSE_NO2	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
38	RRC_OIL_NO3	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
39	RRC_DIST_CD3	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
40	RRC_WL_LSE_NO3	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
41	RRC_OIL_NO4	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
42	RRC_DIST_CD4	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
43	RRC_WL_LSE_NO4	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
44	RRC_OIL_NO5	☐	OIUH_RRC_OIL_LEASE	CHAR7	CHAR	7	0	RRC Oil Lease
45	RRC_DIST_CD5	☐	OIUH_RRC_DISTRICT_ID	CHAR3	CHAR	3	0	RRC District ID
46	RRC_WL_LSE_NO5	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
47	RRC_OIL	☐			CHAR	700	0
48	RRC_GAS	☐			CHAR	700	0

History

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