Insertions

4 minute read

This table stores information about all insertions of the elevations.

Name	Type	Size	Description
AmountSashes	Long Integer	4	Amount of sashes
BarcodeFPMMain	Text	255
BarcodeFPMSlave	Text	255
BarcodePRS	Text	255
BarcodeRuchserMain	Text	255
BarcodeRuchserSlave	Text	255
BottomConfigInfo	Text	255
BottomConfigName	Text	255
BottomConfigType	Text	255
Description	Text	255	Insertion description
DIN	Text	255
DoorpackPictureI_CompCad	OLE-Objekt	-
DoorpackPictureI_File	Text	255	Path and filename of Doorpackage picture inside
DoorpackPictureI_HeightMM	Double	8	Doorpackage picture inside height in mm
DoorpackPictureI_Inside	Bool	1	0 = Doorpackage picture is outside 1 = Doorpackage picture is inside
DoorpackPictureI_Scale	Double	8	1 divided by DoorpackPictureI_Scale = scale
DoorpackPictureI_WidthMM	Double	8	Doorpackage picture inside width in mm
DoorpackPictureO_CompCad	OLE-Objekt	-
DoorpackPictureO_File	Text	255	Path and filename of Doorpackage picture outside
DoorpackPictureO_HeightMM	Double	8	Doorpackage picture outside height in mm
DoorpackPictureO_Inside	Bool	1	0 = Doorpackage picture is outside 1 = Doorpackage picture is inside
DoorpackPictureO_Scale	Double	8	1 divided by DoorpackPictureO_Scale = scale
DoorpackPictureO_WidthMM	Double	8	Doorpackage picture outside width in mm
ElevationId	Long Integer	4	FOREIGN KEY refers to Elevations.ElevationID
EscapeDoorInOpeningDirection	Bool	1
IOMasterLeafEscapeDoortype	Long Interger	4	IOMasterLeafEscapeDoortype
EscapeDoorAgainstOpeningDirection	Bool	1
IOSlaveLeafEscapeDoortype	Long Integer	4	IOMasterLeafEscapeDoortype
AOMasterLeafEscapeDoortype	Long Intrger	4	IOMasterLeafEscapeDoortype
GapDoor	Double	8
GapDoor_Output	Double	8
GapDoor_Unit	Text	255
GroupID	Long Integer	4	Groups identical insertions
HandleHeight	Double	8	Height of handle in meter
HandleHeight_Output	Double	8	Height of handle in your LogiKal unit
HandleHeight_Unit	Text	255	Handle height output unit
HandleHeightReference	Long Integer	4	0 = Undefined 1 = Measurement from wing outer edge 2 = Measurement from wing seam
HandleInMid	Bool	1	0 = Handle not in the middle of the height 1 = Handle is in the middle of the height
HardwareColor	Text	255
HardwareSelection10Caption	Text	255
HardwareSelection10Color	Text	255
HardwareSelection10Value	Text	255
HardwareSelection1Caption	Text	255
HardwareSelection1Color	Text	255
HardwareSelection1Value	Text	255
HardwareSelection2Caption	Text	255
HardwareSelection2Color	Text	255
HardwareSelection2Value	Text	255
HardwareSelection3Caption	Text	255
HardwareSelection3Color	Text	255
HardwareSelection3Value	Text	255
HardwareSelection4Caption	Text	255
HardwareSelection4Color	Text	255
HardwareSelection4Value	Text	255
HardwareSelection5Caption	Text	255
HardwareSelection5Color	Text	255
HardwareSelection5Value	Text	255
HardwareSelection6Caption	Text	255
HardwareSelection6Color	Text	255
HardwareSelection6Value	Text	255
HardwareSelection7Caption	Text	255
HardwareSelection7Color	Text	255
HardwareSelection7Value	Text	255
HardwareSelection8Caption	Text	255
HardwareSelection8Color	Text	255
HardwareSelection8Value	Text	255
HardwareSelection9Caption	Text	255
HardwareSelection9Color	Text	255
HardwareSelection9Value	Text	255
HardwareSet	Text	255
HardwareSet_BaseNumber	Text	255
HardwareSet_Number	Text	255
HardwareSet_OrderCode	Text	255
HardwareSet_Supplier	Text	255
Height	Double	8	Height in meter
Height_Output	Double	8	Height in LogiKal unit
Height_Unit	Text	255	LogiKal unit
Height2	Double	8
Height2_Output	Double	8
Height2_Unit	Text	255
HeightGridPrices	Double	8
HeightGridPrices_Output	Double	8
HeightGridPrices_Unit	Text	255
Info	Text	255
InsertionID	Long Integer	4	PRIMARY KEY
InsertionNo	Long Integer	4	Insertion number
IsPrepared	Bool	1
IsPrepared2	Bool	1
IsPrepared3	Bool	1
IsSubPos	Bool	1
MasterLeaf	Long Integer	4
OffsetDoor	Double	8
OffsetDoor_Output	Double	8
OffsetDoor_Unit	Text	255
FloorRecess	Double	8
FloorRecess_Output	Double	8	The value in the unit of FloorRecess_Unit
FloorRecess_Unit	Text	255
GapSide	Double	8
GapSide_Output	Double	8	The value in the unit of GapSide_Unit
GapSide_Unit	Text	255
ParentInsertion	Long Integer	4
PreparedDepthInside	Double	8
PreparedDepthInside_Output	Double	8
PreparedDepthInside_Unit	Text	255
PreparedDepthInside2	Double	8
PreparedDepthInside2_Output	Double	8
PreparedDepthInside2_Unit	Text	255
PreparedDepthInside3	Double	8
PreparedDepthInside3_Output	Double	8
PreparedDepthInside3_Unit	Text	255
PreparedDepthOutside	Double	8
PreparedDepthOutside_Output	Double	8
PreparedDepthOutside_Unit	Text	255
PreparedDepthOutside2	Double	8
PreparedDepthOutside2_Output	Double	8
PreparedDepthOutside2_Unit	Text	255
PreparedDepthOutside3	Double	8
PreparedDepthOutside3_Output	Double	8
PreparedDepthOutside3_Unit	Text	255
SightSizeDoorClearance	Double	8
SightSizeDoorClearance_Output	Double	8
SightSizeDoorClearance_Unit	Text	255
SightSizeDoorClearanceGap	Double	8
SightSizeDoorClearanceGap_Output	Double	8
SightSizeDoorClearanceGap_Unit	Text	255
SightSizeDoorClearanceMaster	Double	8
SightSizeDoorClearanceMaster_Output	Double	8
SightSizeDoorClearanceMaster_Unit	Text	255
SightSizeDoorClearanceMasterGap	Double	8
SightSizeDoorClearanceMasterGap_Output	Double	8
SightSizeDoorClearanceMasterGap_Unit	Text	255
SightSizeHeight	Double	8
SightSizeHeight_Output	Double	8
SightSizeHeight_Unit	Text	255
SightSizeWidth	Double	8
SightSizeWidth_Output	Double	8
SightSizeWidth_Unit	Text	255
Sub10Color	Text	255
Sub10ColorRGBA	Long Integer	4
Sub10ColorRGBI	Long Integer	4
Sub1Color	Text	255
Sub1ColorRGBA	Long Integer	4
Sub1ColorRGBI	Long Integer	4
Sub2Color	Text	255
Sub2ColorRGBA	Long Integer	4
Sub2ColorRGBI	Long Integer	4
Sub3Color	Text	255
Sub3ColorRGBA	Long Integer	4
Sub3ColorRGBI	Long Integer	4
Sub4Color	Text	255
Sub4ColorRGBA	Long Integer	4
Sub4ColorRGBI	Long Integer	4
Sub5Color	Text	255
Sub5ColorRGBA	Long Integer	4
Sub5ColorRGBI	Long Integer	4
Sub6Color	Text	255
Sub6ColorRGBA	Long Integer	4
Sub6ColorRGBI	Long Integer	4
Sub7Color	Text	255
Sub7ColorRGBA	Long Integer	4
Sub7ColorRGBI	Long Integer	4
Sub8Color	Text	255
Sub8ColorRGBA	Long Integer	4
Sub8ColorRGBI	Long Integer	4
Sub9Color	Text	255
Sub9ColorRGBA	Long Integer	4
Sub9ColorRGBI	Long Integer	4
SubPosValid	Bool	1
Type	Text	255	Insertions.Type
TypeNr	Long Integer	4	Insertions.TypeNr
Weight	Double	8	Weight in kilogram
Weight_Output	Double	8	Weight in your LogiKal unit
Weight_Unit	Text	255	Weight output unit
Width	Double	8	Width in meter
Width_Output	Double	8	Width in your LogiKal unit
Width_Unit	Text	255	Width output unit
Width2	Double	8
Width2_Output	Double	8
Width2_Unit	Text	255
WidthGridPrices	Double	8
WidthGridPrices_Output	Double	8
WidthGridPrices_Unit	Text	255
xGUID	Text	255
xSegmentGUID	Text	255