SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

255 columns | Print definition?ERP 6.0  | WL_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_WCDTWell Completion Downtime Number3WL_NOwell numbernvarchar150
2CNVTDMS_5_WCDVLHfill hedaer for well completion5WL_NOwell numbernvarchar150
3OIUX6Y_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data PPN3WL_NOWell ID numbernvarchar150
4OIUX6_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data3WL_NOWell ID numbernvarchar150
5OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN3WL_NOWell ID numbernvarchar150
6OIUX8_NM_ASUE_DTTax 2.0 NM - Auto Suspend Exception Detail6WL_NOWell ID numbernvarchar150
7OIUX8_NM_ASU_DTTax 2.0 - NM - Auto Suspend Detail6WL_NOWell ID numbernvarchar150
8OIUX8_NM_MASTERTax 2.0 - NM - Master Data3WL_NOWell ID numbernvarchar150
9OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History5WL_NOWell ID numbernvarchar150
10OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions5WL_NOWell ID numbernvarchar150
11OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions6WL_NOWell ID numbernvarchar150
12OIUX8_NM_REVSTGTax 2.0 - NM - Tax Reversals (Staging)5WL_NOWell ID numbernvarchar150
13OIUX8_NM_REVTXNTax 2.0 - NM - Tax Reversals5WL_NOWell ID numbernvarchar150
14OIUX8_NM_SUFFDECTax 2.0 - New Mexico Suffix Decimal5WL_NOWell ID numbernvarchar150
15OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History5WL_NOWell ID numbernvarchar150
16OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)5WL_NOWell ID numbernvarchar150
17OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions5WL_NOWell ID numbernvarchar150
18OIUY3Y_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data PPN3WL_NOWell ID numbernvarchar150
19OIUY3Y_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master PPN3WL_NOWell ID numbernvarchar150
20OIUY3_TX_ASU_DTRoyalty 2.0 - TX GLO/TAMU - Auto Suspend Detail6WL_NOWell ID numbernvarchar150
21OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging9WL_NOWell ID numbernvarchar150
22OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface9WL_NOWell ID numbernvarchar150
23OIUY3_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data3WL_NOWell ID numbernvarchar150
24OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist5WL_NOWell ID numbernvarchar150
25OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions5WL_NOWell ID numbernvarchar150
26OIUY3_TX_PDCXRFRoyalty 2.0 - TX GLO/TAMU - Production Disposition XRef3WL_NOWell ID numbernvarchar150
27OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details6WL_NOWell ID numbernvarchar150
28OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)6WL_NOWell ID numbernvarchar150
29OIUY3_TX_RDCXRFRoyalty 2.0 - TX GLO/TAMU - Royalty Disposition XRef2WL_NOWell ID numbernvarchar150
30OIUY3_TX_REVSTGRoyalty 2.0 - TX GLO - Royalty Reversals (Staging)5WL_NOWell ID numbernvarchar150
31OIUY3_TX_REVTXNRoyalty 2.0 - TX GLO - Royalty Reversals5WL_NOWell ID numbernvarchar150
32OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History5WL_NOWell ID numbernvarchar150
33OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)5WL_NOWell ID numbernvarchar150
34OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)5WL_NOWell ID numbernvarchar150
35OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions5WL_NOWell ID numbernvarchar150
36OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)5WL_NOWell ID numbernvarchar150
37OIUY3_TX_RPDTMRoyalty 2.0 - TX GLO/TAMU - Report Detail - Masters8WL_NOWell ID numbernvarchar150
38OIUY3_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master3WL_NOWell ID numbernvarchar150
39OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN3WL_NOWell ID numbernvarchar150
40OIUY6_WY_ASU_DTRoyalty 2.0 - WY - Auto Suspend Detail6WL_NOWell ID numbernvarchar150
41OIUY6_WY_CAPOVRRoy 2.0 - Wyoming - CA Percent Override2WL_NOWell ID numbernvarchar150
42OIUY6_WY_CBMOVRRoyalty 2.0 - WY - Coal Bed Methane Override2WL_NOWell ID numbernvarchar150
43OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)9WL_NOWell ID numbernvarchar150
44OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface9WL_NOWell ID numbernvarchar150
45OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data3WL_NOWell ID numbernvarchar150
46OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist5WL_NOWell ID numbernvarchar150
47OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions5WL_NOWell ID numbernvarchar150
48OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details6WL_NOWell ID numbernvarchar150
49OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)6WL_NOWell ID numbernvarchar150
50OIUY6_WY_REVSTGRoyalty 2.0 - WY - Royalty Reversals (Staging)5WL_NOWell ID numbernvarchar150
51OIUY6_WY_REVTXNRoyalty 2.0 - WY - Royalty Reversals5WL_NOWell ID numbernvarchar150
52OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History5WL_NOWell ID numbernvarchar150
53OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)5WL_NOWell ID numbernvarchar150
54OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)5WL_NOWell ID numbernvarchar150
55OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions5WL_NOWell ID numbernvarchar150
56OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)5WL_NOWell ID numbernvarchar150
57OIUY6_WY_RPDTMRoyalty 2.0 - WY - Lease/Unit Report Detail - Masters7WL_NOWell ID numbernvarchar150
58OIU_RV_LOAD_OILValuation Load Oil Transactions4WL_NOWell ID numbernvarchar150
TOPBalancing
59OIUBL01_ADJBalancing Adjustments2WL_NOWell ID numbernvarchar150
60OIUBL01_ADJHBalancing Adjustments History2WL_NOWell ID numbernvarchar150
61OIUBL01_PBADOIPBA DOI3WL_NOWell ID numbernvarchar150
62OIUBL01_PBAXREFPBA to Well Completion/Measurement Point Cross-ref3WL_NOWell ID numbernvarchar150
63OIUBL01_RPTPHBalancing Permanent Report Header4WL_NOWell ID numbernvarchar150
64OIUBL_IMBWCWell Completion Imbalance3WL_NOWell ID numbernvarchar150
65OIUBL_PBAWCCross Reference for Well Completion and PBA2WL_NOWell ID numbernvarchar150
66OIU_SB_SPEWC_TSpecial owner entitlements at WC level3WL_NOWell ID numbernvarchar150
TOPCheck Input
67OIUCI_JEIncoming Check Journalized. Temporary hold56WL_NOWell ID Numbernvarchar60
TOPCheck Write
68OIUCW_PAYMENTPayment Details from Payment Run41WL_NOWell ID Numbernvarchar60
69OIU_CW_SUM_PAYSummarized Payable Table for Check Write21WL_NOWell ID Numbernvarchar60
TOPContractual Allocation
70OIUCA_CTWCPRA: Transporter Contract Well Completion XRef4WL_NOWell ID numbernvarchar150
71OIUCA_OSPTermination Point Component Options for Selective Process.3WL_NOWell ID numbernvarchar150
72OIUCA_PRPHStores the Percent Returned to Producer Header Data5WL_NOWell ID numbernvarchar150
TOPProduct Control
73OIUPC_AVGDWCStores the well completion capacity points3WL_NOWell ID numbernvarchar150
74OIUPC_AVGHWCStores the well completion availability points3WL_NOWell ID numbernvarchar150
TOPProduction
75OIUPR_SSDSupply Source Detail5WL_NOWell ID numbernvarchar150
76OIUPR_SSHSupply Source Header5WL_NOWell ID numbernvarchar150
77OIUPR_WCDPSWell Completion Daily Pressures2WL_NOWell ID numbernvarchar150
TOPProduction and Revenue Accounting
78OIUP_PR_WCDVLHWC Disposition Volumes Header (PDM Shadow)5WL_NOWell ID numbernvarchar150
79OIUP_PR_WCTSTWell Test (PDM Shadow)5WL_NOWell ID numbernvarchar150
80OIUP_SB_ACTWCActual Owner Level CA results at WC's (PDM Shadow)4WL_NOWell ID numbernvarchar150
81OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)5WL_NOWell ID numbernvarchar150
82OIUP_SB_RNAWCResidue and NGL actual at a WC level (PDM Shadow)4WL_NOWell ID numbernvarchar150
83OIUP_SB_RNEWCResidue and NGL entitlements at a WC level (PDM Shadow)4WL_NOWell ID numbernvarchar150
84OIUREP_ENTTY_LOGLog table for master data entity changes9WL_NOWell ID numbernvarchar150
85OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL4WL_NOWell ID numbernvarchar150
86OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL4WL_NOWell ID numbernvarchar150
87OIUX2_LNK_LOGTax Reporting log table for the link8WL_NOWell ID numbernvarchar150
88OIUX2_RE_LOGTax Reporting log table for the Log8WL_NOWell ID numbernvarchar150
89OIU_CM_HIER_ENTPRA Hierarchy Node Entity5WL_NOWell ID numbernvarchar150
90OIU_PR_NODE_WCDelivery Network Node: Well Completion3WL_NOWell ID numbernvarchar150
91OIU_PR_RRWCRegulatory Reporting Reallocated Well Completions2WL_NOWell ID numbernvarchar150
92OIU_PR_TWCDVHTemporary Well Completion Volumes4WL_NOWell ID numbernvarchar150
93OIU_PR_WCPRA: Well Completion2WL_NOWell ID numbernvarchar150
94OIU_PR_WCALBPRA: Well Completion Allocation Base2WL_NOWell ID numbernvarchar150
95OIU_PR_WCALFWC Allocation Factor4WL_NOWell ID numbernvarchar150
96OIU_PR_WCDHHDownhole Commingled Well Completion2WL_NOWell ID numbernvarchar150
97OIU_PR_WCDTPRA: Well Completion Downtime2WL_NOWell ID numbernvarchar150
98OIU_PR_WCDVLHWell Completion Disposition Volumes Header4WL_NOWell ID numbernvarchar150
99OIU_PR_WCHVWell Completion Heading Value2WL_NOWell ID numbernvarchar150
100OIU_PR_WCOLHPRA: Well Completion Offset Lease2WL_NOWell ID numbernvarchar150
101OIU_PR_WCRMATWell Completion Reproduced Materials2WL_NOWell ID numbernvarchar150
102OIU_PR_WCSSDWell Completion Supply Source Detail5WL_NOWell ID numbernvarchar150
103OIU_PR_WCSSHWell Completion Supply Source Dated Header5WL_NOWell ID numbernvarchar150
104OIU_PR_WCTCMPRA: Well Completion Theoretical Calculation Method2WL_NOWell ID numbernvarchar150
105OIU_PR_WCTRNHPRA: Well Completion Transporter Xref2WL_NOWell ID numbernvarchar150
106OIU_PR_WCTSTWell Test4WL_NOWell ID numbernvarchar150
107OIU_PR_WCVDWell Completion Variable Data2WL_NOWell ID numbernvarchar150
108OIU_PR_WC_MEASWell Completion Measurement2WL_NOWell ID numbernvarchar150
109OIU_PR_WELLPRA: Well2WL_NOWell ID numbernvarchar150
110OIU_RV_CGPTContract General Price Terms4WL_NOWell ID numbernvarchar150
111OIU_RV_CMCCContract Marketing Cost Control Header4WL_NOWell ID numbernvarchar150
112OIU_RV_CPTRContract Product Tax Reimbursement Header4WL_NOWell ID numbernvarchar150
113OIU_RV_MR_WCMarketing Rate Header for WC3WL_NOWell ID numbernvarchar150
114OIU_RV_MULT_DNMultiple DN for same well3WL_NOWell ID numbernvarchar150
115OIU_RV_RVTRejected Valuation Transactions4WL_NOWell ID numbernvarchar150
116OIU_RV_TCLDTax Class5WL_NOWell ID numbernvarchar150
117OIU_RV_VCRValuation Cross Reference3WL_NOWell ID numbernvarchar150
118OIU_RV_VLRPTValuation Reporting6WL_NOWell ID numbernvarchar150
119OIU_RV_VLRVSValuation Reversal Notificaton4WL_NOWell ID numbernvarchar150
120OIU_RV_VLTXNSValuation Transactions3WL_NOWell ID numbernvarchar150
121OIU_RV_VPPNValuation Prior Period Notification4WL_NOWell ID numbernvarchar150
122OIU_RV_VPPNMManually Created Valuation Prior Period Notifications4WL_NOWell ID numbernvarchar150
123OIU_RV_VPPNUValuation Prior Period Notification4WL_NOWell ID numbernvarchar150
124OIU_RV_VXDSValuation Cross Reference Date Stamp4WL_NOWell ID numbernvarchar150
125OIU_SB_ACRHheader table for the Allocation Cross Reference4WL_NOWell ID numbernvarchar150
126OIU_SB_ACTWCActual Owner Level Contractual Allocations results at WC's3WL_NOWell ID numbernvarchar150
127OIU_SB_ACTWC_TActual Owner Level Contractual Allocations results at WC's3WL_NOWell ID numbernvarchar150
128OIU_SB_AVWCAvailability Well Completion3WL_NOWell ID numbernvarchar150
129OIU_SB_CAPWCCapacity Well Completion3WL_NOWell ID numbernvarchar150
130OIU_SB_CTRWCVolumes for sale4WL_NOWell ID numbernvarchar150
131OIU_SB_CTRWC_TVolumes for sale4WL_NOWell ID numbernvarchar150
132OIU_SB_DOIWCDOI/WC Cross Reference2WL_NOWell ID numbernvarchar150
133OIU_SB_ENTWCWC level owner entitlements4WL_NOWell ID numbernvarchar150
134OIU_SB_ENTWC_TWC level owner entitlements4WL_NOWell ID numbernvarchar150
135OIU_SB_MGOPWCMarketing Group Owner Percent WC5WL_NOWell ID numbernvarchar150
136OIU_SB_MGOPWC_TMarketing Group Owner Percent WC5WL_NOWell ID numbernvarchar150
137OIU_SB_OAHWCOwner Availability Header: Well Completions3WL_NOWell ID numbernvarchar150
138OIU_SB_RNAWCResidue and NGL actual at a WC level3WL_NOWell ID numbernvarchar150
139OIU_SB_RNAWC_TTemporary Residue and NGL actual at a WC level3WL_NOWell ID numbernvarchar150
140OIU_SB_RNEWCResidue and NGL entitlements at a WC level3WL_NOWell ID numbernvarchar150
141OIU_SB_RNEWC_TTemporary Residue and NGL entitlements at a WC level3WL_NOWell ID numbernvarchar150
142OIU_SB_SPEWCSpecial owner entitlements at WC level3WL_NOWell ID numbernvarchar150
TOPRevenue
143OIUE1_LSSL_SUMLegal Suspense Summary25WL_NOWell Numbernvarchar60
144OIUE2_ESCH_DTLProc 2.0 - Escheat - Owner Details26WL_NOWell Numbernvarchar60
145OIUE2_ESCH_DTLHProc 2.0 - Escheat - Owner Detail History26WL_NOWell Numbernvarchar60
146OIUE2_ESCROW_DTLProc 2.0 - WY Escrow - Owner Details26WL_NOWell Numbernvarchar60
147OIUE2_JEINTFProc 2.0 - JE Interface Table57WL_NOWell ID Numbernvarchar60
148OIUH_RV_ARINTFPRA Journal Entries to A/R interface table55WL_NOWell ID Numbernvarchar60
149OIUH_RV_JEINTFPRA Journal Entries56WL_NOWell ID Numbernvarchar60
150OIURV03_DOCMPXRFVL Doc to MP XRef8WL_NOWell ID numbernvarchar150
151OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns6WL_NOWell ID numbernvarchar150
152OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume9WL_NOWell ID numbernvarchar150
153OIURV03_MPWC_XRFMP to Well Completion Split Out XRef7WL_NOWell ID numbernvarchar150
TOPRoyalty Reporting
154OIUREPP_WCPAYXRFMMS-2014 - Well Completion / Payor XRef PPA2WL_NOWell ID numbernvarchar150
155OIUREP_MASTERRegulatory Reporting Master Data4WL_NOWell ID numbernvarchar150
156OIUREP_MMS_REJSMMS-2014 - Extraction Rejects19WL_NOWell ID numbernvarchar150
157OIUREP_ROY_DATAReported Royalty and Volume Data by Reporting Entities9WL_NOWell ID numbernvarchar150
158OIUREP_RPT_ENTTYEntities for Royalty Reporting8WL_NOWell ID numbernvarchar150
159OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending18WL_NOWell ID numbernvarchar150
160OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History18WL_NOWell ID numbernvarchar150
161OIUREP_RWCWCs that have been changed since previous report run4WL_NOWell ID numbernvarchar150
162OIUREP_VL_VOLGross Volume and Value after VL/RD6WL_NOWell ID numbernvarchar150
163OIUREP_VOL_DATAReported Volume Data by Reporting Entities9WL_NOWell ID numbernvarchar150
164OIUREP_WCOWNERSMMS-2014 - Well Completion w/ Multiple Owners2WL_NOWell ID numbernvarchar150
165OIUREP_WCPAYXREFMMS-2014 - Well Completion / Payor XRef2WL_NOWell ID numbernvarchar150
TOPTax Reporting
166OIUX1_ADJ_TAXHCTax adjustments header for reporting6WL_NOWell ID numbernvarchar150
167OIUX1_LNK_REPUBPUID and reporting entities link8WL_NOWell ID numbernvarchar150
168OIUX1_MAS_REBReporting entities base table8WL_NOWell ID numbernvarchar150
169OIUX1_RPT_TAXHTax transaction header for reporting10WL_NOWell ID numbernvarchar150
170OIUX1_RPT_VOLHReported Volume Data by Reporting Entities10WL_NOWell ID numbernvarchar150
171OIUX1_TAX_SUSPRecords for suspension8WL_NOWell ID numbernvarchar150
172OIUX1_TRN_TAXHCTax transaction header for reporting5WL_NOWell ID numbernvarchar150
173OIUX1_TRN_TAXHLTax transaction header for reporting5WL_NOWell ID numbernvarchar150
174OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN3WL_NOWell ID numbernvarchar150
175OIUX3Y_TX_MSTOVRTax Reporting - Texas Master Data Overrides3WL_NOWell ID numbernvarchar150
176OIUX3_JEINTFTax Reporting - JE Interface Table27WL_NOWell ID Numbernvarchar60
177OIUX3_TX_ASU_DTTax Reporting - Auto Suspend Detail6WL_NOWell ID numbernvarchar150
178OIUX3_TX_MASTERTax Reporting - Texas Master Data3WL_NOWell ID numbernvarchar150
179OIUX3_TX_MSTOVRTax Reporting - Texas Master Data Overrides3WL_NOWell ID numbernvarchar150
180OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History5WL_NOWell ID numbernvarchar150
181OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions5WL_NOWell ID numbernvarchar150
182OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below6WL_NOWell ID numbernvarchar150
183OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental6WL_NOWell ID numbernvarchar150
184OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax6WL_NOWell ID numbernvarchar150
185OIUX3_TX_REVSTGTax Reporting - Texas Tax Transaction Reversal Staging5WL_NOWell ID numbernvarchar150
186OIUX3_TX_REVTXNTax Reporting - Texas Tax Transaction Reversals5WL_NOWell ID numbernvarchar150
187OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions5WL_NOWell ID numbernvarchar150
188OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging5WL_NOWell ID numbernvarchar150
189OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions5WL_NOWell ID numbernvarchar150
190OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN2WL_NOWell ID numbernvarchar150
191OIUX5Y_OK_MSTCNTTax 2.0 - Oklahoma Master Data Counties2WL_NOWell ID numbernvarchar150
192OIUX5_OK_ASU_DTTax 2.0 - Oklahoma Auto Suspend Detail6WL_NOWell ID numbernvarchar150
193OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data2WL_NOWell ID numbernvarchar150
194OIUX5_OK_MSTCNTTax 2.0 - Oklahoma Master Data Multiple Counties2WL_NOWell ID numbernvarchar150
195OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History5WL_NOWell ID numbernvarchar150
196OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions5WL_NOWell ID numbernvarchar150
197OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions6WL_NOWell ID numbernvarchar150
198OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count6WL_NOWell ID numbernvarchar150
199OIUX5_OK_REVSTGTax 2.0 - Oklahoma Tax Reversals Staging5WL_NOWell ID numbernvarchar150
200OIUX5_OK_REVTXNTax 2.0 - Oklahoma Tax Reversals5WL_NOWell ID numbernvarchar150
201OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History5WL_NOWell ID numbernvarchar150
202OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties5WL_NOWell ID numbernvarchar150
203OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging5WL_NOWell ID numbernvarchar150
204OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions5WL_NOWell ID numbernvarchar150
205OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties5WL_NOWell ID numbernvarchar150
206OIUX6Y_WY_MASTERTax 2.0 - Wyoming Master Data PPN3WL_NOWell ID numbernvarchar150
207OIUX6_WY_ASU_DTTax 2.0 - Wyoming Auto Suspend Detail6WL_NOWell ID numbernvarchar150
208OIUX6_WY_CAPRDTTax 2.0 - Wyoming Conservation CA PRA Detail Transactions5WL_NOWell ID numbernvarchar150
209OIUX6_WY_CASTGTax 2.0 - Wyoming Conservation CA Transactions Staging4WL_NOWell ID numbernvarchar150
210OIUX6_WY_CATXNTax 2.0 - Wyoming Conservation CA Transactions4WL_NOWell ID numbernvarchar150
211OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist5WL_NOWell ID numbernvarchar150
212OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions5WL_NOWell ID numbernvarchar150
213OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions6WL_NOWell ID numbernvarchar150
214OIUX6_WY_CREVSTGTax 2.0 - Wyoming Conservation Tax Reversals Staging5WL_NOWell ID numbernvarchar150
215OIUX6_WY_CREVTXNTax 2.0 - Wyoming Conservation Tax Reversals5WL_NOWell ID numbernvarchar150
216OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History5WL_NOWell ID numbernvarchar150
217OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging5WL_NOWell ID numbernvarchar150
218OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions5WL_NOWell ID numbernvarchar150
219OIUX6_WY_FORM2Tax 2.0 - Wyoming Conservation Summarized FORM 2 Data6WL_NOWell ID numbernvarchar150
220OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging5WL_NOWell ID numbernvarchar150
221OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions5WL_NOWell ID numbernvarchar150
222OIUX6_WY_LCDOVRTax 2.0 - Wyoming Lease Condensate Override2WL_NOWell ID numbernvarchar150
223OIUX6_WY_MASTERTax 2.0 - Wyoming Master Data3WL_NOWell ID numbernvarchar150
224OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History5WL_NOWell ID numbernvarchar150
225OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions5WL_NOWell ID numbernvarchar150
226OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions6WL_NOWell ID numbernvarchar150
227OIUX6_WY_SREVSTGTax 2.0 - Wyoming Severance Tax Reversals Staging5WL_NOWell ID numbernvarchar150
228OIUX6_WY_SREVTXNTax 2.0 - Wyoming Severance Tax Reversals5WL_NOWell ID numbernvarchar150
229OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History5WL_NOWell ID numbernvarchar150
230OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging5WL_NOWell ID numbernvarchar150
231OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions5WL_NOWell ID numbernvarchar150
232OIUX7_WY_GSALESTax 2.0 - WYGP Sales5WL_NOWell ID numbernvarchar150
233OIUX7_WY_GSALHSTTax 2.0 - WYGP Sales History4WL_NOWell ID numbernvarchar150
234OIUX7_WY_GSALTXNTax 2.0 - WYGP Sales4WL_NOWell ID numbernvarchar150
235OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions6WL_NOWell ID numbernvarchar150
236OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History5WL_NOWell ID numbernvarchar150
237OIUX7_WY_GVOLTax 2.0 - WYGP Volume5WL_NOWell ID numbernvarchar150
238OIUX7_WY_GVOLHSTTax 2.0 - WYGP Volume History4WL_NOWell ID numbernvarchar150
239OIUX7_WY_GVOLTXNTax 2.0 - WYGP Volumes4WL_NOWell ID numbernvarchar150
240OIUX7_WY_MKTOVRTax 2.0 - WYGP Marketing Type Xref Override2WL_NOWell ID numbernvarchar150
TOPValuation
241OIURV_CRH_HSTCombined Run Header History10WL_NOOIUH_CHAR15nvarchar150
242OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns6WL_NOWell ID numbernvarchar150
243OIURV_DOC_DTL_RVValuation Reversal Notificaton7WL_NOWell ID numbernvarchar150
244OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume9WL_NOWell ID numbernvarchar150
245OIURV_DOC_JEINTFRevenue Document Concept - JEINTF temp table58WL_NOWell ID Numbernvarchar60
246OIURV_DOC_MMSPOPDual Accounting MMS/POP6WL_NOWell ID Numbernvarchar60
247OIURV_DOC_OOBJEOut Of Balance JEs12WL_NOWell ID Numbernvarchar60
248OIURV_DOC_RDSUMRD summary(VL interface records to RD)6WL_NOWell ID numbernvarchar150
249OIURV_DUAL_COMPDual Accounting Compare7WL_NOWell ID Numbernvarchar60
250OIURV_GASSTMTHGas Statement Header7WL_NOWell ID numbernvarchar150
251OIUVL_OILSTMTHOil Statement Header7WL_NOWell ID numbernvarchar150
252OIUVL_RPTDValuation report detail6WL_NOWell ID numbernvarchar150
253OIUVL_SEVWCSeverance tax well completion5WL_NOWell ID numbernvarchar150
254OIUVL_TCWCTax Class - Well Completion2WL_NOWell ID numbernvarchar150
255OIUVL_TTRDTax Tier Rate - Data2WL_NOWell ID numbernvarchar150