OIUX6_WY_GTAXSTG

Tax 2.0 - Wyoming Gross Prod Tax Transactions Staging | #transactional | Component: Tax Reporting
Column Name Description
MANDT Client
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
VL_TYPE_CD FK Volume type code
TAX_CLS FK Tax Class
REV_BOOK_ADJ_IND Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross Value
TAX_VAL Taxable Value
EXEMPT_VAL_01 Exempt Value
EXEMPT_VAL_02 Exempt Value
EXEMPT_VAL_03 Exempt Value
EXEMPT_VAL_04 Exempt Value
EXEMPT_VAL_05 Exempt Value
MKT_COST_01 Marketing Cost
MKT_COST_02 Marketing Cost
MKT_COST_03 Marketing Cost
MKT_COST_04 Marketing Cost
MKT_COST_05 Marketing Cost
MKT_COST_06 Marketing Cost
MKT_COST_07 Marketing Cost
MKT_COST_08 Marketing Cost
MKT_COST_09 Marketing Cost
MKT_COST_10 Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
SV_TAX_AMT Tax 2.0 - Severance Tax Amount
SA_TAX_AMT Tax 2.0 - Wyoming Shoshone Arapaho Tax Amount
AV_TAX_AMT Tax 2.0 - Wyoming Ad Valorem Tax Amount
XX_TAX_AMT Tax 2.0 - XX Tax Amount
PREV_TAX_PAID Tax 2.0 - Previous Tax Paid
TAX_REIMB Tax Reimbursement
BLPS_GROSS_VAL Tax 2.0 - Wyoming Before Lease Plant Split Gross Value
PLANT_PROC_ALLOW Tax 2.0 - Wyoming Plant Processing Allowance
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Tax 2.0 - Reversal/Booking/Reversal Adjustment/Adjustment Show values
FORM_TYPE Tax 2.0 - Original / Amended / Unknown Indicator Show values
OPERATED_FLAG Tax 2.0 - Operated Flag Show values
MASTER_LEVEL Texas Master Data Level Show values
RATE_CODE Tax 2.0 - Wyoming Rate Code Show values
OGIND Oil and Gas Indicator Show values
OPTION3 Tax 2.0 - Indicator to identify external data update Show values
REJ_SUSP_IND Rejection-Suspension Status Show values
Column Name Description Domain name
PAY_FL Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
RPT_FL State Severance Tax Reporting Indicators CHAR1
GROSS_VOL Gross Volume OIUX3_SIGNED_DEC_11_2
WET_LESS_RES Tax 2.0 - Wet Less Residue Volume (MCF) OIUX3_SIGNED_DEC_11_2
BLPS_GROSS_VOL Tax 2.0 - Wyoming Before Lease Plant Split Gross Volume OIUX3_SIGNED_DEC_11_2
RET_LSE_PC Percent Returned to Lease OIU_PERCENT63
API_WELL_NUMBER Tax 2.0 - Wyoming API Well Number
SIDE_TRACK_NO Tax 2.0 - Wyoming Side Track Number
RESERVOIR Tax 2.0 - Wyoming Reservoir
RPT_GRP_NO Tax 2.0 - Wyoming Report Group Number OIUX6_WY_REPORT_GROUP_NUMBER
FIELD_NAME Tax 2.0 - Wyoming Field Name
LEASE_UNIT_NAME Tax 2.0 - Wyoming Lease Unit Name / API CHAR35
TAX_DISTRICT Tax 2.0 - Wyoming Tax District NUMC4
GAS_PLANT_NAME Tax 2.0 - WY Gas Plant Name
OPERATOR_ID Tax 2.0 - Wyoming Operator ID OIUX6_WY_OPERATOR_ID
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
OPTION1 null
OPTION2 null
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Company Code
Tax 2.0 - Wyoming County Identifier
  • ?
  • Client
  • ?
  • Tax 2.0 - Wyoming County Identifier
  • OIUX6_WY_GTAXSTG.[column in domain "LAND1"] == OIU_CM_LXSGL.LAND1
  • OIUX6_WY_GTAXSTG.MANDT == OIU_CM_LXSGL.MANDT
  • OIUX6_WY_GTAXSTG.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_LXSGL.PRI_GEO_LOC
  • OIUX6_WY_GTAXSTG.COUNTY == OIU_CM_LXSGL.SEC_GEO_LOC
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Measurement point number
Full three char. product code (Major and Detail Products) OIUX6_WY_GTAXSTG.PDCD == OIUX3_PDCD.PDCD
Rejection Code
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • OIUX6_WY_GTAXSTG.MANDT == T006.MANDT
  • OIUX6_WY_GTAXSTG.UOM == T006.MSEHI
Volume type code OIUX6_WY_GTAXSTG.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number