OIUX5_OK_MASTER

Tax 2.0 - Oklahoma Master Data | #masterdata | Component: Tax Reporting
Column Name Description
MANDT FK Client
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO FK Measurement point number
BUKRS FK Company Code
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
EFF_FROM_DT Effective from date
Column Name Description
Column Name Description
Column Name Description
EFF_FROM_DT Effective from date
EFF_TO_DT Effective To Date
CHANGE_DATE Date of Last Change
CHANGE_TIME Time of Last Change
Column Name Description
GAS_CODE Tax 2.0 - Oklahoma Gas Code Show values
OIL_CLASS Tax 2.0 - Oklahoma Oil Classification Show values
MULTI_COUNTIES Tax 2.0 - Multiple Counties? Show values
NGPA_CD Tax 2.0 OKGP – NGPA Code (Tax Incentive Rate Code) Show values
Column Name Description Domain name
CHANGE_USER Last Changed By USNAM
Master Data Relations Join Conditions
Company Code
Tax 2.0 - Oklahoma County
  • ?
  • Client
  • ?
  • Tax 2.0 - Oklahoma County
  • OIUX5_OK_MASTER.[column in domain "LAND1"] == OIU_CM_LXSGL.LAND1
  • OIUX5_OK_MASTER.MANDT == OIU_CM_LXSGL.MANDT
  • OIUX5_OK_MASTER.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_LXSGL.PRI_GEO_LOC
  • OIUX5_OK_MASTER.COUNTY == OIU_CM_LXSGL.SEC_GEO_LOC
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Client OIUX5_OK_MASTER.MANDT == T000.MANDT
Measurement point number
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number