I_PRAWellCompletionVH

Well Completion | view: IPVWELLCOMPLTNVH | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: OIU_PR_WC
Column Name Description
Well FK Well ID number
WellCompletion Well Completion Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WellCompletionLatitude Latitude number Show values
WellCompltnLatitudeDirection Latitude direction code Show values
WellCompletionLongitude Longitude Show values
WellCompltnLongitudeDirection Longitude Direction Code Show values
CoalBedMethaneRptgIsEnabled Coal Bed Methane Indicator Show values
Column Name Description Domain name
WellCompletionName Well completion name OIU_TEXT35
APIWellCompletionNumber API well completion number OIU_API_WC_NO
AlternateWellCompletionKey Alternate WC Key CHAR40
WellCompletionHier Well Completion Hierarchy Group CHAR15
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
Master Data Relations Join Conditions
Country
  • Country/Region Key
  • Client
  • I_PRAWELLCOMPLETIONVH.COUNTRY == T005.LAND1
  • I_PRAWELLCOMPLETIONVH.MANDT == T005.MANDT
Development Program
  • Client
  • Development program number
Field
  • Field ID
  • Client
Platform Number
  • Client
  • Platform number
  • I_PRAWELLCOMPLETIONVH.MANDT == OIU_PR_PF.MANDT
  • I_PRAWELLCOMPLETIONVH.OFFSHOREPLATFORM == OIU_PR_PF.PF_NO
Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
Reservoir
  • Client
  • Reservoir ID
Zone
  • Client
  • Reservoir ID
  • Reservoir zone
Secondary geographic location
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
  • Secondary geographic location
  • I_PRAWELLCOMPLETIONVH.COUNTRY == OIU_CM_LXSGL.LAND1
  • I_PRAWELLCOMPLETIONVH.MANDT == OIU_CM_LXSGL.MANDT
  • I_PRAWELLCOMPLETIONVH.PRIMARYGEOGRLLOCATION == OIU_CM_LXSGL.PRI_GEO_LOC
  • I_PRAWELLCOMPLETIONVH.SECONDARYGEOGRLLOCATION == OIU_CM_LXSGL.SEC_GEO_LOC
Well
  • Client
  • Well ID number
Purpose
  • Client
  • Well purpose code