	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

162 COLUMNS | 6 INDEXES | ERP 6.0 | GHO_IFLOT_EXT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Network :: Network Objects
1	ERP EHP7	6.0	GHO_IFLOT_EXT	162	6	Function location extension table	Network Objects

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, TPLNR, GHO_NETOBJ_TYPE, GHO_EXTENAL_ID, LGORT_D, SYSTEM_ID, GHO_WELL_NAME, GHO_WELLNAME_ALT, GHO_CONN_DATE, GHO_COMPL_DATE, WELL_TYPE, GHO_PLABAND_DATE, FLD_SYS_WELL_ID, WELL_TEST_TYPE, PLNTY, PLNNR, PLNAL, AUART, GHO_WC_REF_ID, GHO_WC_NAME, GHO_WC_NAME_ALT, GHO_WC_TYPE, GHO_WC_COMP_DATE, FLD_SYS_WC_ID, COMMINGLD_WC_IND, WC_WELLTEST_TYPE, WC_PLNTY, WC_PLNNR, WC_PLNAL, WC_AUART, GHO_SUB_ADDRNUM, GHO_RESERVOIR, GHO_CONCESSION, GHO_PLATFORM, GHO_FIELD, GHO_SHORE_IND, GHO_MTR_DESCR, GHO_MTR_TYPE, GHO_MTR_OP_MODE, GHO_MTR_DESN_PRE, GHO_MTR_OP_PRE, GHO_MTR_DESN_TEM, GHO_MTR_OP_TEMP, GHO_MTR_LVR_FROM, GHO_MTR_LVR_TO, GHO_MTR_LQD_RAT, GHO_MTR_VOL_FRA, GHO_MTR_LQD_VOL, GHO_MTR_DP_UOM, GHO_MTR_DT_UOM, GHO_MTR_OP_UOM, GHO_MTR_OT_UOM, GHO_MTR_LVRF_UOM, GHO_MTR_LVRT_UOM, GHO_MTR_LQDRATUI, GHO_MTR_LQDVOLUI, GHO_PUMP_DESCR, GHO_PUMP_TYPE, GHO_PUMP_DRIVER, GHO_PUMP_FLUID, GHO_PUMP_APPL, GHO_PUMP_DESIGN, GHO_PUMP_PR, GHO_PUMP_SP, GHO_PUMP_DP, GHO_PUMP_SPEED, GHO_PUMP_PR_UOM, GHO_PUMP_SP_UOM, GHO_PUMP_DP_UOM, GHO_PUMP_SD_UOM, GHO_UOS, GHO_SEP_DP, GHO_SEP_DP_UOM, GHO_SEP_OP, GHO_SEP_OP_UOM, GHO_SEP_DT, GHO_SEP_DT_UOM, GHO_SEP_OT, GHO_SEP_OT_UOM, CHOKE_SIZE_VAL, CHOKE_SIZE_UOM, GHO_COMP_TYPE, GHO_SP_FIRST, GHO_SP_F_UOM, GHO_SP_SECOND, GHO_SP_S_UOM, GHO_DP_FIRST, GHO_DP_F_UOM, GHO_DP_SECOND, GHO_DP_S_UOM, GHO_COMP_DT, GHO_COMP_DT_UOM, GHO_COMP_POWER, GHO_POWER_UOM, GHO_TB_TYPE, GHO_TB_DPR, GHO_TB_DPR_UOM, GHO_TB_OPR, GHO_TB_OPR_UOM, GHO_TB_SPD, GHO_TB_SPD_UOM, GHO_TB_FL_TYPE, GHO_OFS, GHO_LFS, GHO_LFS_UOM, GHO_PN_TZ, GHO_PN_SBD, GHO_PN_NW_ALLOC, NETID, OPERATOR, STATUS_PROFILE, AUDIT_PROFILE_ID, CHEM_ANA_LEVEL, SEQNR, TANK_TYPE, GHO_SUBSURF_IND, GHO_ELEVATION_RE, GHO_WELL_TVD, GHO_PERF_FROM, GHO_PERF_TO, GHO_HGR_DEPTH, GHO_SHOE_DEPTH, GHO_ELEV_UOM, GHO_PERF_UOM, GHO_PERT_UOM, GHO_HGR_DEP_UOM, GHO_SHOE_DEP_UOM, GHO_DEPTH_UOM, GHO_WELL_TVD_UOM, GHO_GRND_ELE, GHO_GE_UOM, GHO_TOP_ELE, GHO_TE_UOM, GHO_DEH_TYPE, GHO_DEH_DSN_TEMP, GHO_DEH_OP_TEMP, GHO_DEH_DT_UOM, GHO_DEH_OT_UOM, GHO_HT_CONFIG, GHO_HT_TMECH, GHO_HT_DESN_TEMP, GHO_HT_OP_TEMP, GHO_HT_DT_UOM, GHO_HT_OT_UOM, GHO_PIPE_DPRE, GHO_PIPE_DP_UOM, GHO_LPL, GHO_LEN_UOM, GHO_INDIAMETER, GHO_IND_UOM, GHO_OUTDIAMETER, GHO_OUTD_UOM, GHO_WALLTHICK, GHO_WT_UOM, GHO_PIPEMATNR, GHO_MFOLD_DPRE, GHO_MFOLD_DP_UOM, GHO_CHAIN_IND, GHO_CLSTR_DESC, GHO_CLSTR_TYPE, GHO_GEN_TYPE, GHO_TERMPT_IND FROM GHO_IFLOT_EXT

TOP ERP 6.0 | GHO_IFLOT_EXT COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	TPLNR	Functional Location	nvarchar	30	0	CHAR	(N' ')	No	IFLOT	TPLNR	Allow NULL?
3	GHO_NETOBJ_TYPE	Network Object Type	nvarchar	10	0	CHAR	(N' ')	Yes	GHO_NETOBJ_TYP	GHO_NETOBJ_TYPE	Allow NULL?
4	GHO_EXTENAL_ID	Unique External ID	nvarchar	16	0	CHAR	(N' ')	Yes		GHO_EXTENAL_ID	Allow NULL?
5	LGORT_D	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	*	LGORT_D	Allow NULL?
6	SYSTEM_ID	System ID	nvarchar	60	0	CHAR	(N' ')	Yes		GHO_MII_INSTANCE	Allow NULL?
7	GHO_WELL_NAME	Well Name	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_WELL_NAME	Allow NULL?
8	GHO_WELLNAME_ALT	Alternative Well Name	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_WELL_NAME_ALT	Allow NULL?
9	GHO_CONN_DATE	Connection Date	nvarchar	8	0	DATS	(N'00000000')	Yes		GHO_WELL_CONN_DATE	Allow NULL?
10	GHO_COMPL_DATE	Well Completion Date	nvarchar	8	0	DATS	(N'00000000')	Yes		GHO_WELL_COMPL_DATE	Allow NULL?
11	WELL_TYPE	Well Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_WELL_TYPE	Allow NULL?
12	GHO_PLABAND_DATE	Well Plug and Abandon Date	nvarchar	8	0	DATS	(N'00000000')	Yes		GHO_WELL_PLUG_ABANDON_DATE	Allow NULL?
13	FLD_SYS_WELL_ID	Field System Object ID	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_FLD_SYS_OBJ_ID	Allow NULL?
14	WELL_TEST_TYPE	Well Test Type	char	1	0	CHAR	(N' ')	Yes		GHO_WTYPE	Allow NULL?
15	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	*	PLNTY	Allow NULL?
16	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
17	PLNAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
18	AUART	Order Type for Maintenance Orders	nvarchar	4	0	CHAR	(N' ')	Yes	*	PM_AUFART	Allow NULL?
19	GHO_WC_REF_ID	Well Reference	nvarchar	30	0	CHAR	(N' ')	Yes	*	GHO_WC_REF_ID	Allow NULL?
20	GHO_WC_NAME	Well Completion Name	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_WC_NAME	Allow NULL?
21	GHO_WC_NAME_ALT	Alternative Well Completion Name	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_WC_NAME_ALT	Allow NULL?
22	GHO_WC_TYPE	Well Completion Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_WC_TYPE	Allow NULL?
23	GHO_WC_COMP_DATE	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
24	FLD_SYS_WC_ID	Field System Object ID	nvarchar	32	0	CHAR	(N' ')	Yes		GHO_FLD_SYS_OBJ_ID	Allow NULL?
25	COMMINGLD_WC_IND	Commingled Well Completion Indicator	char	1	0	CHAR	(N' ')	Yes		GHO_COMMINGLED_WC_IND	Allow NULL?
26	WC_WELLTEST_TYPE	Well Test Type	char	1	0	CHAR	(N' ')	Yes		GHO_WTYPE	Allow NULL?
27	WC_PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	*	PLNTY	Allow NULL?
28	WC_PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
29	WC_PLNAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
30	WC_AUART	Order Type for Maintenance Orders	nvarchar	4	0	CHAR	(N' ')	Yes	*	PM_AUFART	Allow NULL?
31	GHO_SUB_ADDRNUM	Address number	nvarchar	10	0	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
32	GHO_RESERVOIR	Reservoir	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_RESERVOIR	Allow NULL?
33	GHO_CONCESSION	Concession	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_CONCESSION	Allow NULL?
34	GHO_PLATFORM	Platform Type	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_AGGREGATE_TYPE	Allow NULL?
35	GHO_FIELD	Field	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_FIELD	Allow NULL?
36	GHO_SHORE_IND	Well Shore Indicator	nvarchar	3	0	CHAR	(N' ')	Yes		GHO_WELL_SHORE_IND	Allow NULL?
37	GHO_MTR_DESCR	Meter Description	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_MTR_DESCR	Allow NULL?
38	GHO_MTR_TYPE	Meter Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_MTR_TYPE	Allow NULL?
39	GHO_MTR_OP_MODE	Meter Operating Mode	nvarchar	50	0	CHAR	(N' ')	Yes		GHO_MTR_OP_MODE	Allow NULL?
40	GHO_MTR_DESN_PRE	Meter Design Pressure	decimal	13	3	DEC	((0))	Yes		GHO_MTR_DESN_PRE
41	GHO_MTR_OP_PRE	Meter Operating Pressure	decimal	13	3	DEC	((0))	Yes		GHO_MTR_OP_PRE
42	GHO_MTR_DESN_TEM	Meter Design Temperature	decimal	13	3	DEC	((0))	Yes		GHO_MTR_DESN_TEMP
43	GHO_MTR_OP_TEMP	Meter Operating Temperature	decimal	13	3	DEC	((0))	Yes		GHO_MTR_OP_TEMP
44	GHO_MTR_LVR_FROM	Meter Liquid Viscosity Range From	decimal	13	3	DEC	((0))	Yes		GHO_MTR_LVR_FROM
45	GHO_MTR_LVR_TO	Meter Liquid Viscosity Range To	decimal	13	3	DEC	((0))	Yes		GHO_MTR_LVR_TO
46	GHO_MTR_LQD_RAT	Meter Water / Liquid Ratio	decimal	17	14	DEC	((0))	Yes		GHO_MTR_LIQD_RATIO_FRAC
47	GHO_MTR_VOL_FRA	Meter Gas / Volume Fraction	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_MTR_VOL_FRA	Allow NULL?
48	GHO_MTR_LQD_VOL	Meter Liquid / Volume Fraction	decimal	17	14	DEC	((0))	Yes		GHO_MTR_LQD_VOL_FRAC
49	GHO_MTR_DP_UOM	Meter Design Pressure UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_DP_UOM	Allow NULL?
50	GHO_MTR_DT_UOM	Meter Design Temperature UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_DT_UOM	Allow NULL?
51	GHO_MTR_OP_UOM	Meter Operating Pressure UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_OP_UOM	Allow NULL?
52	GHO_MTR_OT_UOM	Meter Operating Temperature UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_OT_UOM	Allow NULL?
53	GHO_MTR_LVRF_UOM	Meter Liquid Viscosity Range From UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_LVRF_UOM	Allow NULL?
54	GHO_MTR_LVRT_UOM	Meter Liquid Viscosity Range To UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MTR_LVRT_UOM	Allow NULL?
55	GHO_MTR_LQDRATUI	Meter Water / Liquid Ratio for UI	nvarchar	17	0	CHAR	(N' ')	Yes		GHO_MTR_LIQD_RAT_UI	Allow NULL?
56	GHO_MTR_LQDVOLUI	Meter Liquid / Volume Fraction for UI	nvarchar	17	0	CHAR	(N' ')	Yes		GHO_MTR_LQD_VOL_UI	Allow NULL?
57	GHO_PUMP_DESCR	Pump Description	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_PUMP_DESCR	Allow NULL?
58	GHO_PUMP_TYPE	Pump Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_PUMP_TYPE	Allow NULL?
59	GHO_PUMP_DRIVER	Type of Driver	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_PUMP_DRIVER	Allow NULL?
60	GHO_PUMP_FLUID	Fluid Handled	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_PUMP_FLUID	Allow NULL?
61	GHO_PUMP_APPL	Application	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_PUMP_APPL	Allow NULL?
62	GHO_PUMP_DESIGN	Pump Design	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_PUMP_DESIGN	Allow NULL?
63	GHO_PUMP_PR	Power Rating	nvarchar	8	0	NUMC	(N'00000000')	Yes		GHO_PUMP_POW_RATE	Allow NULL?
64	GHO_PUMP_SP	Suction Pressure	nvarchar	8	0	NUMC	(N'00000000')	Yes		GHO_PUMP_SUC_PRES	Allow NULL?
65	GHO_PUMP_DP	Discharge Pressure	nvarchar	8	0	NUMC	(N'00000000')	Yes		GHO_PUMP_DIS_PRES	Allow NULL?
66	GHO_PUMP_SPEED	Pump Speed	nvarchar	12	0	NUMC	(N'000000000000')	Yes		GHO_PUMP_SPEED	Allow NULL?
67	GHO_PUMP_PR_UOM	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
68	GHO_PUMP_SP_UOM	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
69	GHO_PUMP_DP_UOM	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
70	GHO_PUMP_SD_UOM	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	MEINS	Allow NULL?
71	GHO_UOS	Use of Separator	nvarchar	3	0	CHAR	(N' ')	Yes		GHO_SEP_UOS	Allow NULL?
72	GHO_SEP_DP	Separator Design Pressure	decimal	9	3	DEC	((0))	Yes		GHO_SEP_DESN_PREESURE
73	GHO_SEP_DP_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
74	GHO_SEP_OP	Operating Pressure	decimal	9	3	DEC	((0))	Yes		GHO_SEP_OPR_PREESURE
75	GHO_SEP_OP_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
76	GHO_SEP_DT	Separator Design Temperature	decimal	6	2	DEC	((0))	Yes		GHO_SEP_DESN_TEMP
77	GHO_SEP_DT_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
78	GHO_SEP_OT	Operating Temperature	decimal	6	2	DEC	((0))	Yes		GHO_SEP_OPR_TEMP
79	GHO_SEP_OT_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
80	CHOKE_SIZE_VAL	Choke Size - Unit of Measure	nvarchar	30	0	CHAR	(N' ')	Yes	*	GHO_CHOKE_SIZE_VAL	Allow NULL?
81	CHOKE_SIZE_UOM	Choke Size - Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_CHOKE_SIZE_UOM	Allow NULL?
82	GHO_COMP_TYPE	Compressor Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_COMP_TYPE	Allow NULL?
83	GHO_SP_FIRST	Suction Pressure 1st Stage	decimal	9	3	DEC	((0))	Yes		GHO_COMP_SP_FIRST
84	GHO_SP_F_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
85	GHO_SP_SECOND	Suction Pressure 2nd Stage	decimal	9	3	DEC	((0))	Yes		GHO_COMP_SP_SECOND
86	GHO_SP_S_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
87	GHO_DP_FIRST	Discharge Pressure 1st Stage	decimal	9	3	DEC	((0))	Yes		GHO_COMP_DP_FIRST
88	GHO_DP_F_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
89	GHO_DP_SECOND	Discharge Pressure 2nd Stage	decimal	9	3	DEC	((0))	Yes		GHO_COMP_DP_SECOND
90	GHO_DP_S_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
91	GHO_COMP_DT	Discharge Temperature	decimal	6	2	DEC	((0))	Yes		GHO_COMP_DT
92	GHO_COMP_DT_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
93	GHO_COMP_POWER	Compressor Power	decimal	9	3	DEC	((0))	Yes		GHO_COMP_POWER
94	GHO_POWER_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
95	GHO_TB_TYPE	Turbine Type of Driven Unit	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_TB_TYPE	Allow NULL?
96	GHO_TB_DPR	Turbine Power Rating (Design)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		GHO_TB_DPR	Allow NULL?
97	GHO_TB_DPR_UOM	Turbine Power Rating (Design) UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_TB_DPR_UOM	Allow NULL?
98	GHO_TB_OPR	Turbine Power Rating (Operating)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		GHO_TB_OPR	Allow NULL?
99	GHO_TB_OPR_UOM	Power Rating (Operating) UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_TB_OPR_UOM	Allow NULL?
100	GHO_TB_SPD	Turbine Speed	nvarchar	10	0	NUMC	(N'0000000000')	Yes		GHO_TB_SPD	Allow NULL?
101	GHO_TB_SPD_UOM	Turbine Speed UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_TB_SPD_UOM	Allow NULL?
102	GHO_TB_FL_TYPE	Turbine Fuel Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_TB_FL_TYPE	Allow NULL?
103	GHO_OFS	Orientation of Flare Stack	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_OFS	Allow NULL?
104	GHO_LFS	Length of Flare Stack	decimal	10	3	DEC	((0))	Yes		GHO_LFS
105	GHO_LFS_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
106	GHO_PN_TZ	Production Network Time Zone	nvarchar	6	0	CHAR	(N' ')	Yes	*	GHO_PN_TZ	Allow NULL?
107	GHO_PN_SBD	Start of Business Day	nvarchar	6	0	TIMS	(N'000000')	Yes		GHO_PN_START_BUS_DAY	Allow NULL?
108	GHO_PN_NW_ALLOC	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')	char	1	0	CHAR	(N' ')	Yes		BOOLE_D	Allow NULL?
109	NETID	Network identification	nvarchar	8	0	CHAR	(N' ')	Yes	*	NETID	Allow NULL?
110	OPERATOR	Oil and Gas Entity Operator	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_PE_OPERATOR	Allow NULL?
111	STATUS_PROFILE	Status Management Profile ID	nvarchar	3	0	CHAR	(N' ')	Yes		GHO_DE_STAT_PROFILE_ID	Allow NULL?
112	AUDIT_PROFILE_ID	Audit ID	nvarchar	9	0	CHAR	(N' ')	Yes		GHO_DE_AUDIT_ID	Allow NULL?
113	CHEM_ANA_LEVEL	Chemical Analysis Level for Capture Measurements	nvarchar	5	0	CHAR	(N' ')	Yes	*	GHO_ANALYSIS_LEVEL	Allow NULL?
114	SEQNR	Tank ID	nvarchar	10	0	CHAR	(N' ')	Yes		GHO_TANK_ID	Allow NULL?
115	TANK_TYPE	Tank Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_TANK_TYPE	Allow NULL?
116	GHO_SUBSURF_IND	Well Subsurface Indicator	char	1	0	CHAR	(N' ')	Yes		GHO_WELL_SUBSURFACE_IND	Allow NULL?
117	GHO_ELEVATION_RE	Elevation Reference	nvarchar	16	0	CHAR	(N' ')	Yes		GHO_ELEVATION_REF	Allow NULL?
118	GHO_WELL_TVD	True Vertical Depth	decimal	9	3	DEC	((0))	Yes		GHO_WELL_TVD
119	GHO_PERF_FROM	WC Perforation From	decimal	9	3	DEC	((0))	Yes		GHO_WC_PERF_FRM
120	GHO_PERF_TO	WC Perforation To	decimal	9	3	DEC	((0))	Yes		GHO_WC_PERF_TO
121	GHO_HGR_DEPTH	WC Hanger Depth	decimal	9	3	DEC	((0))	Yes		GHO_WC_HGR_DPT
122	GHO_SHOE_DEPTH	WC Shoe Depth	decimal	9	3	DEC	((0))	Yes		GHO_WC_SHOE_DPT
123	GHO_ELEV_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
124	GHO_PERF_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
125	GHO_PERT_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
126	GHO_HGR_DEP_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
127	GHO_SHOE_DEP_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
128	GHO_DEPTH_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
129	GHO_WELL_TVD_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
130	GHO_GRND_ELE	Ground Elevation	decimal	9	3	DEC	((0))	Yes		GHO_FLARE_ELEV
131	GHO_GE_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
132	GHO_TOP_ELE	Top Elevation of Flare Stack	decimal	9	3	DEC	((0))	Yes		GHO_FLARE_TOPELEV
133	GHO_TE_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
134	GHO_DEH_TYPE	Dehydrator Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_DEH_TYPE	Allow NULL?
135	GHO_DEH_DSN_TEMP	Design Temperature	decimal	6	2	DEC	((0))	Yes		GHO_DESN_TEMP
136	GHO_DEH_OP_TEMP	Operating Temperature	decimal	6	2	DEC	((0))	Yes		GHO_OP_TEMP
137	GHO_DEH_DT_UOM	Design Temperature	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_DT_UOM	Allow NULL?
138	GHO_DEH_OT_UOM	Operating Temperature UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_OT_UOM	Allow NULL?
139	GHO_HT_CONFIG	Heater Treater Configuration	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_HT_CONFIG	Allow NULL?
140	GHO_HT_TMECH	Heater Treater- Treater Mechanism	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_HT_TMECH	Allow NULL?
141	GHO_HT_DESN_TEMP	Design Temperature	decimal	6	2	DEC	((0))	Yes		GHO_DESN_TEMP
142	GHO_HT_OP_TEMP	Operating Temperature	decimal	6	2	DEC	((0))	Yes		GHO_OP_TEMP
143	GHO_HT_DT_UOM	Design Temperature	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_DT_UOM	Allow NULL?
144	GHO_HT_OT_UOM	Operating Temperature UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_OT_UOM	Allow NULL?
145	GHO_PIPE_DPRE	Pipeline Design Pressure	decimal	13	3	DEC	((0))	Yes		GHO_PIPE_DESN_PRE
146	GHO_PIPE_DP_UOM	Pipeline Design Pressure UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_PIPE_DP_UOM	Allow NULL?
147	GHO_LPL	Length of Pipeline	decimal	10	3	DEC	((0))	Yes		GHO_LPL
148	GHO_LEN_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
149	GHO_INDIAMETER	Pipeline Diameter	decimal	7	2	DEC	((0))	Yes		GHO_DIAM
150	GHO_IND_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
151	GHO_OUTDIAMETER	Pipeline Diameter	decimal	7	2	DEC	((0))	Yes		GHO_DIAM
152	GHO_OUTD_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
153	GHO_WALLTHICK	Wall Thickness of Pipeline	decimal	7	2	DEC	((0))	Yes		GHO_WTHICK
154	GHO_WT_UOM	Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_UOM	Allow NULL?
155	GHO_PIPEMATNR	Pipeline Material	nvarchar	2	0	CHAR	(N' ')	Yes	*	GHO_PIPEMATNR	Allow NULL?
156	GHO_MFOLD_DPRE	Manifold Design Pressure	decimal	13	3	DEC	((0))	Yes		GHO_MFOLD_DESN_PRE
157	GHO_MFOLD_DP_UOM	Manifold Design Pressure UoM	nvarchar	3	0	UNIT	(N' ')	Yes	*	GHO_MFOLD_DP_UOM	Allow NULL?
158	GHO_CHAIN_IND	Network Object Indicator to Allow Network Chaining	char	1	0	CHAR	(N' ')	Yes		GHO_CHAIN_IND	Allow NULL?
159	GHO_CLSTR_DESC	Cluster Description	nvarchar	40	0	CHAR	(N' ')	Yes		GHO_CLSTR_DESC	Allow NULL?
160	GHO_CLSTR_TYPE	Cluster Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_CLSTR_TYPE	Allow NULL?
161	GHO_GEN_TYPE	Generic Object Type	nvarchar	3	0	NUMC	(N'000')	Yes		GHO_GEN_TYPE	Allow NULL?
162	GHO_TERMPT_IND	Termination Point	char	1	0	CHAR	(N' ')	Yes		GHO_TERMPT_IND	Allow NULL?

TOP ERP 6.0 | GHO_IFLOT_EXT INDEXES

Name	Primary	Unique	Type	Columns
GHO_IFLOT_EXT~0	Yes	Yes	CLUSTERED	TPLNR, MANDT
GHO_IFLOT_EXT~GHO	No	No	NONCLUSTERED	GHO_NETOBJ_TYPE, NETID
GHO_IFLOT_EXT~NET	No	No	NONCLUSTERED	GHO_NETOBJ_TYPE, TPLNR
GHO_IFLOT_EXT~SYS	No	No	NONCLUSTERED	SYSTEM_ID
GHO_IFLOT_EXT~TP	No	No	NONCLUSTERED	AUDIT_PROFILE_ID
GHO_IFLOT_EXT~TPL	No	No	NONCLUSTERED	GHO_NETOBJ_TYPE

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

162 COLUMNS | 6 INDEXES | ERP 6.0 | GHO_IFLOT_EXT TABLE

TOP ERP 6.0 | GHO_IFLOT_EXT COLUMNS

TOP ERP 6.0 | GHO_IFLOT_EXT INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

162 COLUMNS | 6 INDEXES | ERP 6.0 | GHO_IFLOT_EXT TABLE

TOPERP 6.0 | GHO_IFLOT_EXT COLUMNS

TOPERP 6.0 | GHO_IFLOT_EXT INDEXES

TOP ERP 6.0 | GHO_IFLOT_EXT COLUMNS

TOP ERP 6.0 | GHO_IFLOT_EXT INDEXES