	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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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

254 columns | ERP 6.0 | WC_NO

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CNVTDMS_05_WCDT	Well Completion Downtime Number	4	WC_NO	well number	nvarchar	15	0
2	CNVTDMS_5_WCDVLH	fill hedaer for well completion	6	WC_NO	Well Completion Number	nvarchar	5	0
3	OIUX6Y_WY_MSTPLT	Tax 2.0 - Wyoming Plant Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
4	OIUX6_WY_MSTPLT	Tax 2.0 - Wyoming Plant Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
5	OIUX8Y_NM_MASTER	Tax 2.0 - NM - Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
6	OIUX8_NM_ASUE_DT	Tax 2.0 NM - Auto Suspend Exception Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
7	OIUX8_NM_ASU_DT	Tax 2.0 - NM - Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
8	OIUX8_NM_MASTER	Tax 2.0 - NM - Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
9	OIUX8_NM_OOSHST	Tax 2.0 - NM - Out-Of-Statute Transaction History	6	WC_NO	Well Completion Number	nvarchar	5	0
10	OIUX8_NM_OOSTXN	Tax 2.0 - NM - Out-Of-Statute Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
11	OIUX8_NM_PRDT	Tax 2.0 - NM - PRA Detail Transactions	7	WC_NO	Well Completion Number	nvarchar	5	0
12	OIUX8_NM_REVSTG	Tax 2.0 - NM - Tax Reversals (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
13	OIUX8_NM_REVTXN	Tax 2.0 - NM - Tax Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
14	OIUX8_NM_SUFFDEC	Tax 2.0 - New Mexico Suffix Decimal	6	WC_NO	Well Completion Number	nvarchar	5	0
15	OIUX8_NM_TAXHST	Tax 2.0 - NM - Tax Transaction History	6	WC_NO	Well Completion Number	nvarchar	5	0
16	OIUX8_NM_TAXSTG	Tax 2.0 - NM - Tax Transactions (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
17	OIUX8_NM_TAXTXN	Tax 2.0 - NM - Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
18	OIUY3Y_TX_MASTER	Royalty 2.0 - TX GLO/TAMU - Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
19	OIUY3Y_TX_RRC	Royalty 2.0 - TX GLO/TAMU - RRC Master PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
20	OIUY3_TX_ASU_DT	Royalty 2.0 - TX GLO/TAMU - Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
21	OIUY3_TX_INTSTG	Royalty 2.0 - TX GLO - Royalty Trans Interface Staging	10	WC_NO	Well Completion Number	nvarchar	5	0
22	OIUY3_TX_INTTXN	Royalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface	10	WC_NO	Well Completion Number	nvarchar	5	0
23	OIUY3_TX_MASTER	Royalty 2.0 - TX GLO/TAMU - Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
24	OIUY3_TX_OOSHST	Royalty 2.0 - TX - Out of Statute Royalty Transaction Hist	6	WC_NO	Well Completion Number	nvarchar	5	0
25	OIUY3_TX_OOSTXN	Royalty 2.0 - TX GLO - Out of Statute Royalty Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
26	OIUY3_TX_PDCXRF	Royalty 2.0 - TX GLO/TAMU - Production Disposition XRef	4	WC_NO	Well Completion Number	nvarchar	5	0
27	OIUY3_TX_PRDT	Royalty 2.0 - TX GLO - Royalty PRA Details	7	WC_NO	Well Completion Number	nvarchar	5	0
28	OIUY3_TX_PRDTA	Royalty 2.0 - TX GLO - Royalty PRA Details (Allocated)	7	WC_NO	Well Completion Number	nvarchar	5	0
29	OIUY3_TX_RDCXRF	Royalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef	3	WC_NO	Well Completion Number	nvarchar	5	0
30	OIUY3_TX_REVSTG	Royalty 2.0 - TX GLO - Royalty Reversals (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
31	OIUY3_TX_REVTXN	Royalty 2.0 - TX GLO - Royalty Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
32	OIUY3_TX_ROYHST	Royalty 2.0 - TX GLO - Royalty Transaction History	6	WC_NO	Well Completion Number	nvarchar	5	0
33	OIUY3_TX_ROYHSTA	Royalty 2.0 - TX GLO - Royalty Trans History (Allocated)	6	WC_NO	Well Completion Number	nvarchar	5	0
34	OIUY3_TX_ROYSTG	Royalty 2.0 - TX GLO - Royalty Transactions (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
35	OIUY3_TX_ROYTXN	Royalty 2.0 - TX GLO - Royalty Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
36	OIUY3_TX_ROYTXNA	Royalty 2.0 - TX GLO - Royalty Transactions (Allocated)	6	WC_NO	Well Completion Number	nvarchar	5	0
37	OIUY3_TX_RPDTM	Royalty 2.0 - TX GLO/TAMU - Report Detail - Masters	9	WC_NO	Well Completion Number	nvarchar	5	0
38	OIUY3_TX_RRC	Royalty 2.0 - TX GLO/TAMU - RRC Master	4	WC_NO	Well Completion Number	nvarchar	5	0
39	OIUY6Y_WY_MASTER	Royalty 2.0 - WY - Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
40	OIUY6_WY_ASU_DT	Royalty 2.0 - WY - Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
41	OIUY6_WY_CAPOVR	Roy 2.0 - Wyoming - CA Percent Override	3	WC_NO	Well Completion Number	nvarchar	5	0
42	OIUY6_WY_CBMOVR	Royalty 2.0 - WY - Coal Bed Methane Override	3	WC_NO	Well Completion Number	nvarchar	5	0
43	OIUY6_WY_INTSTG	Royalty 2.0 - WY - Royalty Transaction Interface (Staging)	10	WC_NO	Well Completion Number	nvarchar	5	0
44	OIUY6_WY_INTTXN	Royalty 2.0 - WY - Royalty Transaction Interface	10	WC_NO	Well Completion Number	nvarchar	5	0
45	OIUY6_WY_MASTER	Royalty 2.0 - WY - Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
46	OIUY6_WY_OOSHST	Royalty 2.0 - WY - Out of Statute Royalty Transaction Hist	6	WC_NO	Well Completion Number	nvarchar	5	0
47	OIUY6_WY_OOSTXN	Royalty 2.0 - WY - Out of Statute Royalty Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
48	OIUY6_WY_PRDT	Royalty 2.0 - WY - Royalty PRA Details	7	WC_NO	Well Completion Number	nvarchar	5	0
49	OIUY6_WY_PRDTA	Royalty 2.0 - WY - Royalty PRA Details (Allocated)	7	WC_NO	Well Completion Number	nvarchar	5	0
50	OIUY6_WY_REVSTG	Royalty 2.0 - WY - Royalty Reversals (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
51	OIUY6_WY_REVTXN	Royalty 2.0 - WY - Royalty Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
52	OIUY6_WY_ROYHST	Royalty 2.0 - WY - Royalty Transaction History	6	WC_NO	Well Completion Number	nvarchar	5	0
53	OIUY6_WY_ROYHSTA	Royalty 2.0 - WY - Royalty Transaction History (Allocated)	6	WC_NO	Well Completion Number	nvarchar	5	0
54	OIUY6_WY_ROYSTG	Royalty 2.0 - WY - Royalty Transactions (Staging)	6	WC_NO	Well Completion Number	nvarchar	5	0
55	OIUY6_WY_ROYTXN	Royalty 2.0 - WY - Royalty Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
56	OIUY6_WY_ROYTXNA	Royalty 2.0 - WY - Royalty Transactions (Allocated)	6	WC_NO	Well Completion Number	nvarchar	5	0
57	OIUY6_WY_RPDTM	Royalty 2.0 - WY - Lease/Unit Report Detail - Masters	8	WC_NO	Well Completion Number	nvarchar	5	0
58	OIU_RV_LOAD_OIL	Valuation Load Oil Transactions	5	WC_NO	Well Completion Number	nvarchar	5	0
TOPBalancing
59	OIUBL01_ADJ	Balancing Adjustments	3	WC_NO	Well Completion Number	nvarchar	5	0
60	OIUBL01_ADJH	Balancing Adjustments History	3	WC_NO	Well Completion Number	nvarchar	5	0
61	OIUBL01_PBADOI	PBA DOI	4	WC_NO	Well Completion Number	nvarchar	5	0
62	OIUBL01_PBAXREF	PBA to Well Completion/Measurement Point Cross-ref	4	WC_NO	Well Completion Number	nvarchar	5	0
63	OIUBL01_RPTPH	Balancing Permanent Report Header	5	WC_NO	Well Completion Number	nvarchar	5	0
64	OIUBL_IMBWC	Well Completion Imbalance	4	WC_NO	Well Completion Number	nvarchar	5	0
65	OIUBL_PBAWC	Cross Reference for Well Completion and PBA	3	WC_NO	Well Completion Number	nvarchar	5	0
66	OIU_SB_SPEWC_T	Special owner entitlements at WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
TOPCheck Input
67	OIUCI_JE	Incoming Check Journalized. Temporary hold	57	WC_NO	Well Completion ID	nvarchar	2	0
TOPCheck Write
68	OIUCW_PAYMENT	Payment Details from Payment Run	42	WC_NO	Well Completion ID	nvarchar	2	0
69	OIU_CW_SUM_PAY	Summarized Payable Table for Check Write	22	WC_NO	Well Completion ID	nvarchar	2	0
TOPContractual Allocation
70	OIUCA_CTWC	PRA: Transporter Contract Well Completion XRef	5	WC_NO	Well Completion Number	nvarchar	5	0
71	OIUCA_OSP	Termination Point Component Options for Selective Process.	4	WC_NO	Well Completion Number	nvarchar	5	0
72	OIUCA_PRPH	Stores the Percent Returned to Producer Header Data	6	WC_NO	Well Completion Number	nvarchar	5	0
TOPProduct Control
73	OIUPC_AVGDWC	Stores the well completion capacity points	4	WC_NO	Well Completion Number	nvarchar	5	0
74	OIUPC_AVGHWC	Stores the well completion availability points	4	WC_NO	Well Completion Number	nvarchar	5	0
TOPProduction
75	OIUPR_SSD	Supply Source Detail	6	WC_NO	Well Completion Number	nvarchar	5	0
76	OIUPR_SSH	Supply Source Header	6	WC_NO	Well Completion Number	nvarchar	5	0
77	OIUPR_WCDPS	Well Completion Daily Pressures	3	WC_NO	Well Completion Number	nvarchar	5	0
TOPProduction and Revenue Accounting
78	OIUP_PR_WCDVLH	WC Disposition Volumes Header (PDM Shadow)	6	WC_NO	Well Completion Number	nvarchar	5	0
79	OIUP_PR_WCTST	Well Test (PDM Shadow)	6	WC_NO	Well Completion Number	nvarchar	5	0
80	OIUP_SB_ACTWC	Actual Owner Level CA results at WC's (PDM Shadow)	5	WC_NO	Well Completion Number	nvarchar	5	0
81	OIUP_SB_ENTWC	WC level owner entitlements (PDM Shadow)	6	WC_NO	Well Completion Number	nvarchar	5	0
82	OIUP_SB_RNAWC	Residue and NGL actual at a WC level (PDM Shadow)	5	WC_NO	Well Completion Number	nvarchar	5	0
83	OIUP_SB_RNEWC	Residue and NGL entitlements at a WC level (PDM Shadow)	5	WC_NO	Well Completion Number	nvarchar	5	0
84	OIUREP_ENTTY_LOG	Log table for master data entity changes	10	WC_NO	Well Completion Number	nvarchar	5	0
85	OIUREP_TAXBACKUP	Backup tax table for old tax reporting SOL	5	WC_NO	Well Completion Number	nvarchar	5	0
86	OIUREP_TIKBACKUP	Backup tik table for old tax reporting SOL	5	WC_NO	Well Completion Number	nvarchar	5	0
87	OIUX2_LNK_LOG	Tax Reporting log table for the link	9	WC_NO	Well Completion Number	nvarchar	5	0
88	OIUX2_RE_LOG	Tax Reporting log table for the Log	9	WC_NO	Well Completion Number	nvarchar	5	0
89	OIU_CM_HIER_ENT	PRA Hierarchy Node Entity	6	WC_NO	Well Completion Number	nvarchar	5	0
90	OIU_PR_NODE_WC	Delivery Network Node: Well Completion	4	WC_NO	Well Completion Number	nvarchar	5	0
91	OIU_PR_RRWC	Regulatory Reporting Reallocated Well Completions	3	WC_NO	Well Completion Number	nvarchar	5	0
92	OIU_PR_TWCDVH	Temporary Well Completion Volumes	5	WC_NO	Well Completion Number	nvarchar	5	0
93	OIU_PR_WC	PRA: Well Completion	3	WC_NO	Well Completion Number	nvarchar	5	0
94	OIU_PR_WCALB	PRA: Well Completion Allocation Base	3	WC_NO	Well Completion Number	nvarchar	5	0
95	OIU_PR_WCALF	WC Allocation Factor	5	WC_NO	Well Completion Number	nvarchar	5	0
96	OIU_PR_WCDHH	Downhole Commingled Well Completion	3	WC_NO	Well Completion Number	nvarchar	5	0
97	OIU_PR_WCDT	PRA: Well Completion Downtime	3	WC_NO	Well Completion Number	nvarchar	5	0
98	OIU_PR_WCDVLH	Well Completion Disposition Volumes Header	5	WC_NO	Well Completion Number	nvarchar	5	0
99	OIU_PR_WCHV	Well Completion Heading Value	3	WC_NO	Well Completion Number	nvarchar	5	0
100	OIU_PR_WCOLH	PRA: Well Completion Offset Lease	3	WC_NO	Well Completion Number	nvarchar	5	0
101	OIU_PR_WCRMAT	Well Completion Reproduced Materials	3	WC_NO	Well Completion Number	nvarchar	5	0
102	OIU_PR_WCSSD	Well Completion Supply Source Detail	6	WC_NO	Well Completion Number	nvarchar	5	0
103	OIU_PR_WCSSH	Well Completion Supply Source Dated Header	6	WC_NO	Well Completion Number	nvarchar	5	0
104	OIU_PR_WCTCM	PRA: Well Completion Theoretical Calculation Method	3	WC_NO	Well Completion Number	nvarchar	5	0
105	OIU_PR_WCTRNH	PRA: Well Completion Transporter Xref	3	WC_NO	Well Completion Number	nvarchar	5	0
106	OIU_PR_WCTST	Well Test	5	WC_NO	Well Completion Number	nvarchar	5	0
107	OIU_PR_WCVD	Well Completion Variable Data	3	WC_NO	Well Completion Number	nvarchar	5	0
108	OIU_PR_WC_MEAS	Well Completion Measurement	3	WC_NO	Well Completion Number	nvarchar	5	0
109	OIU_RV_CGPT	Contract General Price Terms	5	WC_NO	Well Completion Number	nvarchar	5	0
110	OIU_RV_CMCC	Contract Marketing Cost Control Header	5	WC_NO	Well Completion Number	nvarchar	5	0
111	OIU_RV_CPTR	Contract Product Tax Reimbursement Header	5	WC_NO	Well Completion Number	nvarchar	5	0
112	OIU_RV_MR_WC	Marketing Rate Header for WC	4	WC_NO	Well Completion Number	nvarchar	5	0
113	OIU_RV_MULT_DN	Multiple DN for same well	4	WC_NO	Well Completion Number	nvarchar	5	0
114	OIU_RV_RVT	Rejected Valuation Transactions	5	WC_NO	Well Completion Number	nvarchar	5	0
115	OIU_RV_TCLD	Tax Class	6	WC_NO	Well Completion Number	nvarchar	5	0
116	OIU_RV_VCR	Valuation Cross Reference	4	WC_NO	Well Completion Number	nvarchar	5	0
117	OIU_RV_VLRPT	Valuation Reporting	7	WC_NO	Well Completion Number	nvarchar	5	0
118	OIU_RV_VLRVS	Valuation Reversal Notificaton	5	WC_NO	Well Completion Number	nvarchar	5	0
119	OIU_RV_VLTXNS	Valuation Transactions	4	WC_NO	Well Completion Number	nvarchar	5	0
120	OIU_RV_VPPN	Valuation Prior Period Notification	5	WC_NO	Well Completion Number	nvarchar	5	0
121	OIU_RV_VPPNM	Manually Created Valuation Prior Period Notifications	5	WC_NO	Well Completion Number	nvarchar	5	0
122	OIU_RV_VPPNU	Valuation Prior Period Notification	5	WC_NO	Well Completion Number	nvarchar	5	0
123	OIU_RV_VXDS	Valuation Cross Reference Date Stamp	5	WC_NO	Well Completion Number	nvarchar	5	0
124	OIU_SB_ACRH	header table for the Allocation Cross Reference	5	WC_NO	Well Completion Number	nvarchar	5	0
125	OIU_SB_ACTWC	Actual Owner Level Contractual Allocations results at WC's	4	WC_NO	Well Completion Number	nvarchar	5	0
126	OIU_SB_ACTWC_T	Actual Owner Level Contractual Allocations results at WC's	4	WC_NO	Well Completion Number	nvarchar	5	0
127	OIU_SB_AVWC	Availability Well Completion	4	WC_NO	Well Completion Number	nvarchar	5	0
128	OIU_SB_CAPWC	Capacity Well Completion	4	WC_NO	Well Completion Number	nvarchar	5	0
129	OIU_SB_CTRWC	Volumes for sale	5	WC_NO	Well Completion Number	nvarchar	5	0
130	OIU_SB_CTRWC_T	Volumes for sale	5	WC_NO	Well Completion Number	nvarchar	5	0
131	OIU_SB_DOIWC	DOI/WC Cross Reference	3	WC_NO	Well Completion Number	nvarchar	5	0
132	OIU_SB_ENTWC	WC level owner entitlements	5	WC_NO	Well Completion Number	nvarchar	5	0
133	OIU_SB_ENTWC_T	WC level owner entitlements	5	WC_NO	Well Completion Number	nvarchar	5	0
134	OIU_SB_MGOPWC	Marketing Group Owner Percent WC	6	WC_NO	Well Completion Number	nvarchar	5	0
135	OIU_SB_MGOPWC_T	Marketing Group Owner Percent WC	6	WC_NO	Well Completion Number	nvarchar	5	0
136	OIU_SB_OAHWC	Owner Availability Header: Well Completions	4	WC_NO	Well Completion Number	nvarchar	5	0
137	OIU_SB_RNAWC	Residue and NGL actual at a WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
138	OIU_SB_RNAWC_T	Temporary Residue and NGL actual at a WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
139	OIU_SB_RNEWC	Residue and NGL entitlements at a WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
140	OIU_SB_RNEWC_T	Temporary Residue and NGL entitlements at a WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
141	OIU_SB_SPEWC	Special owner entitlements at WC level	4	WC_NO	Well Completion Number	nvarchar	5	0
TOPRevenue
142	OIUE1_LSSL_SUM	Legal Suspense Summary	26	WC_NO	Well Completion Number	nvarchar	2	0
143	OIUE2_ESCH_DTL	Proc 2.0 - Escheat - Owner Details	27	WC_NO	Well Completion Number	nvarchar	2	0
144	OIUE2_ESCH_DTLH	Proc 2.0 - Escheat - Owner Detail History	27	WC_NO	Well Completion Number	nvarchar	2	0
145	OIUE2_ESCROW_DTL	Proc 2.0 - WY Escrow - Owner Details	27	WC_NO	Well Completion Number	nvarchar	2	0
146	OIUE2_JEINTF	Proc 2.0 - JE Interface Table	58	WC_NO	Well Completion ID	nvarchar	2	0
147	OIUH_RV_ARINTF	PRA Journal Entries to A/R interface table	56	WC_NO	Well Completion ID	nvarchar	2	0
148	OIUH_RV_JEINTF	PRA Journal Entries	57	WC_NO	Well Completion ID	nvarchar	2	0
149	OIURV03_DOCMPXRF	VL Doc to MP XRef	9	WC_NO	Well Completion Number	nvarchar	5	0
150	OIURV03_DTL_BK	Valuation Transactions Level 1 - Vltxns	7	WC_NO	Well Completion Number	nvarchar	5	0
151	OIURV03_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	10	WC_NO	Well Completion Number	nvarchar	5	0
152	OIURV03_MPWC_XRF	MP to Well Completion Split Out XRef	8	WC_NO	Well Completion Number	nvarchar	5	0
TOPRoyalty Reporting
153	OIUREPP_WCPAYXRF	MMS-2014 - Well Completion / Payor XRef PPA	3	WC_NO	Well Completion Number	nvarchar	5	0
154	OIUREP_MASTER	Regulatory Reporting Master Data	5	WC_NO	Well Completion Number	nvarchar	5	0
155	OIUREP_MMS_REJS	MMS-2014 - Extraction Rejects	20	WC_NO	Well Completion Number	nvarchar	5	0
156	OIUREP_ROY_DATA	Reported Royalty and Volume Data by Reporting Entities	10	WC_NO	Well Completion Number	nvarchar	5	0
157	OIUREP_RPT_ENTTY	Entities for Royalty Reporting	9	WC_NO	Well Completion Number	nvarchar	5	0
158	OIUREP_RTPEND	MMS-2014 - Royalty Transaction Pending	19	WC_NO	Well Completion Number	nvarchar	5	0
159	OIUREP_RT_HIST	MMS-2014 - Royalty Transaction (Pending) History	19	WC_NO	Well Completion Number	nvarchar	5	0
160	OIUREP_RWC	WCs that have been changed since previous report run	5	WC_NO	Well Completion Number	nvarchar	5	0
161	OIUREP_VL_VOL	Gross Volume and Value after VL/RD	7	WC_NO	Well Completion Number	nvarchar	5	0
162	OIUREP_VOL_DATA	Reported Volume Data by Reporting Entities	10	WC_NO	Well Completion Number	nvarchar	5	0
163	OIUREP_WCOWNERS	MMS-2014 - Well Completion w/ Multiple Owners	3	WC_NO	Well Completion Number	nvarchar	5	0
164	OIUREP_WCPAYXREF	MMS-2014 - Well Completion / Payor XRef	3	WC_NO	Well Completion Number	nvarchar	5	0
TOPTax Reporting
165	OIUX1_ADJ_TAXHC	Tax adjustments header for reporting	7	WC_NO	Well Completion Number	nvarchar	5	0
166	OIUX1_LNK_REPUB	PUID and reporting entities link	9	WC_NO	Well Completion Number	nvarchar	5	0
167	OIUX1_MAS_REB	Reporting entities base table	9	WC_NO	Well Completion Number	nvarchar	5	0
168	OIUX1_RPT_TAXH	Tax transaction header for reporting	11	WC_NO	Well Completion Number	nvarchar	5	0
169	OIUX1_RPT_VOLH	Reported Volume Data by Reporting Entities	11	WC_NO	Well Completion Number	nvarchar	5	0
170	OIUX1_TAX_SUSP	Records for suspension	9	WC_NO	Well Completion Number	nvarchar	5	0
171	OIUX1_TRN_TAXHC	Tax transaction header for reporting	6	WC_NO	Well Completion Number	nvarchar	5	0
172	OIUX1_TRN_TAXHL	Tax transaction header for reporting	6	WC_NO	Well Completion Number	nvarchar	5	0
173	OIUX3Y_TX_MASTER	Tax Reporting - Texas Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
174	OIUX3Y_TX_MSTOVR	Tax Reporting - Texas Master Data Overrides	4	WC_NO	Well Completion Number	nvarchar	5	0
175	OIUX3_JEINTF	Tax Reporting - JE Interface Table	28	WC_NO	Well Completion ID	nvarchar	2	0
176	OIUX3_TX_ASU_DT	Tax Reporting - Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
177	OIUX3_TX_MASTER	Tax Reporting - Texas Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
178	OIUX3_TX_MSTOVR	Tax Reporting - Texas Master Data Overrides	4	WC_NO	Well Completion Number	nvarchar	5	0
179	OIUX3_TX_OOSHST	Tax Reporting - Texas Out Of Statute Transaction History	6	WC_NO	Well Completion Number	nvarchar	5	0
180	OIUX3_TX_OOSTXN	Tax Reporting - Texas Out Of Statute Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
181	OIUX3_TX_PRDTB	Tax Reporting - Texas PRA Detail Txns-Tier Tax Below	7	WC_NO	Well Completion Number	nvarchar	5	0
182	OIUX3_TX_PRDTI	Tax Reporting - Texas PRA Detail Txns-Tier Tax Incremental	7	WC_NO	Well Completion Number	nvarchar	5	0
183	OIUX3_TX_PRDTN	Tax Reporting - Texas PRA Detail Txns - No Tier Tax	7	WC_NO	Well Completion Number	nvarchar	5	0
184	OIUX3_TX_REVSTG	Tax Reporting - Texas Tax Transaction Reversal Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
185	OIUX3_TX_REVTXN	Tax Reporting - Texas Tax Transaction Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
186	OIUX3_TX_TAXHST	Tax Reporting - Texas Tax History Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
187	OIUX3_TX_TAXSTG	Tax Reporting - Texas Tax Transaction Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
188	OIUX3_TX_TAXTXN	Tax Reporting - Texas Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
189	OIUX5Y_OK_MASTER	Tax 2.0 - Oklahoma Master Data PPN	3	WC_NO	Well Completion Number	nvarchar	5	0
190	OIUX5Y_OK_MSTCNT	Tax 2.0 - Oklahoma Master Data Counties	3	WC_NO	Well Completion Number	nvarchar	5	0
191	OIUX5_OK_ASU_DT	Tax 2.0 - Oklahoma Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
192	OIUX5_OK_MASTER	Tax 2.0 - Oklahoma Master Data	3	WC_NO	Well Completion Number	nvarchar	5	0
193	OIUX5_OK_MSTCNT	Tax 2.0 - Oklahoma Master Data Multiple Counties	3	WC_NO	Well Completion Number	nvarchar	5	0
194	OIUX5_OK_OOSHST	Tax 2.0 - Oklahoma Out Of Statute Transactions History	6	WC_NO	Well Completion Number	nvarchar	5	0
195	OIUX5_OK_OOSTXN	Tax 2.0 - Oklahoma Out Of Statute Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
196	OIUX5_OK_PRDT	Tax 2.0 - Oklahoma PRA Detail Tax Transactions	7	WC_NO	Well Completion Number	nvarchar	5	0
197	OIUX5_OK_PRDTC	Tax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count	7	WC_NO	Well Completion Number	nvarchar	5	0
198	OIUX5_OK_REVSTG	Tax 2.0 - Oklahoma Tax Reversals Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
199	OIUX5_OK_REVTXN	Tax 2.0 - Oklahoma Tax Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
200	OIUX5_OK_TAXHST	Tax 2.0 - Oklahoma Tax Transactions History	6	WC_NO	Well Completion Number	nvarchar	5	0
201	OIUX5_OK_TAXHSTC	Tax 2.0 - Oklahoma Tax Transactions History Multi-Counties	6	WC_NO	Well Completion Number	nvarchar	5	0
202	OIUX5_OK_TAXSTG	Tax 2.0 - Oklahoma Tax Transactions Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
203	OIUX5_OK_TAXTXN	Tax 2.0 - Oklahoma Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
204	OIUX5_OK_TAXTXNC	Tax 2.0 - Oklahoma Tax Transactions Multiple Counties	6	WC_NO	Well Completion Number	nvarchar	5	0
205	OIUX6Y_WY_MASTER	Tax 2.0 - Wyoming Master Data PPN	4	WC_NO	Well Completion Number	nvarchar	5	0
206	OIUX6_WY_ASU_DT	Tax 2.0 - Wyoming Auto Suspend Detail	7	WC_NO	Well Completion Number	nvarchar	5	0
207	OIUX6_WY_CAPRDT	Tax 2.0 - Wyoming Conservation CA PRA Detail Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
208	OIUX6_WY_CASTG	Tax 2.0 - Wyoming Conservation CA Transactions Staging	5	WC_NO	Well Completion Number	nvarchar	5	0
209	OIUX6_WY_CATXN	Tax 2.0 - Wyoming Conservation CA Transactions	5	WC_NO	Well Completion Number	nvarchar	5	0
210	OIUX6_WY_COOSHST	Tax 2.0 - Wyoming Out Of Statute Conservation Trans Hist	6	WC_NO	Well Completion Number	nvarchar	5	0
211	OIUX6_WY_COOSTXN	Tax 2.0 - Wyoming Out Of Statute Conservation Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
212	OIUX6_WY_CPRDT	Tax 2.0 - Wyoming Conservation Tax PRA Detail Transactions	7	WC_NO	Well Completion Number	nvarchar	5	0
213	OIUX6_WY_CREVSTG	Tax 2.0 - Wyoming Conservation Tax Reversals Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
214	OIUX6_WY_CREVTXN	Tax 2.0 - Wyoming Conservation Tax Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
215	OIUX6_WY_CTAXHST	Tax 2.0 - Wyoming Conservation Tax Transactions History	6	WC_NO	Well Completion Number	nvarchar	5	0
216	OIUX6_WY_CTAXSTG	Tax 2.0 - Wyoming Conservation Tax Transactions Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
217	OIUX6_WY_CTAXTXN	Tax 2.0 - Wyoming Conservation Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
218	OIUX6_WY_FORM2	Tax 2.0 - Wyoming Conservation Summarized FORM 2 Data	7	WC_NO	Well Completion Number	nvarchar	5	0
219	OIUX6_WY_GTAXSTG	Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
220	OIUX6_WY_GTAXTXN	Tax 2.0 - Wyoming Gross Prod Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
221	OIUX6_WY_LCDOVR	Tax 2.0 - Wyoming Lease Condensate Override	3	WC_NO	Well Completion Number	nvarchar	5	0
222	OIUX6_WY_MASTER	Tax 2.0 - Wyoming Master Data	4	WC_NO	Well Completion Number	nvarchar	5	0
223	OIUX6_WY_SOOSHST	Tax 2.0 - Wyoming Out Of Statute Severance Trans History	6	WC_NO	Well Completion Number	nvarchar	5	0
224	OIUX6_WY_SOOSTXN	Tax 2.0 - Wyoming Out Of Statute Severance Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
225	OIUX6_WY_SPRDT	Tax 2.0 - Wyoming Severance Tax PRA Detail Transactions	7	WC_NO	Well Completion Number	nvarchar	5	0
226	OIUX6_WY_SREVSTG	Tax 2.0 - Wyoming Severance Tax Reversals Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
227	OIUX6_WY_SREVTXN	Tax 2.0 - Wyoming Severance Tax Reversals	6	WC_NO	Well Completion Number	nvarchar	5	0
228	OIUX6_WY_STAXHST	Tax 2.0 - Wyoming Severance Tax Transactions History	6	WC_NO	Well Completion Number	nvarchar	5	0
229	OIUX6_WY_STAXSTG	Tax 2.0 - Wyoming Severance Tax Transactions Staging	6	WC_NO	Well Completion Number	nvarchar	5	0
230	OIUX6_WY_STAXTXN	Tax 2.0 - Wyoming Severance Tax Transactions	6	WC_NO	Well Completion Number	nvarchar	5	0
231	OIUX7_WY_GSALES	Tax 2.0 - WYGP Sales	6	WC_NO	Well Completion Number	nvarchar	5	0
232	OIUX7_WY_GSALHST	Tax 2.0 - WYGP Sales History	5	WC_NO	Well Completion Number	nvarchar	5	0
233	OIUX7_WY_GSALTXN	Tax 2.0 - WYGP Sales	5	WC_NO	Well Completion Number	nvarchar	5	0
234	OIUX7_WY_GTAX	Tax 2.0 - Wyoming Gross Prod Tax Transactions	7	WC_NO	Well Completion Number	nvarchar	5	0
235	OIUX7_WY_GTAXHST	Tax 2.0 - Wyoming Gross Prod Tax Transactions History	6	WC_NO	Well Completion Number	nvarchar	5	0
236	OIUX7_WY_GVOL	Tax 2.0 - WYGP Volume	6	WC_NO	Well Completion Number	nvarchar	5	0
237	OIUX7_WY_GVOLHST	Tax 2.0 - WYGP Volume History	5	WC_NO	Well Completion Number	nvarchar	5	0
238	OIUX7_WY_GVOLTXN	Tax 2.0 - WYGP Volumes	5	WC_NO	Well Completion Number	nvarchar	5	0
239	OIUX7_WY_MKTOVR	Tax 2.0 - WYGP Marketing Type Xref Override	3	WC_NO	Well Completion Number	nvarchar	5	0
TOPValuation
240	OIURV_CRH_HST	Combined Run Header History	11	WC_NO	OIUH_CHAR5	nvarchar	5	0
241	OIURV_DOC_DTL_BK	Valuation Transactions Level 1 - Vltxns	7	WC_NO	Well Completion Number	nvarchar	5	0
242	OIURV_DOC_DTL_RV	Valuation Reversal Notificaton	8	WC_NO	Well Completion Number	nvarchar	5	0
243	OIURV_DOC_DTL_ZE	Valuation Transactions Level 1 - Zero Volume	10	WC_NO	Well Completion Number	nvarchar	5	0
244	OIURV_DOC_JEINTF	Revenue Document Concept - JEINTF temp table	59	WC_NO	Well Completion ID	nvarchar	2	0
245	OIURV_DOC_MMSPOP	Dual Accounting MMS/POP	7	WC_NO	Well Completion ID	nvarchar	2	0
246	OIURV_DOC_OOBJE	Out Of Balance JEs	13	WC_NO	Well Completion ID	nvarchar	2	0
247	OIURV_DOC_RDSUM	RD summary(VL interface records to RD)	7	WC_NO	Well Completion Number	nvarchar	5	0
248	OIURV_DUAL_COMP	Dual Accounting Compare	8	WC_NO	Well Completion ID	nvarchar	2	0
249	OIURV_GASSTMTH	Gas Statement Header	8	WC_NO	Well Completion Number	nvarchar	5	0
250	OIUVL_OILSTMTH	Oil Statement Header	8	WC_NO	Well Completion Number	nvarchar	5	0
251	OIUVL_RPTD	Valuation report detail	7	WC_NO	Well Completion Number	nvarchar	5	0
252	OIUVL_SEVWC	Severance tax well completion	6	WC_NO	Well Completion Number	nvarchar	5	0
253	OIUVL_TCWC	Tax Class - Well Completion	3	WC_NO	Well Completion Number	nvarchar	5	0
254	OIUVL_TTRD	Tax Tier Rate - Data	3	WC_NO	Well Completion Number	nvarchar	5	0

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

254 columns | ERP 6.0 | WC_NO