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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting :: Reporting :: Royalty Reporting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUREP_XTRCT_ROY1461Extract Royaty Data for the current reporting periodRoyalty Reporting
SQL:  selectupdate insert create

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

SELECT MANDT, YEAR_MONTH, AGENCY, OIL_GAS_IND, GL_OR_LVL_1_NO, OPSL_GL_SYS_NO, GL_ACCT_PERD_DT, GL_ACCT_NO, BTCH_TYPE_CODE, GL_TRANS_AM, GL_TRANS_QY, GL_GR_AM, GL_GR_QY, GL_PD_CD, GL_VL_TYPE_CD, GL_PU_NO, GL_PU_SEQ_NO, GL_CT_NO, GL_CT_TYPE_CD, GL_PR_NO, GL_DOI_NO, GL_WL_NO, GL_WC_NO, GL_SA_MP_NO, GL_SA_DT, GL_DN_NO, GL_SUB_NWK_NO, GL_CHV_RPT_CD, OPSL_BTU_QY, OPSL_PS_BASE_QY, OPSL_GRV_QY, OPSL_OWN_NO, OPSL_PRDR_NO, PSL_PRDR_SEQ_NO, OWN_INT_DECM_QY, OWN_INT_TYPE_CD, OWN_INT_SEQ_NO, PSL_RVRS_RSN_CD, UNIT_OF_MEAS_CD, OPSL_SUS_RSN_CD, OPSL_ORIG_MP_NO, OPSL_DED_RMB_AM, L_DED_GR_RMB_AM, OPSL_TAX_RMB_AM, L_TAX_GR_RMB_AM, OPSL_PAY_CD, OPSL_ST_CD, OWN_BAL_DECM_QY, OPSL_UNIT_PR_NO, L_NET_TRANSP_AM, L_NET_OTH_MK_AM, SL_GR_TRANSP_AM, SL_GR_OTH_MK_AM, OPSL_AES_FL, OPSL_TXN_VAL_AM, OPSL_GR_PVR_AM, OPSL_OWN_PVR_AM, MMBTU_OWN_VL_AM, PSL_SPC_PYMT_CD, OPSL_LGND_CD, OPSL_ESCH_FL, OPSL_CMT_SYS_NO, PSL_INT_PAID_FL, SL_OP_NON_OP_FL, OTAX_TAX_AM1, OTAX_TAX_AM2, OTAX_TAX_AM3, OTAX_TAX_AM4, OTAX_TAX_AM5, OTAX_TAX_AM6, OTAX_TAX_AM7, OTAX_TAX_AM8, OTAX_TAX_AM9, OTAX_TAX_AM10, GTAX_TAX_AM1, GTAX_TAX_AM2, GTAX_TAX_AM3, GTAX_TAX_AM4, GTAX_TAX_AM5, GTAX_TAX_AM6, GTAX_TAX_AM7, GTAX_TAX_AM8, GTAX_TAX_AM9, GTAX_TAX_AM10, ODED_DED_AM1, ODED_DED_AM2, ODED_DED_AM3, ODED_DED_AM4, ODED_DED_AM5, ODED_DED_AM6, ODED_DED_AM7, ODED_DED_AM8, ODED_DED_AM9, ODED_DED_AM10, ODED_DED_AM11, ODED_DED_AM12, ODED_DED_AM13, ODED_DED_AM14, ODED_DED_AM15, ODED_DED_AM16, ODED_DED_AM17, ODED_DED_AM18, REJECT_FLAG, GL_TIMESTAMP, OPSL_GR_PTR_AM, OPSL_OWN_PTR_AM, O_INT_1_AM, O_INT_2_AM, O_INT_3_AM, O_INT_4_AM, O_INT_5_AM, O_INT_6_AM, O_INT_7_AM, O_INT_8_AM, O_INT_9_AM, O_INT_10_AM, O_EXT_1_AM, O_EXT_2_AM, O_EXT_3_AM, O_EXT_4_AM, O_EXT_5_AM, O_EXT_6_AM, O_EXT_7_AM, O_EXT_8_AM, O_EXT_9_AM, O_EXT_10_AM, G_INT_1_AM, G_INT_2_AM, G_INT_3_AM, G_INT_4_AM, G_INT_5_AM, G_INT_6_AM, G_INT_7_AM, G_INT_8_AM, G_INT_9_AM, G_INT_10_AM, G_EXT_1_AM, G_EXT_2_AM, G_EXT_3_AM, G_EXT_4_AM, G_EXT_5_AM, G_EXT_6_AM, G_EXT_7_AM, G_EXT_8_AM, G_EXT_9_AM, G_EXT_10_AM FROM OIUREP_XTRCT_ROY
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2YEAR_MONTHReporting Year and Monthnvarchar60NUMC(N'000000')NoOIUREP_RPT_YYYYMM Allow NULL? 
3AGENCYAgency for Reportingnvarchar30CHAR(N' ')NoOIUREP_ROY_AGENCY Allow NULL? 
4OIL_GAS_INDOil and Gas Indicatorchar10CHAR(N' ')NoOIUREP_OIL_GAS_IND Allow NULL? 
5GL_OR_LVL_1_NOCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
6OPSL_GL_SYS_NOOIUH_NUMC18nvarchar180NUMC(N'000000000000000000')NoOIUH_NUMC18 Allow NULL? 
7GL_ACCT_PERD_DTAccounting Period Datenvarchar140CHAR(N' ')YesOIUREP_ACCT_PERD_DT Allow NULL? 
8GL_ACCT_NOGL Account No.nvarchar100CHAR(N' ')YesOIUREP_GL_ACCT_NO Allow NULL? 
9BTCH_TYPE_CODEBatch Typenvarchar20CHAR(N' ')YesOIUREP_BTCH_TYPE_CODE Allow NULL? 
10GL_TRANS_AMGL Transaction Amountdecimal112CURR((0))YesOIUREP_GL_TRANS_AM
11GL_TRANS_QYGL Transaction Quantitydecimal112DEC((0))YesOIUREP_GL_TRANS_QY
12GL_GR_AMGL Gross Amountdecimal112CURR((0))YesOIUREP_GL_GR_AM
13GL_GR_QYGL Gross Quantitydecimal112DEC((0))YesOIUREP_GL_GR_QY
14GL_PD_CDMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
15GL_VL_TYPE_CDGL Volume Type Codenvarchar20CHAR(N' ')YesOIUREP_GL_VL_TYPE_CD Allow NULL? 
16GL_PU_NOOIUH_CHAR6nvarchar60CHAR(N' ')YesOIUH_CHAR6 Allow NULL? 
17GL_PU_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
18GL_CT_NOContract No.nvarchar60CHAR(N' ')YesOIUREP_GL_CT_NO Allow NULL? 
19GL_CT_TYPE_CDGL Contract Type Codenvarchar20CHAR(N' ')YesOIUREP_GL_CT_TYPE_CD Allow NULL? 
20GL_PR_NOJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
21GL_DOI_NODivision of interest (DOI)nvarchar50CHAR(N' ')Yes*OIU_DOI_NO Allow NULL? 
22GL_WL_NOWell ID numbernvarchar150CHAR(N' ')Yes*OIU_WL_NO Allow NULL? 
23GL_WC_NOWell Completion Numbernvarchar50CHAR(N' ')Yes*OIU_WC_NO Allow NULL? 
24GL_SA_MP_NOMeasurement point numbernvarchar200CHAR(N' ')Yes*OIU_MP_NO Allow NULL? 
25GL_SA_DTGL Sales Datenvarchar140CHAR(N' ')YesOIUREP_GL_SA_DT Allow NULL? 
26GL_DN_NOOIUH_CHAR4nvarchar40CHAR(N' ')YesOIUH_CHAR4 Allow NULL? 
27GL_SUB_NWK_NOOIUH_CHAR4nvarchar40CHAR(N' ')YesOIUH_CHAR4 Allow NULL? 
28GL_CHV_RPT_CDGL Cost Centernvarchar100CHAR(N' ')YesOIUREP_GL_CHV_RPT_CD Allow NULL? 
29OPSL_BTU_QYOPSL BTU Quantitydecimal73DEC((0))YesOIUREP_OPSL_BTU_QY
30OPSL_PS_BASE_QYOPSL Pressure Base Quantitydecimal63DEC((0))YesOIUREP_OPSL_PS_BASE_QY
31OPSL_GRV_QYGravity Quantitynvarchar40NUMC(N'0000')YesOIUREP_GRV_QY_NUMC4 Allow NULL? 
32OPSL_OWN_NOMaster Recordnvarchar100CHAR(N' ')YesOIUCM_MASTER Allow NULL? 
33OPSL_PRDR_NOOPSL Producer No.nvarchar60CHAR(N' ')YesOIUREP_OPSL_PRDR_NO Allow NULL? 
34PSL_PRDR_SEQ_NOOPSL Producer Sequence No.nvarchar20CHAR(N' ')YesOIUREP_PSL_PRDR_SEQ_NO Allow NULL? 
35OWN_INT_DECM_QYOIUH_DEC9_8decimal98DEC((0))YesOIUH_DEC9_8
36OWN_INT_TYPE_CDOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
37OWN_INT_SEQ_NOOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
38PSL_RVRS_RSN_CDOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
39UNIT_OF_MEAS_CDOIUH_CHAR3nvarchar30CHAR(N' ')YesOIUH_CHAR3 Allow NULL? 
40OPSL_SUS_RSN_CDOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
41OPSL_ORIG_MP_NOMeasurement point numbernvarchar200CHAR(N' ')Yes*OIU_MP_NO Allow NULL? 
42OPSL_DED_RMB_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
43L_DED_GR_RMB_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
44OPSL_TAX_RMB_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
45L_TAX_GR_RMB_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
46OPSL_PAY_CDOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
47OPSL_ST_CDOPSL State Codenvarchar20CHAR(N' ')YesOIUREP_OPSL_ST_CD Allow NULL? 
48OWN_BAL_DECM_QYOIUH_DEC9_8decimal98DEC((0))YesOIUH_DEC9_8
49OPSL_UNIT_PR_NOJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
50L_NET_TRANSP_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
51L_NET_OTH_MK_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
52SL_GR_TRANSP_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
53SL_GR_OTH_MK_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
54OPSL_AES_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
55OPSL_TXN_VAL_AMLocal amountdecimal112CURR((0))YesOIUH_CURR11_2
56OPSL_GR_PVR_AMOIUH_DEC11_2decimal112DEC((0))YesOIUH_DEC11_2
57OPSL_OWN_PVR_AMOIUH_DEC11_2decimal112DEC((0))YesOIUH_DEC11_2
58MMBTU_OWN_VL_AMOIUH_DEC11_2decimal112DEC((0))YesOIUH_DEC11_2
59PSL_SPC_PYMT_CDOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
60OPSL_LGND_CDOIUH_CHAR2nvarchar20CHAR(N' ')YesOIUH_CHAR2 Allow NULL? 
61OPSL_ESCH_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
62OPSL_CMT_SYS_NOOIUH_DEC18decimal180DEC((0))YesOIUH_DEC18
63PSL_INT_PAID_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
64SL_OP_NON_OP_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
65OTAX_TAX_AM1Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
66OTAX_TAX_AM2Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
67OTAX_TAX_AM3Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
68OTAX_TAX_AM4Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
69OTAX_TAX_AM5Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
70OTAX_TAX_AM6Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
71OTAX_TAX_AM7Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
72OTAX_TAX_AM8Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
73OTAX_TAX_AM9Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
74OTAX_TAX_AM10Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
75GTAX_TAX_AM1Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
76GTAX_TAX_AM2Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
77GTAX_TAX_AM3Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
78GTAX_TAX_AM4Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
79GTAX_TAX_AM5Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
80GTAX_TAX_AM6Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
81GTAX_TAX_AM7Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
82GTAX_TAX_AM8Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
83GTAX_TAX_AM9Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
84GTAX_TAX_AM10Tax Amountdecimal112CURR((0))YesOIUREP_TAX_AMOUNT
85ODED_DED_AM1Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
86ODED_DED_AM2Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
87ODED_DED_AM3Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
88ODED_DED_AM4Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
89ODED_DED_AM5Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
90ODED_DED_AM6Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
91ODED_DED_AM7Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
92ODED_DED_AM8Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
93ODED_DED_AM9Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
94ODED_DED_AM10Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
95ODED_DED_AM11Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
96ODED_DED_AM12Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
97ODED_DED_AM13Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
98ODED_DED_AM14Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
99ODED_DED_AM15Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
100ODED_DED_AM16Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
101ODED_DED_AM17Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
102ODED_DED_AM18Deduction Amountdecimal112CURR((0))YesOIUREP_DED_AMOUNT
103REJECT_FLAGReject flagchar10CHAR(N' ')YesOIUREP_REJECT_FLAG Allow NULL? 
104GL_TIMESTAMPOIUH_CHAR14nvarchar140CHAR(N' ')YesOIUH_CHAR14 Allow NULL? 
105OPSL_GR_PTR_AMOIUH_DEC11_2decimal112DEC((0))YesOIUH_DEC11_2
106OPSL_OWN_PTR_AMOIUH_DEC11_2decimal112DEC((0))YesOIUH_DEC11_2
107O_INT_1_AMOwner internal mkt amt 1decimal112CURR((0))YesOIU_O_INT_1_AM
108O_INT_2_AMOwner internal mkt amt 2decimal112CURR((0))YesOIU_O_INT_2_AM
109O_INT_3_AMOwner internal mkt amt 3decimal112CURR((0))YesOIU_O_INT_3_AM
110O_INT_4_AMOwner internal mkt amt 4decimal112CURR((0))YesOIU_O_INT_4_AM
111O_INT_5_AMOwner internal mkt amt 5decimal112CURR((0))YesOIU_O_INT_5_AM
112O_INT_6_AMOwner internal mkt amt 6decimal112CURR((0))YesOIU_O_INT_6_AM
113O_INT_7_AMOwner internal mkt amt 7decimal112CURR((0))YesOIU_O_INT_7_AM
114O_INT_8_AMOwner internal mkt amt 8decimal112CURR((0))YesOIU_O_INT_8_AM
115O_INT_9_AMOwner internal mkt amt 9decimal112CURR((0))YesOIU_O_INT_9_AM
116O_INT_10_AMOwner internal mkt amt10decimal112CURR((0))YesOIU_O_INT_10_AM
117O_EXT_1_AMOwner external mkt amt 1decimal112CURR((0))YesOIU_O_EXT_1_AM
118O_EXT_2_AMOwner external mkt amt 2decimal112CURR((0))YesOIU_O_EXT_2_AM
119O_EXT_3_AMOwner external mkt amt 3decimal112CURR((0))YesOIU_O_EXT_3_AM
120O_EXT_4_AMOwner external mkt amt 4decimal112CURR((0))YesOIU_O_EXT_4_AM
121O_EXT_5_AMOwner external mkt amt 5decimal112CURR((0))YesOIU_O_EXT_5_AM
122O_EXT_6_AMOwner external mkt amt 6decimal112CURR((0))YesOIU_O_EXT_6_AM
123O_EXT_7_AMOwner external mkt amt 7decimal112CURR((0))YesOIU_O_EXT_7_AM
124O_EXT_8_AMOwner external mkt amt 8decimal112CURR((0))YesOIU_O_EXT_8_AM
125O_EXT_9_AMOwner external mkt amt 9decimal112CURR((0))YesOIU_O_EXT_9_AM
126O_EXT_10_AMOwner external mkt amt10decimal112CURR((0))YesOIU_O_EXT_10_AM
127G_INT_1_AMGross internal mkt amt 1decimal112CURR((0))YesOIU_G_INT_1_AM
128G_INT_2_AMGross internal mkt amt 2decimal112CURR((0))YesOIU_G_INT_2_AM
129G_INT_3_AMGross internal mkt amt 3decimal112CURR((0))YesOIU_G_INT_3_AM
130G_INT_4_AMGross internal mkt amt 4decimal112CURR((0))YesOIU_G_INT_4_AM
131G_INT_5_AMGross internal mkt amt 5decimal112CURR((0))YesOIU_G_INT_5_AM
132G_INT_6_AMGross internal mkt amt 6decimal112CURR((0))YesOIU_G_INT_6_AM
133G_INT_7_AMGross internal mkt amt 7decimal112CURR((0))YesOIU_G_INT_7_AM
134G_INT_8_AMGross internal mkt amt 8decimal112CURR((0))YesOIU_G_INT_8_AM
135G_INT_9_AMGross internal mkt amt 9decimal112CURR((0))YesOIU_G_INT_9_AM
136G_INT_10_AMGross internal mkt amt10decimal112CURR((0))YesOIU_G_INT_10_AM
137G_EXT_1_AMGross external mkt amt 1decimal112CURR((0))YesOIU_G_EXT_1_AM
138G_EXT_2_AMGross external mkt amt 2decimal112CURR((0))YesOIU_G_EXT_2_AM
139G_EXT_3_AMGross external mkt amt 3decimal112CURR((0))YesOIU_G_EXT_3_AM
140G_EXT_4_AMGross external mkt amt 4decimal112CURR((0))YesOIU_G_EXT_4_AM
141G_EXT_5_AMGross external mkt amt 5decimal112CURR((0))YesOIU_G_EXT_5_AM
142G_EXT_6_AMGross external mkt amt 6decimal112CURR((0))YesOIU_G_EXT_6_AM
143G_EXT_7_AMGross external mkt amt 7decimal112CURR((0))YesOIU_G_EXT_7_AM
144G_EXT_8_AMGross external mkt amt 8decimal112CURR((0))YesOIU_G_EXT_8_AM
145G_EXT_9_AMGross external mkt amt 9decimal112CURR((0))YesOIU_G_EXT_9_AM
146G_EXT_10_AMGross external mkt amt 10decimal112CURR((0))YesOIU_G_EXT_10_AM
NamePrimaryUniqueTypeColumns
OIUREP_XTRCT_ROY~0YesYesCLUSTEREDOPSL_GL_SYS_NO, GL_OR_LVL_1_NO, OIL_GAS_IND, AGENCY, YEAR_MONTH, MANDT