SAP ABAP Table ROIUREP_OK_CLO109_D (Structure for the Detail Part of CLO-109 Report (OK Royalty))

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_OK_CLO109_D	Table Relationship Diagram
Short Description	Structure for the Detail Part of CLO-109 Report (OK Royalty)

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	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	OIU_PR_FIELD
2	AGENCY_LEASE	☐	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.
3	REP_IND	☐	OIUREP_REPORT_IND	OIUREP_REPORT_IND	CHAR	1	0	Indicator (Current or Amended) Report
4	YEAR_MONTH	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
5	YR_MON_AMND	☐	OIUREP_AMND_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Year and Month for Amended Reports
6	AGENCY	☐	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
7	GVOL_PRD_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
8	GVOL_PRD_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
9	GVAL_DUE_LEASE_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
10	GVAL_DUE_LEASE_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
11	BUVAL_DUE_LEASE_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
12	BUVAL_DUE_LEASE_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
13	RESG_VOL_SLD_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
14	RESG_VOL_SLD_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
15	CRTPER_LEASE_PR_W	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
16	CRTPER_LEASE_PR_S	☐	OIUH_CHAR5	CHAR5	CHAR	5	0	OIUH_CHAR5
17	PRS_GAS_PRICE_W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
18	PRS_GAS_PRICE_S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
19	RESVAL_DUE_LEASE_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
20	RESVAL_DUE_LEASE_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
21	TOTVAL_PRS_G_SLD_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
22	TOTVAL_PRS_G_SLD_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
23	ADJUST_LN15_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
24	ADJUST_LN15_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
25	ADJVAL_PRS_G_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
26	ADJVAL_PRS_G_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
27	ROYINTPER_PRS_G_W	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
28	ROYINTPER_PRS_G_S	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
29	ROYVAL_PRS_G_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
30	ROYVAL_PRS_G_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
31	TOTVOL_DRY_G_W	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
32	TOTVOL_DRY_G_S	☐	OIUREP_PROD_W_01_VOL	OIUH_DEC13_2	DEC	13	2	Generic Volume for Oil/Gas
33	DRY_G_RATE_W	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
34	DRY_G_RATE_S	☐	OIUH_CHAR8	CHAR8	CHAR	8	0	OIUH_CHAR8
35	TOTVAL_DRY_G_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
36	TOTVAL_DRY_G_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
37	ADJUST_LN19_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
38	ADJUST_LN19_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
39	ADJVAL_DRY_G_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
40	ADJVAL_DRY_G_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
41	ROYINTPER_DRY_G_W	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
42	ROYINTPER_DRY_G_S	☐	OIUH_CHAR10	CHAR10	CHAR	10	0	OIUH_CHAR10
43	ROYVAL_DRY_G_S	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
44	ROYVAL_DRY_G_W	☐	OIUREP_PROD_W_01_VALUE	OIUH_DEC11_2	DEC	11	2	Generic Value for Oil/Gas
45	OPR_WELL	☐	OIUH_CHAR3	CHAR3	CHAR	3	0	OIUH_CHAR3
46	SEC	☐	OIUY1_SECTION_NO	CHAR6	CHAR	6	0	Section Number
47	TWP	☐	OIU_TWP_NO	CHAR3	CHAR	3	0	Township number
48	RGE	☐	OIUY1_RGE	CHAR3	CHAR	3	0	RGE
49	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
50	DESCPN	☐	OIUREP_LEASE_TEXT	CHAR60	CHAR	60	0	Agency Lease Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUREP_OK_CLO109_D	FIELD	OIU_PR_FIELD	FIELD

History

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