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 :: Revenue :: Valuation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIURV_DOC_RDSUM3611RD summary(VL interface records to RD)Valuation
SQL:  selectupdate insert create

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

SELECT MANDT, DOC_NO, DOC_YEAR, LINE_NO, DN_NO, WL_NO, WC_NO, MP_NO, MP_TYPE_CD, MATNR, BUKRS, VNAME, DOI_NO, CT_NO, MAJPD_CD, FRML_NO, WI_OWN_NO, WI_INT_TYPE_CD, WI_OWN_ISQ_NO, NI_OWN_NO, NI_INT_TYPE_CD, NI_OWN_ISQ_NO, LVL_CD, PU_NO, TAX_CLS, SALE_DT, LAND1, PRI_GEO_LOC, TAX_TYPE_1, TAX_TYPE_2, TAX_TYPE_3, TAX_TYPE_4, TAX_TYPE_5, TAX_TYPE_6, TAX_TYPE_7, TAX_TYPE_8, TAX_TYPE_9, TAX_TYPE_10, SEV_TAX_PAY_1, SEV_TAX_PAY_2, SEV_TAX_PAY_3, SEV_TAX_PAY_4, SEV_TAX_PAY_5, SEV_TAX_PAY_6, SEV_TAX_PAY_7, SEV_TAX_PAY_8, SEV_TAX_PAY_9, SEV_TAX_PAY_10, SM_REV_PRCS_CD, UNIT_VNAME, SYSTEM_SRCE_CD, VL_TYPE_CD, VL_CLS_CD, FRML_ACTL_FL, FRML_ENTL_FL, FRML_SETT_FL, TOT_GRI_PC, TOT_NRI_PC, CT_DECM, ADJ_CT_DECM, SLID_SCAL_IND, ACTL_GR_VL, ENTL_GR_VL, ACTL_ENERGY, ENTL_ENERGY, SM_PS_BASE, SM_ACTL_BTU_FAC, GRV_AM, ACTL_GR_VAL_AM, ENTL_GR_VAL_AM, SETT_GR_VL, SETT_GR_VAL_AM, SETT_ENERGY, INT_ACTL_MKCT_1, INT_ACTL_MKCT_2, INT_ACTL_MKCT_3, INT_ACTL_MKCT_4, INT_ACTL_MKCT_5, INT_ACTL_MKCT_6, INT_ACTL_MKCT_7, INT_ACTL_MKCT_8, INT_ACTL_MKCT_9, INT_ACTL_MKCT_10, EXT_ACTL_MKCT_1, EXT_ACTL_MKCT_2, EXT_ACTL_MKCT_3, EXT_ACTL_MKCT_4, EXT_ACTL_MKCT_5, EXT_ACTL_MKCT_6, EXT_ACTL_MKCT_7, EXT_ACTL_MKCT_8, EXT_ACTL_MKCT_9, EXT_ACTL_MKCT_10, EXT_ACTL_MCR_1, EXT_ACTL_MCR_2, EXT_ACTL_MCR_3, EXT_ACTL_MCR_4, EXT_ACTL_MCR_5, EXT_ACTL_MCR_6, EXT_ACTL_MCR_7, EXT_ACTL_MCR_8, EXT_ACTL_MCR_9, EXT_ACTL_MCR_10, TRNSP_NO_1, TRNSP_NO_2, TRNSP_NO_3, TRNSP_NO_4, TRNSP_NO_5, TRNSP_NO_6, TRNSP_NO_7, TRNSP_NO_8, TRNSP_NO_9, TRNSP_NO_10, TRNSP_CT_NO_1, TRNSP_CT_NO_2, TRNSP_CT_NO_3, TRNSP_CT_NO_4, TRNSP_CT_NO_5, TRNSP_CT_NO_6, TRNSP_CT_NO_7, TRNSP_CT_NO_8, TRNSP_CT_NO_9, TRNSP_CT_NO10, INT_ENTL_MKCT_1, INT_ENTL_MKCT_2, INT_ENTL_MKCT_3, INT_ENTL_MKCT_4, INT_ENTL_MKCT_5, INT_ENTL_MKCT_6, INT_ENTL_MKCT_7, INT_ENTL_MKCT_8, INT_ENTL_MKCT_9, INT_ENTL_MKCT_10, EXT_ENTL_MKCT_1, EXT_ENTL_MKCT_2, EXT_ENTL_MKCT_3, EXT_ENTL_MKCT_4, EXT_ENTL_MKCT_5, EXT_ENTL_MKCT_6, EXT_ENTL_MKCT_7, EXT_ENTL_MKCT_8, EXT_ENTL_MKCT_9, EXT_ENTL_MKCT_10, EXT_ENTL_MCR_1, EXT_ENTL_MCR_2, EXT_ENTL_MCR_3, EXT_ENTL_MCR_4, EXT_ENTL_MCR_5, EXT_ENTL_MCR_6, EXT_ENTL_MCR_7, EXT_ENTL_MCR_8, EXT_ENTL_MCR_9, EXT_ENTL_MCR_10, INT_SETT_MKCT_1, INT_SETT_MKCT_2, INT_SETT_MKCT_3, INT_SETT_MKCT_4, INT_SETT_MKCT_5, INT_SETT_MKCT_6, INT_SETT_MKCT_7, INT_SETT_MKCT_8, INT_SETT_MKCT_9, INT_SETT_MKCT_10, EXT_SETT_MKCT_1, EXT_SETT_MKCT_2, EXT_SETT_MKCT_3, EXT_SETT_MKCT_4, EXT_SETT_MKCT_5, EXT_SETT_MKCT_6, EXT_SETT_MKCT_7, EXT_SETT_MKCT_8, EXT_SETT_MKCT_9, EXT_SETT_MKCT_10, EXT_SETT_MCR_1, EXT_SETT_MCR_2, EXT_SETT_MCR_3, EXT_SETT_MCR_4, EXT_SETT_MCR_5, EXT_SETT_MCR_6, EXT_SETT_MCR_7, EXT_SETT_MCR_8, EXT_SETT_MCR_9, EXT_SETT_MCR_10, SM_SETT_BTU_FAC, TOTAL_TAX_PC_1, TOTAL_TAX_PC_2, TOTAL_TAX_PC_3, TOTAL_TAX_PC_4, TOTAL_TAX_PC_5, TOTAL_TAX_PC_6, TOTAL_TAX_PC_7, TOTAL_TAX_PC_8, TOTAL_TAX_PC_9, TOTAL_TAX_PC_10, ACTL_ST_TAX_1, ACTL_ST_TAX_2, ACTL_ST_TAX_3, ACTL_ST_TAX_4, ACTL_ST_TAX_5, ACTL_ST_TAX_6, ACTL_ST_TAX_7, ACTL_ST_TAX_8, ACTL_ST_TAX_9, ACTL_ST_TAX_10, ACTL_ST_TAX_RM_1, ACTL_ST_TAX_RM_2, ACTL_ST_TAX_RM_3, ACTL_ST_TAX_RM_4, ACTL_ST_TAX_RM_5, ACTL_ST_TAX_RM_6, ACTL_ST_TAX_RM_7, ACTL_ST_TAX_RM_8, ACTL_ST_TAX_RM_9, ACTL_ST_TAX_RM10, GROSS_ST_TAX_1, GROSS_ST_TAX_2, GROSS_ST_TAX_3, GROSS_ST_TAX_4, GROSS_ST_TAX_5, GROSS_ST_TAX_6, GROSS_ST_TAX_7, GROSS_ST_TAX_8, GROSS_ST_TAX_9, GROSS_ST_TAX_10, VL_TAX_RATE_PC_1, VL_TAX_RATE_PC_2, VL_TAX_RATE_PC_3, VL_TAX_RATE_PC_4, VL_TAX_RATE_PC_5, VL_TAX_RATE_PC_6, VL_TAX_RATE_PC_7, VL_TAX_RATE_PC_8, VL_TAX_RATE_PC_9, VL_TAX_RATE_PC10, ENTL_ST_TAX_1, ENTL_ST_TAX_2, ENTL_ST_TAX_3, ENTL_ST_TAX_4, ENTL_ST_TAX_5, ENTL_ST_TAX_6, ENTL_ST_TAX_7, ENTL_ST_TAX_8, ENTL_ST_TAX_9, ENTL_ST_TAX_10, ENTL_ST_TAX_RM_1, ENTL_ST_TAX_RM_2, ENTL_ST_TAX_RM_3, ENTL_ST_TAX_RM_4, ENTL_ST_TAX_RM_5, ENTL_ST_TAX_RM_6, ENTL_ST_TAX_RM_7, ENTL_ST_TAX_RM_8, ENTL_ST_TAX_RM_9, ENTL_ST_TAX_RM10, SETT_ST_TAX_1, SETT_ST_TAX_2, SETT_ST_TAX_3, SETT_ST_TAX_4, SETT_ST_TAX_5, SETT_ST_TAX_6, SETT_ST_TAX_7, SETT_ST_TAX_8, SETT_ST_TAX_9, SETT_ST_TAX_10, SETT_ST_TAX_RM_1, SETT_ST_TAX_RM_2, SETT_ST_TAX_RM_3, SETT_ST_TAX_RM_4, SETT_ST_TAX_RM_5, SETT_ST_TAX_RM_6, SETT_ST_TAX_RM_7, SETT_ST_TAX_RM_8, SETT_ST_TAX_RM_9, SETT_ST_TAX_RM10, SM_RCVBL_MP, TOT_TAX_RM_PC_1, TOT_TAX_RM_PC_2, TOT_TAX_RM_PC_3, TOT_TAX_RM_PC_4, TOT_TAX_RM_PC_5, TOT_TAX_RM_PC_6, TOT_TAX_RM_PC_7, TOT_TAX_RM_PC_8, TOT_TAX_RM_PC_9, TOT_TAX_RM_PC_10, GPLT_VNAME, GPLT_DOI_DOI, ACTL_WLR_VL_AM, ENTL_WLR_VL_AM, SETT_WLR_VL_AM, EXT_PROP_NO_1, EXT_DOI_NO_1, EXT_PROP_NO_2, EXT_DOI_NO_2, EXT_PROP_NO_3, EXT_DOI_NO_3, EXT_PROP_NO_4, EXT_DOI_NO_4, EXT_PROP_NO_5, EXT_DOI_NO_5, EXT_PROP_NO_6, EXT_DOI_NO_6, EXT_PROP_NO_7, EXT_DOI_NO_7, EXT_PROP_NO_8, EXT_DOI_NO_8, EXT_PROP_NO_9, EXT_DOI_NO_9, EXT_PROP_NO_10, EXT_DOI_NO_10, INT_PROP_NO_1, INT_DOI_NO_1, INT_PROP_NO_2, INT_DOI_NO_2, INT_PROP_NO_3, INT_DOI_NO_3, INT_PROP_NO_4, INT_DOI_NO_4, INT_PROP_NO_5, INT_DOI_NO_5, INT_PROP_NO_6, INT_DOI_NO_6, INT_PROP_NO_7, INT_DOI_NO_7, INT_PROP_NO_8, INT_DOI_NO_8, INT_PROP_NO_9, INT_DOI_NO_9, INT_PROP_NO_10, INT_DOI_NO_10, SM_REMITTER_NO, SM_REMITT_SEQ_NO, GASLIFT_WL_NO, GASLIFT_WC_NO, RELATED_CT, CT_TYPE_CD, DOI_SUM_FL, DUAL_ACCT_FL, ORIG_MP_NO, VNAME_TYPE_CD, SM_TAX_GRNT_FL, TAX_RMB_GRNT, SM_NRTF_CD, SM_REC_PYMT_CD, IGN_PYMT_CD, BY_SLL_CT_NO, BY_SLL_VAL, BRD_CD, SM_LSE_VOL, SM_LSE_VAL, SM_PCT_RET_LSE, SM_TIK_PA_PC, SM_ENTL_CT_DECM, SM_RM_FEE_FL, SECT_VNAME, SECT_DOI_NO, COST_CENTER, UNIT_OF_MEAS_CD, ACTL_PTR_VL_AM, ENTL_PTR_VL_AM, SETT_PTR_VL_AM FROM OIURV_DOC_RDSUM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DOC_NOVal. document numbernvarchar200CHAR(N' ')No*OIURV_DOCNR Allow NULL? 
3DOC_YEARDocument yearnvarchar40NUMC(N'0000')NoOIU_DOC_YEAR Allow NULL? 
4LINE_NODocument Line Numbernvarchar60NUMC(N'000000')NoOIU_DOC_LINENR_E Allow NULL? 
5DN_NODelivery network numbernvarchar200CHAR(N' ')Yes*OIU_DN_NO Allow NULL? 
6WL_NOWell ID numbernvarchar150CHAR(N' ')Yes*OIU_WL_NO Allow NULL? 
7WC_NOWell Completion Numbernvarchar50CHAR(N' ')Yes*OIU_WC_NO Allow NULL? 
8MP_NOMeasurement point numbernvarchar200CHAR(N' ')Yes*OIU_MP_NO Allow NULL? 
9MP_TYPE_CDOriginating Measurement Point Typenvarchar20CHAR(N' ')YesOIUH_ORIGINATING_MP_TYPE Allow NULL? 
10MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
11BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
12VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
13DOI_NODivision of interest (DOI)nvarchar50CHAR(N' ')Yes*OIU_DOI_NO Allow NULL? 
14CT_NOContract Numbernvarchar100CHAR(N' ')Yes*OIU_CT_NO Allow NULL? 
15MAJPD_CDMajor product codechar10CHAR(N' ')YesOIU_MAJPD_CD Allow NULL? 
16FRML_NOFormula numbernvarchar80CHAR(N' ')Yes*OIU_FRML_NO Allow NULL? 
17WI_OWN_NOWorking Interest Ownernvarchar100CHAR(N' ')Yes*OIU_WI_OWN_NO Allow NULL? 
18WI_INT_TYPE_CDParticipant Interest Typenvarchar20CHAR(N' ')Yes*OIU_PART_INT_TYPE Allow NULL? 
19WI_OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20CHAR(N' ')YesOIU_OWN_ISQ_NO Allow NULL? 
20NI_OWN_NONet Interest Ownernvarchar100CHAR(N' ')Yes*OIU_NI_OWN_NO Allow NULL? 
21NI_INT_TYPE_CDParticipant Interest Typenvarchar20CHAR(N' ')Yes*OIU_PART_INT_TYPE Allow NULL? 
22NI_OWN_ISQ_NOOwner Interest Sequence Numbernvarchar20CHAR(N' ')YesOIU_OWN_ISQ_NO Allow NULL? 
23LVL_CDLevel Codenvarchar20NUMC(N'00')YesOIU_LVL_CD Allow NULL? 
24PU_NOSold-to partynvarchar100CHAR(N' ')Yes*KUNAG Allow NULL? 
25TAX_CLSTax Classnvarchar40CHAR(N' ')Yes*OIU_TAX_CLS Allow NULL? 
26SALE_DTSales Date / Monthnvarchar80DATS(N'00000000')YesOIU_SALE_DT Allow NULL? 
27LAND1Country Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
28PRI_GEO_LOCPrimary geographical location (PRI geo. loc.)nvarchar20CHAR(N' ')Yes*OIU_PRI_GEO_LOC Allow NULL? 
29TAX_TYPE_1Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
30TAX_TYPE_2Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
31TAX_TYPE_3Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
32TAX_TYPE_4Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
33TAX_TYPE_5Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
34TAX_TYPE_6Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
35TAX_TYPE_7Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
36TAX_TYPE_8Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
37TAX_TYPE_9Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
38TAX_TYPE_10Severance Tax Typenvarchar20CHAR(N' ')Yes*OIU_SEVT_TAX_TY Allow NULL? 
39SEV_TAX_PAY_1Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
40SEV_TAX_PAY_2Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
41SEV_TAX_PAY_3Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
42SEV_TAX_PAY_4Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
43SEV_TAX_PAY_5Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
44SEV_TAX_PAY_6Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
45SEV_TAX_PAY_7Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
46SEV_TAX_PAY_8Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
47SEV_TAX_PAY_9Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
48SEV_TAX_PAY_10Tax Severance Tax Calculation Payment Obligations Typeschar10CHAR(N' ')YesOIU_SEVT_PAY_FL Allow NULL? 
49SM_REV_PRCS_CDRevenue Process Codenvarchar20CHAR(N' ')YesOIU_REV_PRCS_CD Allow NULL? 
50UNIT_VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
51SYSTEM_SRCE_CDValuation Transaction Source Codenvarchar20CHAR(N' ')YesOIU_VL_SRCE_CD Allow NULL? 
52VL_TYPE_CDVolume type codenvarchar20CHAR(N' ')Yes*OIU_VT_CD Allow NULL? 
53VL_CLS_CDVolume class codechar10CHAR(N' ')YesOIU_VC_CD Allow NULL? 
54FRML_ACTL_FLActual indicatorchar10CHAR(N' ')YesOIU_ACTL_FL Allow NULL? 
55FRML_ENTL_FLEntitled Flagchar10CHAR(N' ')YesOIU_ENTL_FL Allow NULL? 
56FRML_SETT_FLSettlement Flagchar10CHAR(N' ')YesOIU_SETT_FL Allow NULL? 
57TOT_GRI_PCTotal Gross Interest %decimal98DEC((0))YesOIU_TOT_GRI_PC
58TOT_NRI_PCTotal Net Revenue Interest Percentagedecimal98DEC((0))YesOIU_TOT_NRI_PC
59CT_DECMContract Decimaldecimal98DEC((0))YesOIU_CT_DECM
60ADJ_CT_DECMContract Decimaldecimal98DEC((0))YesOIU_CT_DECM
61SLID_SCAL_INDSliding scale indicatorchar10CHAR(N' ')YesOIUVL_SLID_SCAL_IND Allow NULL? 
62ACTL_GR_VLGross Quantitydecimal112DEC((0))YesOIUH_GROSS_QTY
63ENTL_GR_VLGross Quantitydecimal112DEC((0))YesOIUH_GROSS_QTY
64ACTL_ENERGYMMBTU Gross Volumedecimal112DEC((0))YesOIUH_MMBTU
65ENTL_ENERGYMMBTU Gross Volumedecimal112DEC((0))YesOIUH_MMBTU
66SM_PS_BASEOIUH_DEC5_3decimal53DEC((0))YesOIUH_DEC5_3
67SM_ACTL_BTU_FACOIUH_DEC7_3decimal73DEC((0))YesOIUH_DEC7_3
68GRV_AMOIUH_DEC3_1decimal31DEC((0))YesOIUH_DEC3_1
69ACTL_GR_VAL_AMJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
70ENTL_GR_VAL_AMJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
71SETT_GR_VLGross Quantitydecimal112DEC((0))YesOIUH_GROSS_QTY
72SETT_GR_VAL_AMJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
73SETT_ENERGYMMBTU Gross Volumedecimal112DEC((0))YesOIUH_MMBTU
74INT_ACTL_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
75INT_ACTL_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
76INT_ACTL_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
77INT_ACTL_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
78INT_ACTL_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
79INT_ACTL_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
80INT_ACTL_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
81INT_ACTL_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
82INT_ACTL_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
83INT_ACTL_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
84EXT_ACTL_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
85EXT_ACTL_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
86EXT_ACTL_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
87EXT_ACTL_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
88EXT_ACTL_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
89EXT_ACTL_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
90EXT_ACTL_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
91EXT_ACTL_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
92EXT_ACTL_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
93EXT_ACTL_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
94EXT_ACTL_MCR_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
95EXT_ACTL_MCR_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
96EXT_ACTL_MCR_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
97EXT_ACTL_MCR_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
98EXT_ACTL_MCR_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
99EXT_ACTL_MCR_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
100EXT_ACTL_MCR_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
101EXT_ACTL_MCR_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
102EXT_ACTL_MCR_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
103EXT_ACTL_MCR_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
104TRNSP_NO_1Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
105TRNSP_NO_2Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
106TRNSP_NO_3Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
107TRNSP_NO_4Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
108TRNSP_NO_5Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
109TRNSP_NO_6Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
110TRNSP_NO_7Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
111TRNSP_NO_8Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
112TRNSP_NO_9Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
113TRNSP_NO_10Transporter numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_NO Allow NULL? 
114TRNSP_CT_NO_1Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
115TRNSP_CT_NO_2Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
116TRNSP_CT_NO_3Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
117TRNSP_CT_NO_4Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
118TRNSP_CT_NO_5Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
119TRNSP_CT_NO_6Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
120TRNSP_CT_NO_7Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
121TRNSP_CT_NO_8Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
122TRNSP_CT_NO_9Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
123TRNSP_CT_NO10Transporter contract numbernvarchar100CHAR(N' ')YesOIUVL_TRNSP_CT_NO Allow NULL? 
124INT_ENTL_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
125INT_ENTL_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
126INT_ENTL_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
127INT_ENTL_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
128INT_ENTL_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
129INT_ENTL_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
130INT_ENTL_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
131INT_ENTL_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
132INT_ENTL_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
133INT_ENTL_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
134EXT_ENTL_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
135EXT_ENTL_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
136EXT_ENTL_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
137EXT_ENTL_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
138EXT_ENTL_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
139EXT_ENTL_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
140EXT_ENTL_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
141EXT_ENTL_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
142EXT_ENTL_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
143EXT_ENTL_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
144EXT_ENTL_MCR_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
145EXT_ENTL_MCR_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
146EXT_ENTL_MCR_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
147EXT_ENTL_MCR_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
148EXT_ENTL_MCR_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
149EXT_ENTL_MCR_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
150EXT_ENTL_MCR_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
151EXT_ENTL_MCR_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
152EXT_ENTL_MCR_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
153EXT_ENTL_MCR_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
154INT_SETT_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
155INT_SETT_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
156INT_SETT_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
157INT_SETT_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
158INT_SETT_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
159INT_SETT_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
160INT_SETT_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
161INT_SETT_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
162INT_SETT_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
163INT_SETT_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
164EXT_SETT_MKCT_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
165EXT_SETT_MKCT_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
166EXT_SETT_MKCT_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
167EXT_SETT_MKCT_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
168EXT_SETT_MKCT_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
169EXT_SETT_MKCT_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
170EXT_SETT_MKCT_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
171EXT_SETT_MKCT_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
172EXT_SETT_MKCT_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
173EXT_SETT_MKCT_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
174EXT_SETT_MCR_1Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
175EXT_SETT_MCR_2Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
176EXT_SETT_MCR_3Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
177EXT_SETT_MCR_4Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
178EXT_SETT_MCR_5Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
179EXT_SETT_MCR_6Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
180EXT_SETT_MCR_7Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
181EXT_SETT_MCR_8Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
182EXT_SETT_MCR_9Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
183EXT_SETT_MCR_10Gross Other Marketing Amountdecimal112CURR((0))YesOIUH_GROSS_OTH_MARKETING_AMT
184SM_SETT_BTU_FACOIUH_DEC7_3decimal73DEC((0))YesOIUH_DEC7_3
185TOTAL_TAX_PC_1Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
186TOTAL_TAX_PC_2Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
187TOTAL_TAX_PC_3Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
188TOTAL_TAX_PC_4Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
189TOTAL_TAX_PC_5Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
190TOTAL_TAX_PC_6Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
191TOTAL_TAX_PC_7Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
192TOTAL_TAX_PC_8Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
193TOTAL_TAX_PC_9Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
194TOTAL_TAX_PC_10Total tax percentagedecimal98DEC((0))YesOIUVL_TOTAL_TAX_PC
195ACTL_ST_TAX_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
196ACTL_ST_TAX_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
197ACTL_ST_TAX_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
198ACTL_ST_TAX_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
199ACTL_ST_TAX_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
200ACTL_ST_TAX_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
201ACTL_ST_TAX_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
202ACTL_ST_TAX_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
203ACTL_ST_TAX_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
204ACTL_ST_TAX_10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
205ACTL_ST_TAX_RM_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
206ACTL_ST_TAX_RM_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
207ACTL_ST_TAX_RM_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
208ACTL_ST_TAX_RM_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
209ACTL_ST_TAX_RM_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
210ACTL_ST_TAX_RM_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
211ACTL_ST_TAX_RM_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
212ACTL_ST_TAX_RM_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
213ACTL_ST_TAX_RM_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
214ACTL_ST_TAX_RM10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
215GROSS_ST_TAX_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
216GROSS_ST_TAX_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
217GROSS_ST_TAX_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
218GROSS_ST_TAX_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
219GROSS_ST_TAX_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
220GROSS_ST_TAX_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
221GROSS_ST_TAX_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
222GROSS_ST_TAX_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
223GROSS_ST_TAX_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
224GROSS_ST_TAX_10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
225VL_TAX_RATE_PC_1Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
226VL_TAX_RATE_PC_2Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
227VL_TAX_RATE_PC_3Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
228VL_TAX_RATE_PC_4Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
229VL_TAX_RATE_PC_5Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
230VL_TAX_RATE_PC_6Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
231VL_TAX_RATE_PC_7Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
232VL_TAX_RATE_PC_8Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
233VL_TAX_RATE_PC_9Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
234VL_TAX_RATE_PC10Volume tax ratedecimal76DEC((0))YesOIUVL_VL_TAX_RAT
235ENTL_ST_TAX_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
236ENTL_ST_TAX_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
237ENTL_ST_TAX_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
238ENTL_ST_TAX_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
239ENTL_ST_TAX_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
240ENTL_ST_TAX_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
241ENTL_ST_TAX_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
242ENTL_ST_TAX_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
243ENTL_ST_TAX_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
244ENTL_ST_TAX_10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
245ENTL_ST_TAX_RM_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
246ENTL_ST_TAX_RM_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
247ENTL_ST_TAX_RM_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
248ENTL_ST_TAX_RM_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
249ENTL_ST_TAX_RM_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
250ENTL_ST_TAX_RM_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
251ENTL_ST_TAX_RM_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
252ENTL_ST_TAX_RM_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
253ENTL_ST_TAX_RM_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
254ENTL_ST_TAX_RM10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
255SETT_ST_TAX_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
256SETT_ST_TAX_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
257SETT_ST_TAX_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
258SETT_ST_TAX_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
259SETT_ST_TAX_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
260SETT_ST_TAX_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
261SETT_ST_TAX_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
262SETT_ST_TAX_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
263SETT_ST_TAX_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
264SETT_ST_TAX_10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
265SETT_ST_TAX_RM_1Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
266SETT_ST_TAX_RM_2Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
267SETT_ST_TAX_RM_3Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
268SETT_ST_TAX_RM_4Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
269SETT_ST_TAX_RM_5Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
270SETT_ST_TAX_RM_6Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
271SETT_ST_TAX_RM_7Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
272SETT_ST_TAX_RM_8Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
273SETT_ST_TAX_RM_9Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
274SETT_ST_TAX_RM10Tax amountdecimal112CURR((0))YesOIUH_TAX_AMOUNT
275SM_RCVBL_MPMeasurement point numbernvarchar200CHAR(N' ')Yes*OIU_MP_NO Allow NULL? 
276TOT_TAX_RM_PC_1Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
277TOT_TAX_RM_PC_2Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
278TOT_TAX_RM_PC_3Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
279TOT_TAX_RM_PC_4Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
280TOT_TAX_RM_PC_5Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
281TOT_TAX_RM_PC_6Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
282TOT_TAX_RM_PC_7Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
283TOT_TAX_RM_PC_8Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
284TOT_TAX_RM_PC_9Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
285TOT_TAX_RM_PC_10Total tax reimbursement percentagedecimal98DEC((0))YesOIUVL_TOL_TAX_REIMB_PC
286GPLT_VNAMEGas Plant Venturenvarchar60CHAR(N' ')Yes*OIU_GPLT_VNAME Allow NULL? 
287GPLT_DOI_DOIGasplant DOI Nonvarchar50CHAR(N' ')Yes*OIU_GPLT_DOI_NO Allow NULL? 
288ACTL_WLR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
289ENTL_WLR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
290SETT_WLR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
291EXT_PROP_NO_1External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
292EXT_DOI_NO_1External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
293EXT_PROP_NO_2External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
294EXT_DOI_NO_2External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
295EXT_PROP_NO_3External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
296EXT_DOI_NO_3External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
297EXT_PROP_NO_4External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
298EXT_DOI_NO_4External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
299EXT_PROP_NO_5External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
300EXT_DOI_NO_5External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
301EXT_PROP_NO_6External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
302EXT_DOI_NO_6External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
303EXT_PROP_NO_7External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
304EXT_DOI_NO_7External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
305EXT_PROP_NO_8External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
306EXT_DOI_NO_8External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
307EXT_PROP_NO_9External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
308EXT_DOI_NO_9External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
309EXT_PROP_NO_10External venture namenvarchar60CHAR(N' ')YesOIUVL_EXT_VNAME Allow NULL? 
310EXT_DOI_NO_10External division of interest numbernvarchar50CHAR(N' ')YesOIUVL_EXT_DOI_NO Allow NULL? 
311INT_PROP_NO_1Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
312INT_DOI_NO_1Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
313INT_PROP_NO_2Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
314INT_DOI_NO_2Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
315INT_PROP_NO_3Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
316INT_DOI_NO_3Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
317INT_PROP_NO_4Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
318INT_DOI_NO_4Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
319INT_PROP_NO_5Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
320INT_DOI_NO_5Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
321INT_PROP_NO_6Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
322INT_DOI_NO_6Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
323INT_PROP_NO_7Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
324INT_DOI_NO_7Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
325INT_PROP_NO_8Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
326INT_DOI_NO_8Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
327INT_PROP_NO_9Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
328INT_DOI_NO_9Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
329INT_PROP_NO_10Internal venture namenvarchar60CHAR(N' ')YesOIUVL_INT_VNAME Allow NULL? 
330INT_DOI_NO_10Internal division of interest numbernvarchar50CHAR(N' ')YesOIUVL_INT_DOI_NO Allow NULL? 
331SM_REMITTER_NOSeller Numbernvarchar60CHAR(N' ')YesOIUH_SELLER_NUMBER Allow NULL? 
332SM_REMITT_SEQ_NOSeller Sequence Numbernvarchar20CHAR(N' ')YesOIUH_SELLER_SEQUENCE_NUMBER Allow NULL? 
333GASLIFT_WL_NOWell ID numbernvarchar150CHAR(N' ')Yes*OIU_WL_NO Allow NULL? 
334GASLIFT_WC_NOWell Completion Numbernvarchar50CHAR(N' ')Yes*OIU_WC_NO Allow NULL? 
335RELATED_CTRelated Contractnvarchar100CHAR(N' ')Yes*OIU_RELATED_CT Allow NULL? 
336CT_TYPE_CDContract Typenvarchar20CHAR(N' ')Yes*OIU_CT_TYPE_CD Allow NULL? 
337DOI_SUM_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
338DUAL_ACCT_FLDual Accounting Flagchar10CHAR(N' ')YesOIU_DUAL_ACCT_FL Allow NULL? 
339ORIG_MP_NOMeasurement point numbernvarchar200CHAR(N' ')Yes*OIU_MP_NO Allow NULL? 
340VNAME_TYPE_CDVenture Usage Typenvarchar20CHAR(N' ')YesOIU_VNAME_TYPE_CD Allow NULL? 
341SM_TAX_GRNT_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
342TAX_RMB_GRNTOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
343SM_NRTF_CDOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
344SM_REC_PYMT_CDOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
345IGN_PYMT_CDOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
346BY_SLL_CT_NOBuy/Sell Contractnvarchar100CHAR(N' ')Yes*OIU_BY_SLL_CT_NO Allow NULL? 
347BY_SLL_VALBuy/Sell Valuedecimal132CURR((0))YesOIU_BY_SLL_VAL
348BRD_CDBrand Codenvarchar40CHAR(N' ')Yes*OIU_BRD_CD Allow NULL? 
349SM_LSE_VOLJE Transaction Quantitydecimal112DEC((0))YesOIUH_TRANS_QUANTITY
350SM_LSE_VALJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
351SM_PCT_RET_LSEPercent Returned to Leasedecimal74DEC((0))YesOIU_PCT_RET_LSE
352SM_TIK_PA_PCProcessing Agreements Percentdecimal73DEC((0))YesOIU_TIK_PA_PC
353SM_ENTL_CT_DECMContract Decimaldecimal98DEC((0))YesOIU_CT_DECM
354SM_RM_FEE_FLOIUH_CHAR1char10CHAR(N' ')YesOIUH_CHAR1 Allow NULL? 
355SECT_VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
356SECT_DOI_NODivision of interest (DOI)nvarchar50CHAR(N' ')Yes*OIU_DOI_NO Allow NULL? 
357COST_CENTERCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
358UNIT_OF_MEAS_CDUnit of Measure Codenvarchar30CHAR(N' ')YesOIUH_UNIT_OF_MEASURE Allow NULL? 
359ACTL_PTR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
360ENTL_PTR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
361SETT_PTR_VL_AMJE Transaction Amountdecimal112CURR((0))YesOIUH_TRANS_AMT
NamePrimaryUniqueTypeColumns
OIURV_DOC_RDSUM~0YesYesCLUSTEREDLINE_NO, DOC_YEAR, DOC_NO, MANDT