OIUT5_TAXHSTP - Tax 2.0 OK - Tax Transaction History (PUN Level)

Tax 2.0 OK - Tax Transaction History (PUN Level) information is stored in SAP table OIUT5_TAXHSTP.
It is part of development package OIU_T5 in software component IS-OIL-PRA-REP-TAX. This development package consists of objects that can be grouped under "Oklahoma Tax Reporting SLA".

Fields for table OIUT5_TAXHSTP

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
.INCLUDEROIUX5_OK_TAXTXN_KEYXROIUX5_OK_TAXTXN_KEY0
.INCLUDEROIUX5_OK_REVTXN_KEYXROIUX5_OK_REVTXN_KEY0
BUKRSCompany CodeXBUKRSCHAR8OIU_CM_COMPC
SALES_DTSales Date / MonthXOIU_SALE_DTDATS16
PDCDFull three char. product code (Major and Detail Products)XOIU_FULL_PD_CDCHAR6OIUX3_PDCD
WL_NOWell ID numberXOIU_WL_NOCHAR30OIU_PR_WELL
WC_NOWell Completion NumberXOIU_WC_NOCHAR10OIU_PR_WC
MP_NOMeasurement point numberXOIU_MP_NOCHAR40OIU_PR_MP
VNAMEJoint ventureXJV_NAMECHAR12OIU_DO_JV
DOI_NODivision of interest (DOI)XOIU_DOI_NOCHAR10OIU_DO_DI
DN_NODelivery network numberXOIU_DN_NOCHAR40OIU_PR_DN
CT_NOContract NumberXOIU_CT_NOCHAR20OIU_RV_CT
VL_TYPE_CDVolume type codeXOIU_VT_CDCHAR4OIU_PR_VLTYP
TAX_CLSTax ClassXOIU_TAX_CLSCHAR8OIU_CM_TAXCLS
PUNTax 2.0 - OKGP15 - Production Unit NumberXOIUT5_PRODUCTION_UNIT_NONUMC28
REV_BOOK_ADJ_INDTax 2.0 - Reversal/Booking/Reversal Adjustment/AdjustmentXOIUX5_REV_BOOK_REVADJ_ADJ_INDCHAR2
ALLOC_PERCENTTax 2.0 - Allocation PercentageOIUX5_ALLOCATION_PERCENTAGEDEC5
.INCLUDEROIUT5_TAXTXN_NONKEYROIUT5_TAXTXN_NONKEY0
PROD_PURC_INDProducer or PurchaserOIUX3_PRODUCER_PURCHASER_INDCHAR2
UNIT_VNAMEJoint ventureJV_NAMECHAR12OIU_DO_JV
PAY_FLTax Severance Tax Calculation Payment Obligations TypesOIU_SEVT_PAY_FLCHAR2
RPT_FLState Severance Tax Reporting IndicatorsOIU_SEVT_RPT_FLCHAR2
UOMMeasurement unitOIU_MEAS_UUNIT6T006
VAL_TAX_RATValue tax rateOIUVL_VAL_TAX_RATDEC4
OTHER_PARTYMaster RecordOIUCM_MASTERCHAR20
DOC_NOVal. document numberOIURV_DOCNRCHAR40*
DOC_YEARDocument yearOIU_DOC_YEARNUMC8
OPTION1Single-Character FlagCHAR1CHAR2
OPTION2Single-Character FlagCHAR1CHAR2
OPTION3Single-Character FlagCHAR1CHAR2
INTERFACE_FLSingle-Character FlagCHAR1CHAR2
OOS_FLOut of StatuteOIUX3_OUT_OF_STATUTECHAR2
.INCLUDEROIUT5_TAXTXN_NONKEY_NUMERICROIUT5_TAXTXN_NONKEY_NUMERIC0
GROSS_VOLGross VolumeOIUX3_GROSS_VOLUMEDEC6
GROSS_VALGross ValueOIUX3_GROSS_VALUECURR6
TAX_VOLTaxable VolumeOIUX3_TAXABLE_VOLUMEDEC6
TAX_VALTaxable ValueOIUX3_TAXABLE_VALUECURR6
EXE_ENTTYPE1_VOLTax 2.0 - Exempt Entity Type 1 VolumeOIUX5_EXEMPT_ENTITY_TYPE_1_VOLDEC6
EXE_ENTTYPE1_VALTax 2.0 - Exempt Entity Type 1 ValueOIUX5_EXEMPT_ENTITY_TYPE_1_VALCURR6
EXE_ENTTYPE2_VOLTax 2.0 - Exempt Entity Type 2 VolumeOIUX5_EXEMPT_ENTITY_TYPE_2_VOLDEC6
EXE_ENTTYPE2_VALTax 2.0 - Exempt Entity Type 2 ValueOIUX5_EXEMPT_ENTITY_TYPE_2_VALCURR6
EXE_ENTTYPE3_VOLTax 2.0 - Exempt Entity Type 3 VolumeOIUX5_EXEMPT_ENTITY_TYPE_3_VOLDEC6
EXE_ENTTYPE3_VALTax 2.0 - Exempt Entity Type 3 ValueOIUX5_EXEMPT_ENTITY_TYPE_3_VALCURR6
EXE_ENTTYPE4_VOLTax 2.0 - Exempt Entity Type 4 VolumeOIUX5_EXEMPT_ENTITY_TYPE_4_VOLDEC6
EXE_ENTTYPE4_VALTax 2.0 - Exempt Entity Type 4 ValueOIUX5_EXEMPT_ENTITY_TYPE_4_VALCURR6
EXE_ENTTYPE5_VOLTax 2.0 - Exempt Entity Type 5 VolumeOIUX5_EXEMPT_ENTITY_TYPE_5_VOLDEC6
EXE_ENTTYPE5_VALTax 2.0 - Exempt Entity Type 5 ValueOIUX5_EXEMPT_ENTITY_TYPE_5_VALCURR6
EOR_VOLEOR VolumeOIU_EOR_VLQUAN7
EOR_VALEOR ValueOIU_EOR_VALCURR8
MKT_COSTMarketing CostOIUX3_MARKETING_COSTCURR6
MKT_COST_REIMBMarketing Cost ReimbursementOIUX3_MARKETING_COST_REIMBCURR6
GP_TAX_AMTTax 2.0 - Gross Production Tax AmountOIUX5_GROSS_PROD_TAX_AMOUNTCURR6
PE_TAX_AMTTax 2.0 - Petroleum Excise Tax AmountOIUX5_PETRO_EXCISE_TAX_AMOUNTCURR6
RF_TAX_AMTTax 2.0 - Revolving Fund Tax AmountOIUX5_REVOLVE_FUND_TAX_AMOUNTCURR6
MP_TAX_AMTTax 2.0 - Marginally Producing Tax AmountOIUX5_MARGINAL_PROD_TAX_AMOUNTCURR6
KW_TAX_AMTTax 2.0 - Kiowa Tax AmountOIUX5_KIOWA_TAX_AMOUNTCURR6
CA_TAX_AMTTax 2.0 - Cheyenne/Arapaho Tax AmountOIUX5_CHEYENNE_ARAPAHO_TAX_AMTCURR6
XX_TAX_AMTTax 2.0 - XX Tax AmountOIUX5_XX_TAX_AMTCURR6
.INCLUDEROIUT5_TAXTXN_NONKEY_DERIVEDROIUT5_TAXTXN_NONKEY_DERIVED0
EXEMPT_CODE_1Tax 2.0 OKGP - Entity Type 01 Exempt CodeOIUT5_EXEMPT_CODE_1NUMC4OIUT5_EXCD
EXEMPT_CODE_2Tax 2.0 OKGP - Entity Type 02 Exempt CodeOIUT5_EXEMPT_CODE_2NUMC4OIUT5_EXCD
EXEMPT_CODE_3Tax 2.0 OKGP - Entity Type 03 Exempt CodeOIUT5_EXEMPT_CODE_3NUMC4OIUT5_EXCD
EXEMPT_CODE_4Tax 2.0 OKGP - Entity Type 04 Exempt CodeOIUT5_EXEMPT_CODE_4NUMC4OIUT5_EXCD
EXEMPT_CODE_5Tax 2.0 OKGP - Entity Type 05 Exempt CodeOIUT5_EXEMPT_CODE_5NUMC4OIUT5_EXCD
MASTER_LEVELTax 2.0 - Master LevelOIUX5_MASTER_LEVELCHAR2
PROD_PURCH_NOTax 2.0 - Oklahoma Producer/Purchaser NumberOIUX5_OK_PROD_PURCH_NUMBERNUMC10
OK_PRODUCT_CODETax 2.0 - Oklahoma Product CodeOIUX5_OK_PRODUCT_CODENUMC2
TAXPAYER_NUMBERTax 2.0 - Oklahoma Taxpayer NumberOIUX5_OK_TAXPAYER_NUMBERNUMC10
FEIN_SSNTax 2.0 - FEIN/SSNOIUX3_FEIN_SSNNUMC18
REFERENCE_RUN_IDRun ID of Tax ReportOIUX3_RUN_IDNUMC20
PRODUCTION_DATETax 2.0 OK - Production Date (YYYYMM)OIUT5_PRODUCTION_DATEACCP12
.INCLUDEOIU_CREATIONOIU_CREATION0
OIU_CRUSERName of Person Responsible for Creating the ObjectERNAMCHAR24
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)TZNTSTMPSDEC8
Privacy Policy