OIUX7_WY_GSALHST

Tax 2.0 - WYGP Sales History | #transactional | Component: Tax Reporting
Column Name Description
MANDT FK Client
SALES_DT Sales Date / Month
DN_NO FK Delivery network number
WL_NO FK Well ID number
WC_NO FK Well Completion Number
PDCD FK Full three char. product code (Major and Detail Products)
CT_NO FK Contract Number
OWN_NO FK PRA owner
OWN_INT_TYPE_CD FK Participant Interest Type
OWN_ISQ_NO Owner Interest Sequence Number
Column Name Description
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
PAY_CD Pay Code Show values
OGIND Oil and Gas Indicator Show values
TIK Tax 2.0 - TIK Flag Show values
Column Name Description Domain name
GROSS_VOL Gross Volume OIUX3_SIGNED_DEC_11_2
RPT_GRP_NO Tax 2.0 - Wyoming Report Group Number OIUX6_WY_REPORT_GROUP_NUMBER
PROD_YEAR Tax 2.0 - Production Year
BA_NO Business Associate OIUCM_BUS_ASSOC
BA_SEQ_NO Sequence Number OIUCM_SEQ_NO
OPERATOR_ID Tax 2.0 - Wyoming Operator ID OIUX6_WY_OPERATOR_ID
OPERATOR Master Record OIUCM_MASTER
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
Contract Number
Contract Type OIUX7_WY_GSALHST.CT_TYPE_CD == OIU_CM_CTTYP.CT_TYPE_CD
Delivery network number
Client OIUX7_WY_GSALHST.MANDT == T000.MANDT
Participant Interest Type OIUX7_WY_GSALHST.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • OIUX7_WY_GSALHST.MANDT == LFA1.MANDT
  • OIUX7_WY_GSALHST.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) OIUX7_WY_GSALHST.PDCD == OIUX3_PDCD.PDCD
Measurement unit
  • OIUX7_WY_GSALHST.MANDT == T006.MANDT
  • OIUX7_WY_GSALHST.UOM == T006.MSEHI
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number