SAP ABAP Table ROIUY3_TX_GLO1 (Royalty 2.0 - TX GLO/TAMU - Oil Report structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY3_TX_GLO1	Table Relationship Diagram
Short Description	Royalty 2.0 - TX GLO/TAMU - Oil Report structure

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	Royalty 2.0 - TX GLO/TAMU - Structure for Report Header
2	REPCOMPANYID	☐	OIUY3_REPCOMPANYID		CHAR	10	0	Royalty 2.0 - Texas GLO/TAMU-reporting company id
3	REPCOMPANYNAME	☐	OIUY3_REPCOMPANYNAME		STRG	0	0	Royalty 2.0 - Texas GLO/TAMU Reporting company nam
4	BAN	☐	OIUX3_BLANKET_AUTH_NO	CHAR4	CHAR	4	0	Blanket Authorization Number
5	PREPDATE	☐	OIUY3_PREPDATE		CHAR	10	0	Royalty 2.0 - Texas GLO/TAMU Prepared date
6	PHONE	☐	OIUX3_CONTACT_PHONE_NUMBER	NUMC10	NUMC	10	0	Tax Reporting - Contact Phone Number
7	PREPBY	☐	OIUX3_CONTACT_NAME	TEXT50	CHAR	50	0	Tax Reporting - Contact Name
8	EMAIL	☐	OIUX3_CONTACT_EMAIL	TEXT80	CHAR	80	0	Tax Reporting - Contact Email Address
9	GLOREP	☐	OIUY3_REPNAME		STRG	0	0	Royalty 2.0 - Texas GLO/TAMU report name
10	.INCLUDE	☐				0	0	Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters
11	REPORTID	☐	OIUY3_REPID		STRG	0	0	Royalty 2.0 - Texas GLO/TAMU- Report id
12	REPORTNUM	☐	OIUY3_REPNUM		CHAR	4	0	Royalty 2.0 - Texas GLO/TAMU- Report Type
13	PRODYYMM	☐	OIUY3_TX_PROD_YEAR_MO	OIU_PROD_MONTH	ACCP	6	0	Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM
14	STATELEASE	☐	OIUY3_TX_GLO_LEASE	OIUY3_TX_GLO_LEASE	NUMC	6	0	Royalty 2.0 - TX GLO/TAMU Lease
15	RRCDRILLEINGPERM	☐	OIUY3_TX_GLO_RRC_DRILLING_PERM		CHAR	6	0	Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit
16	RRCFIELDNAME	☐	OIUY3_TX_GLO_RRC_FIELD_NAME		CHAR	32	0	Royalty 2.0 - TX GLO/TAMU - RRC Field Name
17	RRCLEASENAME	☐	OIUY3_TX_GLO_RRC_LEASE_NAME		CHAR	32	0	Royalty 2.0 - TX GLO/TAMU - RRC Lease Name
18	PURCHASERID	☐	OIUY3_TX_PURCHASER_ID		NUMC	11	0	Royalty 2.0 - Texas GLO/TAMU - Purchaser ID
19	PAYERID	☐	OIUX3_TAXPAYER_NUMBER	TEXT20	CHAR	20	0	Tax Reporting - Taxpayer Number
20	REPORTTYPE	☐	OIUY3_TX_REPORT_TYPE	OIUY3_TX_REPORT_TYPE	CHAR	1	0	Royalty 2.0 - Texas GLO/TAMU - Report Type
21	UNITID	☐	OIUY3_TX_GLO_UNIT_NO		CHAR	4	0	Royalty 2.0 - Texas GLO/TAMU - Unit Number
22	TRACTPARTIC	☐	OIUY3_TX_TRACT_PART_FACTOR	OIU_PERCENT98	DEC	9	8	Royalty 2.0 - Texas GLO - Tract Participation Factor
23	ORIGINAL	☐	OIUY3_ORIGINAL		CHAR	3	0	Royalty 2.0 - Texas GLO/TAMU- Original
24	OVERRIDECODE	☐	OIUY3_TX_OVERRIDE_CODE		CHAR	5	0	Royalty 2.0 - TX GLO/TAMU - Override Code
25	ANNUAL	☐	OIUY3_ANNUAL		CHAR	3	0	Royalty 2.0 - Texas GLO/TAMU - Annual
26	OPERATORID	☐	OIUY3_TX_OPERATOR_ID	OIUY3_TX_ID	CHAR	10	0	Royalty 2.0 - TX GLO - Operator ID
27	OPERATORREPORT	☐	OIUY3_OPERATORREP		CHAR	3	0	Royalty 2.0 - Texas GLO/TAMU - Operator Report
28	AFFILIATEDSALE	☐	OIUY3_TX_AFFILIATED_SALE_IND	YESNO	CHAR	1	0	Royalty 2.0 - TX GLO - Affiliated Sale Indicator
29	INKIND	☐	OIUY3_TX_GLO_TIK	YESNO	CHAR	1	0	Royalty 2.0 - Texas GLO/TAMU - GLO TIK
30	COMMENTS	☐	OIUY3_TX_COMMENT_FL	YESNO	CHAR	1	0	Royalty 2.0 - Texas GLO/TAMU - Comment Flag
31	RRCOILID	☐	OIUY3_TX_GLO_RRC_OIL_LEASE_NO		CHAR	5	0	Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number
32	RRCGASID	☐	OIUY3_TX_GLO_RRC_GAS_WELL_ID		CHAR	6	0	Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID
33	PROPERTYALIAS	☐	OIUY3_TX_GLO_PROP_ALIAS_NAME		CHAR	32	0	Royalty 2.0 - TX GLO/TAMU - Property Alias Name
34	.INCLUDE	☐				0	0	Royalty 2.0 - Texas GLO/TAMU Oil report volumes and Values
35	BEGINSTOCK	☐	OIUY3_TX_BEGINNING_STOCK	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Beginning Stock
36	GROSSPROD	☐	OIUY3_TX_GROSS_PRODUCTION	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Gross Production
37	PIPELINE	☐	OIUY3_TX_PIPELINE	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Pipeline
38	TRUCK	☐	OIUY3_TX_TRUCK	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Truck
39	TANKBARGE	☐	OIUY3_TX_TANK_CAR_BARGE	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Tank Car Barge
40	TANKCLEANING	☐	OIUY3_TX_TANK_CLEANING	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Tank Cleaning
41	CIRCULATING	☐	OIUY3_TX_CIRCULATING_OIL_COND	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Circulating Oil/Condensate
42	LOST	☐	OIUY3_TX_LOST_STOLEN	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Lost/Stolen
43	SEDIMENT	☐	OIUY3_TX_BASIC_SEDIMENT_WATER	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Basic Sediment / Water
44	OTHERDUE	☐	OIUY3_TX_OTHER_ROYALTY_DUE	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Other Royalty Due
45	OTHERNOTDUE	☐	OIUY3_TX_OTHER_NO_ROYALTY_DUE	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Other No Royalty Due
46	SKIMHYDROCARBONS	☐	OIUY3_TX_SKIM_LIQUID_HYDRO	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Skim Liquid Hydrocarbon
47	SCRUBBER	☐	OIUY3_TX_SCRUBBER_OIL	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Scrubber Oil
48	ENDINGSTOCK	☐	OIUY3_TX_ENDING_STOCK	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Ending Stock
49	DRIP	☐	OIUY3_TX_DRIP_OIL	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Drip Oil
50	ROYYNETDUEBARELS	☐	OIUY3_TX_ROY_DUE_NET_BARRELS	OIUY3_SIGNED_DEC_15_6	DEC	15	6	Royalty 2.0 - TX GLO/TAMU - Royalty Due Net Barrels
51	APIGRAVITY	☐	OIUY3_TX_API_GRAVITY		DEC	9	6	Royalty 2.0 - Texas GLO/TAMU - API Gravity
52	UNITVALUE	☐	OIUY3_TX_UNIT_VALUE		DEC	9	6	Royalty 2.0 - Texas GLO/TAMU - Unit Value
53	GROSSVALUE	☐	OIUX3_GROSS_VALUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Gross Value
54	OROYALTYDECIMAL	☐	OIUY3_TX_ROYALTY_DECIMAL	OIU_PERCENT98	DEC	9	8	Royalty 2.0 - Texas GLO - Royalty Decimal
55	OROYALTYDUE	☐	OIUY3_TX_ROYALTY_DUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - Texas GLO/TAMU - Royalty Due
56	EIGHTEIGHTS	☐	OIUY3_EIGHTEIGHTS		CHAR	4	0	Royalty 2.0 - TX GLO/TAMU - Eighteights

History

Last changed by/on	SAP	20130529
SAP Release Created in	617