GHO_IFLOT_EXT

Function location extension table | #masterdata | Component: UOM: Master Data
Column Name Description
MANDT Client
TPLNR FK Functional Location
Column Name Description
Column Name Description
Column Name Description
GHO_CONN_DATE Connection Date
GHO_COMPL_DATE Well Completion Date
GHO_PLABAND_DATE Well Plug and Abandon Date
GHO_WC_COMP_DATE Date
GHO_PN_SBD Start of Business Day
Column Name Description
TWP_DIR_CD Township direction code Show values
RNG_DIR_CD Range Diection Code Show values
MMS_OWNER_CD MMS Ownership Code Show values
COMMINGLD_WC_IND Commingled Well Completion Indicator Show values
CBM_INDICATOR Coal Bed Methane Indicator Show values
GHO_SHORE_IND Well Shore Indicator Show values
GHO_PN_NW_ALLOC Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
GHO_SUBSURF_IND Well Subsurface Indicator Show values
GHO_CHAIN_IND Network Object Indicator to Allow Network Chaining Show values
GHO_TERMPT_IND Termination Point Show values
Column Name Description Domain name
GHO_EXTENAL_ID Unique External ID GHO_EXTENAL_ID
LGORT_D Storage location LGORT
SYSTEM_ID System ID GHO_MII_INSTANCE
GHO_WELL_NAME Well Name GHO_WELL_NAME
GHO_WELLNAME_ALT Alternative Well Name GHO_WELL_NAME_ALT
WELL_TYPE Well Type GHO_GEN_TYPE
FLD_SYS_WELL_ID Field System Object ID GHO_FLD_SYS_OBJ_ID
WELL_TEST_TYPE Well Test Type GHO_WTYPE
PLNTY Task List Type PLNTY
PLNNR Key for Task List Group PLNNR
PLNAL Group Counter ALTNR
AUART Order Type for Maintenance Orders AUFART
API_NO API well number OIU_WLAPI
LCL_WL_NO Regional Identifier
QTR_1_NO Quarter 1 Number CHAR2
QTR_2_NO Quarter 2 Number CHAR2
SECTION_NO Section Number CHAR3
TWP_NO Township number CHAR3
RNG_NO Range number CHAR3
SLOT_NO Slot Number (Base Meridian) OIU_SLOT_NO
GHO_WC_REF_ID Well Reference TPLNR
GHO_WC_NAME Well Completion Name GHO_WELL_NAME
GHO_WC_NAME_ALT Alternative Well Completion Name GHO_WELL_NAME_ALT
GHO_WC_TYPE Well Completion Type GHO_GEN_TYPE
FLD_SYS_WC_ID Field System Object ID GHO_FLD_SYS_OBJ_ID
WC_WELLTEST_TYPE Well Test Type GHO_WTYPE
WC_PLNTY Task List Type PLNTY
WC_PLNNR Key for Task List Group PLNNR
WC_PLNAL Group Counter ALTNR
WC_AUART Order Type for Maintenance Orders AUFART
API_WC_NO API well completion number OIU_API_WC_NO
REGIONAL_WL_NO Local Well Number
API_SIDT Reg.Reporting - API Side Track
OR1_OR_LVL_1_NO Org. Level 1 - Company OIUH_OR_LVL_1_NO
OR1_OR_LVL_1_NM Name of highest organization level ( Compy Code) CHAR40
OR2_OR_LVL_2_NO Second-highest organization level number ( Company Code) CHAR1
OR2_OR_LVL_2_NM Name of second-highest organization level ( Compy Code) CHAR14
OR3_OR_LVL_3_NO Third-highest organization level number ( Company Code) CHAR3
OR3_OR_LVL_3_NM Name of third-highest organization level ( Compy Code) CHAR14
OR4_OR_LVL_4_NO Fourth-highest organization level number ( Company Code) CHAR2
OR4_OR_LVL_4_NM Name of fourth-highest organization level ( Compy Code) CHAR14
OPERATORS Operator KUNNR
GHO_WELLCLASS_ID Well Class ID GHO_WELLCLASS_ID
GHO_SUB_ADDRNUM Address Number AD_ADDRNUM
GHO_RESERVOIR Reservoir GHO_PE_ID
GHO_CONCESSION Concession GHO_PE_ID
GHO_PLATFORM Platform Type GHO_AGGR_TYPE
GHO_FIELD Field GHO_PE_ID
GHO_MTR_DESCR Meter Description GHO_WC_DESCR
GHO_MTR_TYPE Meter Type GHO_GEN_TYPE
GHO_MTR_OP_MODE Meter Operating Mode GHO_WC_TYPE
GHO_MTR_DESN_PRE Meter Design Pressure GHO_MTR_PRESSURE
GHO_MTR_OP_PRE Meter Operating Pressure GHO_MTR_PRESSURE
GHO_MTR_DESN_TEM Meter Design Temperature GHO_MTR_PRESSURE
GHO_MTR_OP_TEMP Meter Operating Temperature GHO_MTR_PRESSURE
GHO_MTR_LVR_FROM Meter Liquid Viscosity Range From GHO_MTR_PRESSURE
GHO_MTR_LVR_TO Meter Liquid Viscosity Range To GHO_MTR_PRESSURE
GHO_MTR_LQD_RAT Meter Water / Liquid Ratio GHO_MTR_LIQD_RATIO_FRAC
GHO_MTR_VOL_FRA Meter Gas / Volume Fraction GHO_MTR_LIQD_RATIO
GHO_MTR_LQD_VOL Meter Liquid / Volume Fraction GHO_MTR_LIQD_RATIO_FRAC
GHO_MTR_LQDRATUI Meter Water / Liquid Ratio for UI GHO_MTR_LIQD_RATIO_UI
GHO_MTR_LQDVOLUI Meter Liquid / Volume Fraction for UI GHO_MTR_LIQD_RATIO_UI
GHO_PUMP_DESCR Pump Description GHO_WC_DESCR
GHO_PUMP_TYPE Pump Type GHO_GEN_TYPE
GHO_PUMP_DRIVER Type of Driver GHO_GEN_TYPE
GHO_PUMP_FLUID Fluid Handled GHO_GEN_TYPE
GHO_PUMP_APPL Application GHO_GEN_TYPE
GHO_PUMP_DESIGN Pump Design GHO_GEN_TYPE
GHO_PUMP_PR Power Rating GHO_PUMP_POW_RATE
GHO_PUMP_SP Suction Pressure GHO_PUMP_POW_RATE
GHO_PUMP_DP Discharge Pressure GHO_PUMP_POW_RATE
GHO_PUMP_SPEED Pump Speed GHO_PUMP_SPEED
GHO_UOS Use of Separator GHO_SEP_UOS
GHO_SEP_DP Separator Design Pressure GHO_PRESSURE9
GHO_SEP_OP Operating Pressure GHO_PRESSURE9
GHO_SEP_DT Separator Design Temperature GHO_PRESSURE6
GHO_SEP_OT Operating Temperature GHO_PRESSURE6
CHOKE_SIZE_VAL Choke Size - Unit of Measure GHO_MEASMNT
GHO_COMP_TYPE Compressor Type GHO_GEN_TYPE
GHO_SP_FIRST Suction Pressure 1st Stage GHO_PRESSURE9
GHO_SP_SECOND Suction Pressure 2nd Stage GHO_PRESSURE9
GHO_DP_FIRST Discharge Pressure 1st Stage GHO_PRESSURE9
GHO_DP_SECOND Discharge Pressure 2nd Stage GHO_PRESSURE9
GHO_COMP_DT Discharge Temperature GHO_TEMP6
GHO_COMP_POWER Compressor Power
GHO_TB_TYPE Turbine Type of Driven Unit GHO_GEN_TYPE
GHO_TB_DPR Turbine Power Rating (Design)
GHO_TB_OPR Turbine Power Rating (Operating)
GHO_TB_SPD Turbine Speed
GHO_TB_FL_TYPE Turbine Fuel Type GHO_GEN_TYPE
GHO_OFS Orientation of Flare Stack GHO_GEN_TYPE
GHO_LFS Length of Flare Stack
NETID Network identification NETID
OPERATOR Oil and Gas Entity Operator GHO_PE_OPERATOR
STATUS_PROFILE Status Management Profile ID GHO_D_STAT_PROFILE_ID
AUDIT_PROFILE_ID Audit ID GHO_D_AUDIT_ID
CHEM_ANA_LEVEL Chemical Analysis Level for Capture Measurements GHO_ANALYSIS_LEVEL
USER_STATUS_PROFILE GHO User Status Profile GHO_D_USER_STATUS_PROFILE
SEQNR Tank ID GHO_TANK_ID
TANK_TYPE Tank Type GHO_GEN_TYPE
GHO_ELEVATION_RE Elevation Reference GHO_ELEVATION_REF
GHO_WELL_TVD True Vertical Depth GEOALT
GHO_PERF_FROM WC Perforation From GEOALT
GHO_PERF_TO WC Perforation To GEOALT
GHO_HGR_DEPTH WC Hanger Depth GEOALT
GHO_SHOE_DEPTH WC Shoe Depth GEOALT
GHO_GRND_ELE Ground Elevation OIU_VOLUME_SIGN
GHO_TOP_ELE Top Elevation of Flare Stack GEOALT
GHO_DEH_TYPE Dehydrator Type GHO_GEN_TYPE
GHO_DEH_DSN_TEMP Design Temperature GHO_PRESSURE6
GHO_DEH_OP_TEMP Operating Temperature GHO_PRESSURE6
GHO_HT_CONFIG Heater Treater Configuration GHO_GEN_TYPE
GHO_HT_TMECH Heater Treater- Treater Mechanism GHO_GEN_TYPE
GHO_HT_DESN_TEMP Design Temperature GHO_PRESSURE6
GHO_HT_OP_TEMP Operating Temperature GHO_PRESSURE6
GHO_PIPE_DPRE Pipeline Design Pressure GHO_PIPE_PRESSURE
GHO_LPL Length of Pipeline
GHO_INDIAMETER Pipeline Diameter GHO_DIAM
GHO_OUTDIAMETER Pipeline Diameter GHO_DIAM
GHO_WALLTHICK Wall Thickness of Pipeline GHO_DIAM
GHO_PIPEMATNR Pipeline Material GHO_PIPEMATNR
GHO_MFOLD_DPRE Manifold Design Pressure GHO_MFOLD_PRESSURE
GHO_CLSTR_DESC Cluster Description GHO_CLSTR_DESC
GHO_CLSTR_TYPE Cluster Type GHO_GEN_TYPE
GHO_GEN_TYPE Generic Object Type GHO_GEN_TYPE
SEC_GEO_DESC Secondary Geographical Location Description CHAR30
PN_HIERARCHY Set Name SETNAME
NAME Zone name CHAR35
Master Data Relations Join Conditions
Network Object Type
Reservoir zone
  • ?
  • Reservoir zone
Functional Location
  • GHO_IFLOT_EXT.MANDT == IFLOT.MANDT
  • GHO_IFLOT_EXT.TPLNR == IFLOT.TPLNR