	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

138 COLUMNS | 2 INDEXES | ERP 6.0 | OIUY3_TX_RPGDT TABLE

ERP EHP7

6.0

138

Royalty 2.0 - TX GLO/TAMU - Gas Report

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, RUN_ID, PROD_YEAR_MO, GLO_LEASE, RRC_DISTRICT_NO, RRC_OIL_LEASE_NO, RRC_GAS_WELL_ID, RRC_DRILL_PERMIT, PURCHASER_ID, REV_BOOK_ADJ_IND, RRC_FIELD_NAME, RRC_LEASE_NAME, PROP_ALIAS_NAME, REPORT_TYPE, GLO_UNIT_NO, TRACT_PART_FACT, OVERRIDE_CODE, OPERATOR_ID, PROD_DISP_RPT, AFFILIATED_SALE, GLO_TIK, FORM_PROD_VOL, NONFORM_PROD_VOL, FLASH_GAS_PROD, LEASE_FUEL_USE, OFF_LEASE_FUEL, TRANSMISSION_LN, RESIDUE_GAS_SALE, OTHER_PLANT_PROC, VENTED_OR_FLARED, CO2, H2S, GAS_LIFT, REPRESS_PRESS, UNDERGROUND_STOR, FLASH_GAS, ETHANES, PROPANES, NORMAL_BUTANES, ISO_BUTANES, NATURAL_GASOLINE, PLANT_CONDENSATE, SULFUR, OTHER_NGLS, OTHER_PRODUCTS, PLANT_SHRINK, CARBON_BLACK, ENTIRE_ROY_OB, LFU_RD, LFU_RDP, LFU_RDB, LFU_RDV, OLFU_RD, OLFU_RDP, OLFU_RDB, OLFU_RDV, TL_RD, TL_RDP, TL_RDB, TL_RDV, RGS_RD, RGS_RDP, RGS_RDB, RGS_RDV, OPP_RD, OPP_RDP, OPP_RDB, OPP_RDV, VF_RD, VF_RDP, VF_RDB, VF_RDV, CO2_RD, CO2_RDP, CO2_RDB, CO2_RDV, H2S_RD, H2S_RDP, H2S_RDB, H2S_RDV, GL_RD, GL_RDP, GL_RDB, GL_RDV, RPM_RD, RPM_RDP, RPM_RDB, RPM_RDV, US_RD, US_RDP, US_RDB, US_RDV, FG_RD, FG_RDP, FG_RDB, FG_RDV, E_RD, E_RDP, E_RDV, P_RD, P_RDP, P_RDV, NB_RD, NB_RDP, NB_RDV, IB_RD, IB_RDP, IB_RDV, NG_RD, NG_RDP, NG_RDV, PC_RD, PC_RDP, PC_RDV, S_RD, S_RDP, S_RDV, ONSS_RD, ONSS_RDP, ONSS_RDV, OP_RD, OP_RDP, OP_RDV, GR_VAL_ALL_PROD, ADDITIONAL_VAL, ADDITIONAL_VALKW, GROSS_VALUE, ROYALTY_DECIMAL, ROYALTY_DUE, COMMENT_FL, ORIGINAL_REPORT, ZERO_VOL, PAY_REPORT_FLAG, EXPECTED_RPT_EXC, MULTI_PURCHASER, REPORT_NUM, OIU_CRUSER, OIU_TIMESTAMP FROM OIUY3_TX_RPGDT

TOP ERP 6.0 | OIUY3_TX_RPGDT COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	RUN_ID	Run ID of Tax Report	nvarchar	10	0	NUMC	(N'0000000000')	No		OIUX3_RUN_ID	Allow NULL?
3	PROD_YEAR_MO	Royalty 2.0 - Texas GLO/TAMU - Production Year/Month YYYYMM	nvarchar	6	0	ACCP	(N' ')	No		OIUY3_TX_PROD_YEAR_MO	Allow NULL?
4	GLO_LEASE	Royalty 2.0 - TX GLO/TAMU Lease	nvarchar	6	0	NUMC	(N'000000')	No	OIUY3_TX_LEASE	OIUY3_TX_GLO_LEASE	Allow NULL?
5	RRC_DISTRICT_NO	Royalty 2.0 - TX GLO/TAMU - District Number	nvarchar	2	0	CHAR	(N' ')	No		OIUY3_TX_GLO_DISTRICT_NO	Allow NULL?
6	RRC_OIL_LEASE_NO	Royalty 2.0 - TX GLO/TAMU - RRC Oil Lease Number	nvarchar	5	0	CHAR	(N' ')	No		OIUY3_TX_GLO_RRC_OIL_LEASE_NO	Allow NULL?
7	RRC_GAS_WELL_ID	Royalty 2.0 - TX GLO/TAMU - RRC Gas Well ID	nvarchar	6	0	CHAR	(N' ')	No		OIUY3_TX_GLO_RRC_GAS_WELL_ID	Allow NULL?
8	RRC_DRILL_PERMIT	Royalty 2.0 - TX GLO/TAMU - RRC Drilling Permit	nvarchar	6	0	CHAR	(N' ')	No		OIUY3_TX_GLO_RRC_DRILLING_PERM	Allow NULL?
9	PURCHASER_ID	Royalty 2.0 - Texas GLO/TAMU - Purchaser ID	nvarchar	11	0	NUMC	(N'00000000000')	No		OIUY3_TX_PURCHASER_ID	Allow NULL?
10	REV_BOOK_ADJ_IND	Royalty 2.0 - TX - Reversal/Booking/Reversal Adjustment/Adjs	char	1	0	CHAR	(N' ')	No		OIUY3_REV_BOOK_REVADJ_ADJ_IND	Allow NULL?
11	RRC_FIELD_NAME	Royalty 2.0 - TX GLO/TAMU - RRC Field Name	nvarchar	32	0	CHAR	(N' ')	Yes		OIUY3_TX_GLO_RRC_FIELD_NAME	Allow NULL?
12	RRC_LEASE_NAME	Royalty 2.0 - TX GLO/TAMU - RRC Lease Name	nvarchar	32	0	CHAR	(N' ')	Yes		OIUY3_TX_GLO_RRC_LEASE_NAME	Allow NULL?
13	PROP_ALIAS_NAME	Royalty 2.0 - TX GLO/TAMU - Property Alias Name	nvarchar	32	0	CHAR	(N' ')	Yes		OIUY3_TX_GLO_PROP_ALIAS_NAME	Allow NULL?
14	REPORT_TYPE	Royalty 2.0 - Texas GLO/TAMU - Report Type	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_REPORT_TYPE	Allow NULL?
15	GLO_UNIT_NO	Royalty 2.0 - Texas GLO/TAMU - Unit Number	nvarchar	4	0	CHAR	(N' ')	Yes		OIUY3_TX_GLO_UNIT_NO	Allow NULL?
16	TRACT_PART_FACT	Royalty 2.0 - Texas GLO - Tract Participation Factor	decimal	9	8	DEC	((0))	Yes		OIUY3_TX_TRACT_PART_FACTOR
17	OVERRIDE_CODE	Royalty 2.0 - TX GLO/TAMU - Override Code	nvarchar	5	0	CHAR	(N' ')	Yes		OIUY3_TX_OVERRIDE_CODE	Allow NULL?
18	OPERATOR_ID	Royalty 2.0 - TX GLO - Operator ID	nvarchar	10	0	CHAR	(N' ')	Yes		OIUY3_TX_OPERATOR_ID	Allow NULL?
19	PROD_DISP_RPT	Royalty 2.0 - TX GLO/TAMU - Production Disp Report Indicator	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_PROD_DISP_RPT_IND	Allow NULL?
20	AFFILIATED_SALE	Royalty 2.0 - TX GLO - Affiliated Sale Indicator	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_AFFILIATED_SALE_IND	Allow NULL?
21	GLO_TIK	Royalty 2.0 - Texas GLO/TAMU - GLO TIK	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_GLO_TIK	Allow NULL?
22	FORM_PROD_VOL	Royalty 2.0 - TX GLO/TAMU - Formation Production Volume	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_FORMATION_PROD_VOL
23	NONFORM_PROD_VOL	Royalty 2.0 - TX GLO/TAMU - Non-Formation Production Volume	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_NONFORMATION_PROD_VOL
24	FLASH_GAS_PROD	Royalty 2.0 - TX GLO/TAMU - Flash Gas Production Volume	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_FLASH_GAS_PROD_VOL
25	LEASE_FUEL_USE	Royalty 2.0 - TX GLO/TAMU - 1A Lease Fuel Use	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_LEASE_FUEL_USE
26	OFF_LEASE_FUEL	Royalty 2.0 - TX GLO/TAMU - 1B Field (Off Lease) Fuel Use	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_OFF_LEASE_FUEL_USE
27	TRANSMISSION_LN	Royalty 2.0 - TX GLO/TAMU - 2 Transmission Line	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_TRANSMISSION_LINE
28	RESIDUE_GAS_SALE	Royalty 2.0 - TX GLO/TAMU - 3A Residue Gas Sales	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_RESIDUE_GAS_SALES
29	OTHER_PLANT_PROC	Royalty 2.0 - TX GLO/TAMU - 3C Other Plant Processed	decimal	11	2	DEC	((0))	Yes		OIUY3_OTHER_PLANT_PROCESSED
30	VENTED_OR_FLARED	Royalty 2.0 - TX GLO/TAMU - 4A Vented or Flared	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_VENTED_OR_FLARED
31	CO2	Royalty 2.0 - TX GLO/TAMU - 4B CO2	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_CO2
32	H2S	Royalty 2.0 - TX GLO/TAMU - 4C H2S	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_H2S
33	GAS_LIFT	Royalty 2.0 - TX GLO/TAMU - 5 Gas Lift	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_GAS_LIFT
34	REPRESS_PRESS	Royalty 2.0 - TX GLO/TAMU - 6 Repressure / Pressure Maint	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_REPRESS_PRESS_MAINT
35	UNDERGROUND_STOR	Royalty 2.0 - TX GLO/TAMU - 8 Underground Storage	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_UNDERGROUND_STORAGE
36	FLASH_GAS	Royalty 2.0 - TX GLO/TAMU - Flash Gas	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_FLASH_GAS
37	ETHANES	Royalty 2.0 - TX GLO/TAMU - Ethanes	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_ETHANES
38	PROPANES	Royalty 2.0 - TX GLO/TAMU - Propanes	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_PROPANES
39	NORMAL_BUTANES	Royalty 2.0 - TX GLO/TAMU - Normal Butanes	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_NORMAL_BUTANES
40	ISO_BUTANES	Royalty 2.0 - TX GLO/TAMU - Iso-Butanes	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_ISO_BUTANES
41	NATURAL_GASOLINE	Royalty 2.0 - TX GLO/TAMU - Natural Gasoline	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_NATURAL_GASOLINE
42	PLANT_CONDENSATE	Royalty 2.0 - TX GLO/TAMU - Plant Condensate	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_PLANT_CONDENSATE
43	SULFUR	Royalty 2.0 - TX GLO/TAMU - Sulfur	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_SULFUR
44	OTHER_NGLS	Royalty 2.0 - TX GLO/TAMU - Other NGLs Single Stream	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_OTHER_NGLS_SINGLE_STR
45	OTHER_PRODUCTS	Royalty 2.0 - TX GLO/TAMU - Other Products (Incl Carbon Blk)	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_OTHER_PRODUCTS
46	PLANT_SHRINK	Royalty 2.0 - TX GLO/TAMU - 3B Plant Shrink	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_PLANT_SHRINK
47	CARBON_BLACK	Royalty 2.0 - TX GLO/TAMU - 7 Carbon Black	decimal	11	2	DEC	((0))	Yes		OIUY3_TX_CARBON_BLACK
48	ENTIRE_ROY_OB	Royalty 2.0 - TX GLO/TAMU - Entire Royalty Obligation	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_ENTIRE_ROYALTY_OB	Allow NULL?
49	LFU_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
50	LFU_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
51	LFU_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
52	LFU_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
53	OLFU_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
54	OLFU_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
55	OLFU_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
56	OLFU_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
57	TL_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
58	TL_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
59	TL_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
60	TL_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
61	RGS_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
62	RGS_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
63	RGS_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
64	RGS_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
65	OPP_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
66	OPP_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
67	OPP_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
68	OPP_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
69	VF_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
70	VF_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
71	VF_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
72	VF_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
73	CO2_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
74	CO2_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
75	CO2_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
76	CO2_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
77	H2S_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
78	H2S_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
79	H2S_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
80	H2S_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
81	GL_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
82	GL_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
83	GL_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
84	GL_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
85	RPM_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
86	RPM_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
87	RPM_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
88	RPM_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
89	US_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
90	US_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
91	US_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
92	US_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
93	FG_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
94	FG_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
95	FG_RDB	Royalty 2.0 - TX GLO/TAMU - BTU Factor	decimal	7	6	DEC	((0))	Yes		OIUY3_TX_BTU_FACTOR
96	FG_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
97	E_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
98	E_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
99	E_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
100	P_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
101	P_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
102	P_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
103	NB_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
104	NB_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
105	NB_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
106	IB_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
107	IB_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
108	IB_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
109	NG_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
110	NG_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
111	NG_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
112	PC_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
113	PC_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
114	PC_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
115	S_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
116	S_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
117	S_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
118	ONSS_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
119	ONSS_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
120	ONSS_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
121	OP_RD	Gross Volume	decimal	11	2	DEC	((0))	Yes		OIUX3_GROSS_VOLUME
122	OP_RDP	Royalty 2.0 - Texas GLO/TAMU - Unit Value	decimal	9	6	DEC	((0))	Yes		OIUY3_TX_UNIT_VALUE
123	OP_RDV	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
124	GR_VAL_ALL_PROD	Royalty 2.0 - TX GLO/TAMU - Gross Value All Products	decimal	11	2	CURR	((0))	Yes		OIUY3_TX_GROSS_VAL_ALL_PROD
125	ADDITIONAL_VAL	Royalty 2.0 - TX GLO/TAMU - Additional Value	decimal	11	2	CURR	((0))	Yes		OIUY3_TX_ADDITIONAL_VALUE
126	ADDITIONAL_VALKW	Royalty 2.0 - TX GLO/TAMU - Additional Value KW	decimal	11	2	CURR	((0))	Yes		OIUY3_TX_ADDITIONAL_VALUE_KW
127	GROSS_VALUE	Gross Value	decimal	11	2	CURR	((0))	Yes		OIUX3_GROSS_VALUE
128	ROYALTY_DECIMAL	Royalty 2.0 - Texas GLO - Royalty Decimal	decimal	9	8	DEC	((0))	Yes		OIUY3_TX_ROYALTY_DECIMAL
129	ROYALTY_DUE	Royalty 2.0 - Texas GLO/TAMU - Royalty Due	decimal	11	2	CURR	((0))	Yes		OIUY3_TX_ROYALTY_DUE
130	COMMENT_FL	Royalty 2.0 - Texas GLO/TAMU - Comment Flag	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_COMMENT_FL	Allow NULL?
131	ORIGINAL_REPORT	Royalty 2.0 - TX GLOTAMU - Original Report	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_ORIGINAL_REPORT	Allow NULL?
132	ZERO_VOL	Royalty 2.0 - Texas GLO/TAMU - Zero Volume Flag	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_ZERO_VOL	Allow NULL?
133	PAY_REPORT_FLAG	Royalty 2.0 - TX GLO/TAMU - Pay/Report Flag	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_PAY_REPORT_FLAG	Allow NULL?
134	EXPECTED_RPT_EXC	Royalty 2.0 - Texas GLO/TAMU No of Expected Reports Exceeded	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_EXPECTED_RPT_EXCEEDED	Allow NULL?
135	MULTI_PURCHASER	Royalty 2.0 - Texas GLO/TAMU - Multiple Purchasers Flag	char	1	0	CHAR	(N' ')	Yes		OIUY3_TX_MULTIPLE_PURCHASERS	Allow NULL?
136	REPORT_NUM	Roy 2.0 TX - Report Number	nvarchar	4	0	NUMC	(N'0000')	Yes		OIUY3_TX_REPORT_NUM	Allow NULL?
137	OIU_CRUSER	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
138	OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0	DEC	((0))	Yes		TZNTSTMPS

TOP ERP 6.0 | OIUY3_TX_RPGDT INDEXES

Name	Primary	Unique	Type	Columns
OIUY3_TX_RPGDT~0	Yes	Yes	CLUSTERED	REV_BOOK_ADJ_IND, PURCHASER_ID, RRC_DRILL_PERMIT, RRC_GAS_WELL_ID, RRC_OIL_LEASE_NO, RRC_DISTRICT_NO, GLO_LEASE, PROD_YEAR_MO, RUN_ID, MANDT
OIUY3_TX_RPGDT~001	No	No	NONCLUSTERED	REV_BOOK_ADJ_IND, PURCHASER_ID, RRC_DRILL_PERMIT, RRC_GAS_WELL_ID, RRC_OIL_LEASE_NO, RRC_DISTRICT_NO, GLO_LEASE, PROD_YEAR_MO, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

138 COLUMNS | 2 INDEXES | ERP 6.0 | OIUY3_TX_RPGDT TABLE

TOP ERP 6.0 | OIUY3_TX_RPGDT COLUMNS

TOP ERP 6.0 | OIUY3_TX_RPGDT INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

138 COLUMNS | 2 INDEXES | ERP 6.0 | OIUY3_TX_RPGDT TABLE

TOPERP 6.0 | OIUY3_TX_RPGDT COLUMNS

TOPERP 6.0 | OIUY3_TX_RPGDT INDEXES

TOP ERP 6.0 | OIUY3_TX_RPGDT COLUMNS

TOP ERP 6.0 | OIUY3_TX_RPGDT INDEXES