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

224 columns | Print definition?ERP 6.0  | DOI_NO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1OIUX6Y_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
2OIUX6_WY_MSTPLTTax 2.0 - Wyoming Plant Master Data8DOI_NODivision of interest (DOI)nvarchar50
3OIUX8Y_NM_MASTERTax 2.0 - NM - Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
4OIUX8_NM_ASUE_DTTax 2.0 NM - Auto Suspend Exception Detail5DOI_NODivision of interest (DOI)nvarchar50
5OIUX8_NM_ASU_DTTax 2.0 - NM - Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
6OIUX8_NM_MASTERTax 2.0 - NM - Master Data8DOI_NODivision of interest (DOI)nvarchar50
7OIUX8_NM_OOSHSTTax 2.0 - NM - Out-Of-Statute Transaction History9DOI_NODivision of interest (DOI)nvarchar50
8OIUX8_NM_OOSTXNTax 2.0 - NM - Out-Of-Statute Transactions9DOI_NODivision of interest (DOI)nvarchar50
9OIUX8_NM_PRDTTax 2.0 - NM - PRA Detail Transactions10DOI_NODivision of interest (DOI)nvarchar50
10OIUX8_NM_REVSTGTax 2.0 - NM - Tax Reversals (Staging)9DOI_NODivision of interest (DOI)nvarchar50
11OIUX8_NM_REVTXNTax 2.0 - NM - Tax Reversals9DOI_NODivision of interest (DOI)nvarchar50
12OIUX8_NM_TAXHSTTax 2.0 - NM - Tax Transaction History9DOI_NODivision of interest (DOI)nvarchar50
13OIUX8_NM_TAXSTGTax 2.0 - NM - Tax Transactions (Staging)9DOI_NODivision of interest (DOI)nvarchar50
14OIUX8_NM_TAXTXNTax 2.0 - NM - Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
15OIUY3Y_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
16OIUY3Y_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master PPN8DOI_NODivision of interest (DOI)nvarchar50
17OIUY3_TX_ASU_DTRoyalty 2.0 - TX GLO/TAMU - Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
18OIUY3_TX_INTSTGRoyalty 2.0 - TX GLO - Royalty Trans Interface Staging13DOI_NODivision of interest (DOI)nvarchar50
19OIUY3_TX_INTTXNRoyalty 2.0 - TX GLO/TAMU - Royalty Transaction Interface13DOI_NODivision of interest (DOI)nvarchar50
20OIUY3_TX_MASTERRoyalty 2.0 - TX GLO/TAMU - Master Data8DOI_NODivision of interest (DOI)nvarchar50
21OIUY3_TX_OOSHSTRoyalty 2.0 - TX - Out of Statute Royalty Transaction Hist9DOI_NODivision of interest (DOI)nvarchar50
22OIUY3_TX_OOSTXNRoyalty 2.0 - TX GLO - Out of Statute Royalty Transactions9DOI_NODivision of interest (DOI)nvarchar50
23OIUY3_TX_OPSLRoy 2.0 TX - OPSL Summary Data for a Run5DOI_NODivision of interest (DOI)nvarchar50
24OIUY3_TX_OWNOVRRoyalty 2.0 - TX GLO/TAMU Owner Level Reporting Override4DOI_NODivision of interest (DOI)nvarchar50
25OIUY3_TX_PRDTRoyalty 2.0 - TX GLO - Royalty PRA Details10DOI_NODivision of interest (DOI)nvarchar50
26OIUY3_TX_PRDTARoyalty 2.0 - TX GLO - Royalty PRA Details (Allocated)10DOI_NODivision of interest (DOI)nvarchar50
27OIUY3_TX_REVSTGRoyalty 2.0 - TX GLO - Royalty Reversals (Staging)9DOI_NODivision of interest (DOI)nvarchar50
28OIUY3_TX_REVTXNRoyalty 2.0 - TX GLO - Royalty Reversals9DOI_NODivision of interest (DOI)nvarchar50
29OIUY3_TX_ROYHSTRoyalty 2.0 - TX GLO - Royalty Transaction History9DOI_NODivision of interest (DOI)nvarchar50
30OIUY3_TX_ROYHSTARoyalty 2.0 - TX GLO - Royalty Trans History (Allocated)9DOI_NODivision of interest (DOI)nvarchar50
31OIUY3_TX_ROYSTGRoyalty 2.0 - TX GLO - Royalty Transactions (Staging)9DOI_NODivision of interest (DOI)nvarchar50
32OIUY3_TX_ROYTXNRoyalty 2.0 - TX GLO - Royalty Transactions9DOI_NODivision of interest (DOI)nvarchar50
33OIUY3_TX_ROYTXNARoyalty 2.0 - TX GLO - Royalty Transactions (Allocated)9DOI_NODivision of interest (DOI)nvarchar50
34OIUY3_TX_RPDTMRoyalty 2.0 - TX GLO/TAMU - Report Detail - Masters13DOI_NODivision of interest (DOI)nvarchar50
35OIUY3_TX_RRCRoyalty 2.0 - TX GLO/TAMU - RRC Master8DOI_NODivision of interest (DOI)nvarchar50
36OIUY6Y_WY_MASTERRoyalty 2.0 - WY - Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
37OIUY6_WY_ASU_DTRoyalty 2.0 - WY - Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
38OIUY6_WY_CBMOVRRoyalty 2.0 - WY - Coal Bed Methane Override7DOI_NODivision of interest (DOI)nvarchar50
39OIUY6_WY_INTSTGRoyalty 2.0 - WY - Royalty Transaction Interface (Staging)13DOI_NODivision of interest (DOI)nvarchar50
40OIUY6_WY_INTTXNRoyalty 2.0 - WY - Royalty Transaction Interface13DOI_NODivision of interest (DOI)nvarchar50
41OIUY6_WY_MASTERRoyalty 2.0 - WY - Master Data8DOI_NODivision of interest (DOI)nvarchar50
42OIUY6_WY_OOSHSTRoyalty 2.0 - WY - Out of Statute Royalty Transaction Hist9DOI_NODivision of interest (DOI)nvarchar50
43OIUY6_WY_OOSTXNRoyalty 2.0 - WY - Out of Statute Royalty Transactions9DOI_NODivision of interest (DOI)nvarchar50
44OIUY6_WY_OPSLRoy 2.0 WY - OPSL Summary Data for a Run5DOI_NODivision of interest (DOI)nvarchar50
45OIUY6_WY_PRDTRoyalty 2.0 - WY - Royalty PRA Details10DOI_NODivision of interest (DOI)nvarchar50
46OIUY6_WY_PRDTARoyalty 2.0 - WY - Royalty PRA Details (Allocated)10DOI_NODivision of interest (DOI)nvarchar50
47OIUY6_WY_REVSTGRoyalty 2.0 - WY - Royalty Reversals (Staging)9DOI_NODivision of interest (DOI)nvarchar50
48OIUY6_WY_REVTXNRoyalty 2.0 - WY - Royalty Reversals9DOI_NODivision of interest (DOI)nvarchar50
49OIUY6_WY_ROYHSTRoyalty 2.0 - WY - Royalty Transaction History9DOI_NODivision of interest (DOI)nvarchar50
50OIUY6_WY_ROYHSTARoyalty 2.0 - WY - Royalty Transaction History (Allocated)9DOI_NODivision of interest (DOI)nvarchar50
51OIUY6_WY_ROYSTGRoyalty 2.0 - WY - Royalty Transactions (Staging)9DOI_NODivision of interest (DOI)nvarchar50
52OIUY6_WY_ROYTXNRoyalty 2.0 - WY - Royalty Transactions9DOI_NODivision of interest (DOI)nvarchar50
53OIUY6_WY_ROYTXNARoyalty 2.0 - WY - Royalty Transactions (Allocated)9DOI_NODivision of interest (DOI)nvarchar50
54OIUY6_WY_RPDTMRoyalty 2.0 - WY - Lease/Unit Report Detail - Masters12DOI_NODivision of interest (DOI)nvarchar50
55OIU_RV_LOAD_OILValuation Load Oil Transactions10DOI_NODivision of interest (DOI)nvarchar50
TOPBalancing
56OIUBL01_PBADOIPBA DOI9DOI_NODivision of interest (DOI)nvarchar50
TOPCheck Input
57OIUCI_PDXPurchaser DOI Cross Reference18DOI_NODivision of Interest (DOI) Numbernvarchar50
TOPOwnership
58OIUOW_DLDDOI Legal Description Table4DOI_NODivision of interest (DOI)nvarchar50
59OIUOW_DOH_WKOwnership History Workable5DOI_NODivision of interest (DOI)nvarchar50
60OIUOW_DORHDO Owner Request History6DOI_NODivision of interest (DOI)nvarchar50
61OIUOW_DTCSDOI Transfer Change Select6DOI_NODivision of interest (DOI)nvarchar50
62OIUOW_ESTDTEscheated Transfer Date4DOI_NODivision of interest (DOI)nvarchar50
63OIUOW_ESTDT_WKEscheated Transfer Date Worktable4DOI_NODivision of interest (DOI)nvarchar50
64OIUOW_INTOHInterface Owner Header6DOI_NODivision of interest (DOI)nvarchar50
65OIUOW_INTOH_WKInterface Owner Header Worktable6DOI_NODivision of interest (DOI)nvarchar50
66OIUOW_RETDTRoyalty Escrow Transfer Date4DOI_NODivision of interest (DOI)nvarchar50
67OIUOW_RETDT_WKRoyalty Escrow Transfer Date4DOI_NODivision of interest (DOI)nvarchar50
68OIUOW_RTDRD DOI Transferee Detail13DOI_NODivision of interest (DOI)nvarchar50
69OIUOW_RTD_WKRD DOI Transferee Detail Worktable13DOI_NODivision of interest (DOI)nvarchar50
70OIUOW_TR_WKTract Information - work table6DOI_NODivision of interest (DOI)nvarchar50
TOPProduction and Revenue Accounting
71OIUP_SB_ENTMPMP level owner entitlements (PDM Shadow)8DOI_NODivision of interest (DOI)nvarchar50
72OIUP_SB_ENTWCWC level owner entitlements (PDM Shadow)9DOI_NODivision of interest (DOI)nvarchar50
73OIUREP_ENTTY_LOGLog table for master data entity changes8DOI_NODivision of interest (DOI)nvarchar50
74OIUREP_TAXBACKUPBackup tax table for old tax reporting SOL12DOI_NODivision of interest (DOI)nvarchar50
75OIUREP_TIKBACKUPBackup tik table for old tax reporting SOL12DOI_NODivision of interest (DOI)nvarchar50
76OIUT2_INT_FDNObsolete: Funds Delete Notification Control4DOI_NODivision of interest (DOI)nvarchar50
77OIUX2_LNK_LOGTax Reporting log table for the link7DOI_NODivision of interest (DOI)nvarchar50
78OIUX2_RE_LOGTax Reporting log table for the Log7DOI_NODivision of interest (DOI)nvarchar50
79OIUXI_INT_FDNFunds Delete Notification Control4DOI_NODivision of interest (DOI)nvarchar50
80OIU_CM_HIER_ENTPRA Hierarchy Node Entity10DOI_NODivision of interest (DOI)nvarchar50
81OIU_DO_BGUCBearer Group Use Control4DOI_NODivision of interest (DOI)nvarchar50
82OIU_DO_BGUC_WKBearer Group Use Control4DOI_NODivision of interest (DOI)nvarchar50
83OIU_DO_DIBase Venture/DOI Relationship4DOI_NODivision of interest (DOI)nvarchar50
84OIU_DO_DIDODivision of Interest Information for Division Order Print4DOI_NODivision of interest (DOI)nvarchar50
85OIU_DO_DODivision of Interest Ownership4DOI_NODivision of interest (DOI)nvarchar50
86OIU_DO_DOGRIDivision Order Gross Revenue Interest4DOI_NODivision of interest (DOI)nvarchar50
87OIU_DO_DOHOwnership History5DOI_NODivision of interest (DOI)nvarchar50
88OIU_DO_DO_WKDivision of Interest Ownership Worktable4DOI_NODivision of interest (DOI)nvarchar50
89OIU_DO_DPDOI Accounting Information4DOI_NODivision of interest (DOI)nvarchar50
90OIU_DO_DPICDOI Product Interest Control4DOI_NODivision of interest (DOI)nvarchar50
91OIU_DO_DPIC_WKDOI Product Interest Control4DOI_NODivision of interest (DOI)nvarchar50
92OIU_DO_DPUCDOI Product Use Control4DOI_NODivision of interest (DOI)nvarchar50
93OIU_DO_DPUC_WKDOI Product Use Control4DOI_NODivision of interest (DOI)nvarchar50
94OIU_DO_TRTract Information6DOI_NODivision of interest (DOI)nvarchar50
95OIU_DO_TRGRITract Gross Revenue Interest11DOI_NODivision of interest (DOI)nvarchar50
96OIU_RV_CMCDContract Marketing Cost Detail14DOI_NOCredit Plant Division of Interestnvarchar50
97OIU_RV_DMCHProperty/DOI Marketing Cost Header4DOI_NODivision of interest (DOI)nvarchar50
98OIU_RV_MRTMarketing Rate Transactions9DOI_NODivision of interest (DOI)nvarchar50
99OIU_RV_PDXSSSettlement Statements/Purchaser - DOI Cross Reference10DOI_NODivision of interest (DOI)nvarchar50
100OIU_RV_RVTRejected Valuation Transactions10DOI_NODivision of interest (DOI)nvarchar50
101OIU_RV_TCLDTax Class4DOI_NODivision of interest (DOI)nvarchar50
102OIU_RV_VCRValuation Cross Reference9DOI_NODivision of interest (DOI)nvarchar50
103OIU_RV_VLDPValuation Division Order Prior Period Process4DOI_NODivision of interest (DOI)nvarchar50
104OIU_RV_VLRPTValuation Reporting18DOI_NODivision of interest (DOI)nvarchar50
105OIU_RV_VLRVSValuation Reversal Notificaton10DOI_NODivision of interest (DOI)nvarchar50
106OIU_RV_VLTXNSValuation Transactions9DOI_NODivision of interest (DOI)nvarchar50
107OIU_RV_VPPNValuation Prior Period Notification10DOI_NODivision of interest (DOI)nvarchar50
108OIU_RV_VPPNMManually Created Valuation Prior Period Notifications10DOI_NODivision of interest (DOI)nvarchar50
109OIU_RV_VPPNUValuation Prior Period Notification10DOI_NODivision of interest (DOI)nvarchar50
110OIU_RV_VXDSValuation Cross Reference Date Stamp10DOI_NODivision of interest (DOI)nvarchar50
111OIU_SB_DOIMPCross-reference for MP and DOI5DOI_NODivision of interest (DOI)nvarchar50
112OIU_SB_DOIWCDOI/WC Cross Reference6DOI_NODivision of interest (DOI)nvarchar50
113OIU_SB_ENTMPMP level owner entitlements7DOI_NODivision of interest (DOI)nvarchar50
114OIU_SB_ENTMP_TMP level owner entitlements7DOI_NODivision of interest (DOI)nvarchar50
115OIU_SB_ENTWCWC level owner entitlements8DOI_NODivision of interest (DOI)nvarchar50
116OIU_SB_ENTWC_TWC level owner entitlements8DOI_NODivision of interest (DOI)nvarchar50
117OIU_SB_MGDHMarketing Group Determination Header4DOI_NODivision of interest (DOI)nvarchar50
118OIU_SB_MGOPMPMarketing Group Owner Percent MP4DOI_NODivision of interest (DOI)nvarchar50
119OIU_SB_MGOPMP_TMarketing Group Owner Percent MP4DOI_NODivision of interest (DOI)nvarchar50
120OIU_SB_MGOPWCMarketing Group Owner Percent WC4DOI_NODivision of interest (DOI)nvarchar50
121OIU_SB_MGOPWC_TMarketing Group Owner Percent WC4DOI_NODivision of interest (DOI)nvarchar50
TOPRevenue
122OIURV03_DOCMPXRFVL Doc to MP XRef14DOI_NODivision of interest (DOI)nvarchar50
123OIURV03_DTL_BKValuation Transactions Level 1 - Vltxns12DOI_NODivision of interest (DOI)nvarchar50
124OIURV03_DTL_ZEValuation Transactions Level 1 - Zero Volume15DOI_NODivision of interest (DOI)nvarchar50
125OIURV03_MPWC_XRFMP to Well Completion Split Out XRef13DOI_NODivision of interest (DOI)nvarchar50
TOPRoyalty Reporting
126OIUREPP_PRPAYXRFMMS-2014 - Property / Payor XRef PPA4DOI_NODivision of interest (DOI)nvarchar50
127OIUREP_MMS_REJSMMS-2014 - Extraction Rejects22DOI_NODivision of interest (DOI)nvarchar50
128OIUREP_PROWNERSMMS-2014 - Property w/ Multiple Owners?4DOI_NODivision of interest (DOI)nvarchar50
129OIUREP_PRPAYXREFMMS-2014 - Property / Payor XRef4DOI_NODivision of interest (DOI)nvarchar50
130OIUREP_ROY_DATAReported Royalty and Volume Data by Reporting Entities8DOI_NODivision of interest (DOI)nvarchar50
131OIUREP_RPT_ENTTYEntities for Royalty Reporting7DOI_NODivision of interest (DOI)nvarchar50
132OIUREP_RTPENDMMS-2014 - Royalty Transaction Pending21DOI_NODivision of interest (DOI)nvarchar50
133OIUREP_RT_HISTMMS-2014 - Royalty Transaction (Pending) History21DOI_NODivision of interest (DOI)nvarchar50
134OIUREP_VL_VOLGross Volume and Value after VL/RD5DOI_NODivision of interest (DOI)nvarchar50
135OIUREP_VOL_DATAReported Volume Data by Reporting Entities8DOI_NODivision of interest (DOI)nvarchar50
TOPTax Reporting
136OIUX1_ADJ_TAXHCTax adjustments header for reporting5DOI_NODivision of interest (DOI)nvarchar50
137OIUX1_LNK_REPUBPUID and reporting entities link7DOI_NODivision of interest (DOI)nvarchar50
138OIUX1_MAS_REBReporting entities base table7DOI_NODivision of interest (DOI)nvarchar50
139OIUX1_RPT_TAXHTax transaction header for reporting9DOI_NODivision of interest (DOI)nvarchar50
140OIUX1_RPT_VOLHReported Volume Data by Reporting Entities9DOI_NODivision of interest (DOI)nvarchar50
141OIUX1_TAX_SUSPRecords for suspension7DOI_NODivision of interest (DOI)nvarchar50
142OIUX1_TRN_TAXHCTax transaction header for reporting4DOI_NODivision of interest (DOI)nvarchar50
143OIUX1_TRN_TAXHLTax transaction header for reporting4DOI_NODivision of interest (DOI)nvarchar50
144OIUX3Y_TX_MASTERTax Reporting - Texas Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
145OIUX3Y_TX_MSTOVRTax Reporting - Texas Master Data Overrides8DOI_NODivision of interest (DOI)nvarchar50
146OIUX3_TX_ASU_DTTax Reporting - Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
147OIUX3_TX_MASTERTax Reporting - Texas Master Data8DOI_NODivision of interest (DOI)nvarchar50
148OIUX3_TX_MSTOVRTax Reporting - Texas Master Data Overrides8DOI_NODivision of interest (DOI)nvarchar50
149OIUX3_TX_OOSHSTTax Reporting - Texas Out Of Statute Transaction History9DOI_NODivision of interest (DOI)nvarchar50
150OIUX3_TX_OOSTXNTax Reporting - Texas Out Of Statute Transactions9DOI_NODivision of interest (DOI)nvarchar50
151OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below10DOI_NODivision of interest (DOI)nvarchar50
152OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental10DOI_NODivision of interest (DOI)nvarchar50
153OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax10DOI_NODivision of interest (DOI)nvarchar50
154OIUX3_TX_REVSTGTax Reporting - Texas Tax Transaction Reversal Staging9DOI_NODivision of interest (DOI)nvarchar50
155OIUX3_TX_REVTXNTax Reporting - Texas Tax Transaction Reversals9DOI_NODivision of interest (DOI)nvarchar50
156OIUX3_TX_TAXHSTTax Reporting - Texas Tax History Transactions9DOI_NODivision of interest (DOI)nvarchar50
157OIUX3_TX_TAXSTGTax Reporting - Texas Tax Transaction Staging9DOI_NODivision of interest (DOI)nvarchar50
158OIUX3_TX_TAXTXNTax Reporting - Texas Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
159OIUX5Y_OK_MASTERTax 2.0 - Oklahoma Master Data PPN7DOI_NODivision of interest (DOI)nvarchar50
160OIUX5Y_OK_MSTCNTTax 2.0 - Oklahoma Master Data Counties7DOI_NODivision of interest (DOI)nvarchar50
161OIUX5_OK_ASU_DTTax 2.0 - Oklahoma Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
162OIUX5_OK_MASTERTax 2.0 - Oklahoma Master Data7DOI_NODivision of interest (DOI)nvarchar50
163OIUX5_OK_MSTCNTTax 2.0 - Oklahoma Master Data Multiple Counties7DOI_NODivision of interest (DOI)nvarchar50
164OIUX5_OK_OOSHSTTax 2.0 - Oklahoma Out Of Statute Transactions History9DOI_NODivision of interest (DOI)nvarchar50
165OIUX5_OK_OOSTXNTax 2.0 - Oklahoma Out Of Statute Transactions9DOI_NODivision of interest (DOI)nvarchar50
166OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions10DOI_NODivision of interest (DOI)nvarchar50
167OIUX5_OK_PRDTCTax 2.0 - Oklahoma PRA Detail Tax Transactions Multi Count10DOI_NODivision of interest (DOI)nvarchar50
168OIUX5_OK_REVSTGTax 2.0 - Oklahoma Tax Reversals Staging9DOI_NODivision of interest (DOI)nvarchar50
169OIUX5_OK_REVTXNTax 2.0 - Oklahoma Tax Reversals9DOI_NODivision of interest (DOI)nvarchar50
170OIUX5_OK_TAXHSTTax 2.0 - Oklahoma Tax Transactions History9DOI_NODivision of interest (DOI)nvarchar50
171OIUX5_OK_TAXHSTCTax 2.0 - Oklahoma Tax Transactions History Multi-Counties9DOI_NODivision of interest (DOI)nvarchar50
172OIUX5_OK_TAXSTGTax 2.0 - Oklahoma Tax Transactions Staging9DOI_NODivision of interest (DOI)nvarchar50
173OIUX5_OK_TAXTXNTax 2.0 - Oklahoma Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
174OIUX5_OK_TAXTXNCTax 2.0 - Oklahoma Tax Transactions Multiple Counties9DOI_NODivision of interest (DOI)nvarchar50
175OIUX6Y_WY_MASTERTax 2.0 - Wyoming Master Data PPN8DOI_NODivision of interest (DOI)nvarchar50
176OIUX6_WY_ASU_DTTax 2.0 - Wyoming Auto Suspend Detail5DOI_NODivision of interest (DOI)nvarchar50
177OIUX6_WY_COOSHSTTax 2.0 - Wyoming Out Of Statute Conservation Trans Hist9DOI_NODivision of interest (DOI)nvarchar50
178OIUX6_WY_COOSTXNTax 2.0 - Wyoming Out Of Statute Conservation Transactions9DOI_NODivision of interest (DOI)nvarchar50
179OIUX6_WY_CPRDTTax 2.0 - Wyoming Conservation Tax PRA Detail Transactions10DOI_NODivision of interest (DOI)nvarchar50
180OIUX6_WY_CREVSTGTax 2.0 - Wyoming Conservation Tax Reversals Staging9DOI_NODivision of interest (DOI)nvarchar50
181OIUX6_WY_CREVTXNTax 2.0 - Wyoming Conservation Tax Reversals9DOI_NODivision of interest (DOI)nvarchar50
182OIUX6_WY_CTAXHSTTax 2.0 - Wyoming Conservation Tax Transactions History9DOI_NODivision of interest (DOI)nvarchar50
183OIUX6_WY_CTAXSTGTax 2.0 - Wyoming Conservation Tax Transactions Staging9DOI_NODivision of interest (DOI)nvarchar50
184OIUX6_WY_CTAXTXNTax 2.0 - Wyoming Conservation Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
185OIUX6_WY_GTAXSTGTax 2.0 - Wyoming Gross Prod Tax Transactions Staging9DOI_NODivision of interest (DOI)nvarchar50
186OIUX6_WY_GTAXTXNTax 2.0 - Wyoming Gross Prod Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
187OIUX6_WY_LCDOVRTax 2.0 - Wyoming Lease Condensate Override7DOI_NODivision of interest (DOI)nvarchar50
188OIUX6_WY_MASTERTax 2.0 - Wyoming Master Data8DOI_NODivision of interest (DOI)nvarchar50
189OIUX6_WY_SOOSHSTTax 2.0 - Wyoming Out Of Statute Severance Trans History9DOI_NODivision of interest (DOI)nvarchar50
190OIUX6_WY_SOOSTXNTax 2.0 - Wyoming Out Of Statute Severance Transactions9DOI_NODivision of interest (DOI)nvarchar50
191OIUX6_WY_SPRDTTax 2.0 - Wyoming Severance Tax PRA Detail Transactions10DOI_NODivision of interest (DOI)nvarchar50
192OIUX6_WY_SREVSTGTax 2.0 - Wyoming Severance Tax Reversals Staging9DOI_NODivision of interest (DOI)nvarchar50
193OIUX6_WY_SREVTXNTax 2.0 - Wyoming Severance Tax Reversals9DOI_NODivision of interest (DOI)nvarchar50
194OIUX6_WY_STAXHSTTax 2.0 - Wyoming Severance Tax Transactions History9DOI_NODivision of interest (DOI)nvarchar50
195OIUX6_WY_STAXSTGTax 2.0 - Wyoming Severance Tax Transactions Staging9DOI_NODivision of interest (DOI)nvarchar50
196OIUX6_WY_STAXTXNTax 2.0 - Wyoming Severance Tax Transactions9DOI_NODivision of interest (DOI)nvarchar50
197OIUX7_WY_GTAXTax 2.0 - Wyoming Gross Prod Tax Transactions10DOI_NODivision of interest (DOI)nvarchar50
198OIUX7_WY_GTAXHSTTax 2.0 - Wyoming Gross Prod Tax Transactions History9DOI_NODivision of interest (DOI)nvarchar50
TOPValuation
199OIURV_CRH_HSTCombined Run Header History8DOI_NODIVISION OF INTEREST NOnvarchar50
200OIURV_DOC_COTVL Document Chain Of Title7DOI_NODIVISION OF INTEREST NOnvarchar50
201OIURV_DOC_DTL_BKValuation Transactions Level 1 - Vltxns12DOI_NODivision of interest (DOI)nvarchar50
202OIURV_DOC_DTL_RVValuation Reversal Notificaton13DOI_NODivision of interest (DOI)nvarchar50
203OIURV_DOC_DTL_ZEValuation Transactions Level 1 - Zero Volume15DOI_NODivision of interest (DOI)nvarchar50
204OIURV_DOC_MMSPOPDual Accounting MMS/POP5DOI_NODIVISION OF INTEREST NOnvarchar50
205OIURV_DOC_OOBJEOut Of Balance JEs10DOI_NODIVISION OF INTEREST NOnvarchar50
206OIURV_DOC_RDSUMRD summary(VL interface records to RD)13DOI_NODivision of interest (DOI)nvarchar50
207OIURV_DUAL_COMPDual Accounting Compare5DOI_NODIVISION OF INTEREST NOnvarchar50
208OIURV_DUAL_JEBRDual Accounting JE Backout / Rebook6DOI_NODIVISION OF INTEREST NOnvarchar50
209OIURV_GASSTMTHGas Statement Header5DOI_NODivision of interest (DOI)nvarchar50
210OIURV_SSTDSettlement statement detail17DOI_NODivision of interest (DOI)nvarchar50
211OIUVL_GASRPTHGas statement report header5DOI_NODivision of interest (DOI)nvarchar50
212OIUVL_GSPGas Statement Profile5DOI_NODivision of interest (DOI)nvarchar50
213OIUVL_MTAHMarketing Cost Tax Exemption - Header4DOI_NODivision of interest (DOI)nvarchar50
214OIUVL_OILRPTHOil statement report header5DOI_NODivision of interest (DOI)nvarchar50
215OIUVL_OILSTMTHOil Statement Header5DOI_NODivision of interest (DOI)nvarchar50
216OIUVL_OSPOil Statement Profile5DOI_NODivision of interest (DOI)nvarchar50
217OIUVL_RPAHRoyalty Processing Allowance Header4DOI_NODivision of interest (DOI)nvarchar50
218OIUVL_RPTDValuation report detail5DOI_NODivision of interest (DOI)nvarchar50
219OIUVL_SCAUDITSettlement statement batch7DOI_NODivision of interest (DOI)nvarchar50
220OIUVL_SEVCISeverance tax check input4DOI_NODivision of interest (DOI)nvarchar50
221OIUVL_SEVMPSeverance tax measurement point4DOI_NODivision of interest (DOI)nvarchar50
222OIUVL_SEVWCSeverance tax well completion4DOI_NODivision of interest (DOI)nvarchar50
223OIUVL_TCJVTax Class - Venture DOI's4DOI_NODivision of interest (DOI)nvarchar50
224OIUVL_TPAHTax Processing Allowance4DOI_NODivision of interest (DOI)nvarchar50