Profiles

  7 minute read  

NameTypeSizeDescription
AmountLong Integer4Amount of profiles
AngleOfArcDouble8
AreaOfferText255
ArticleCodeText255
ArticleCode_BaseNumberText255
ArticleCode_NumberText255
ArticleCode_OrderCodeText255
ArticleCode_SupplierText255
ArticleTypeLong Integer4ArticleType
ArticleTypePrintoutLong Integer4ArticleType for printouts
AssemblyInfoText255
AssemblyInfoNoLong Integer4AssemblyInfoNo
AssemblyNameText255Only If assembly names defined at settings + input of elements
AssemblyNoLong Integer4Sequential profile number
BottomExtensionDouble8
BottomExtension_OutputDouble8
BottomExtension_UnitText255
ColorText255
ColorInfoInternalText255
ColorTypeInternalLong Integer4ColorTypeInternal
CroppedType0 = CroppedNone 1 = CroppedSteg 2 = CroppedIn(Auf) 3 = CroppedAt(Um)
CustomerStockItemBool10 = no customerstockitem 1 = customerstockitem
CutLeftDouble8
CutLeft_OutputVIText255
CutLeft2Double8
CutLeft2_OutputVIText255
CutRightDouble8
CutRight_OutputVIText255
CutRight2Double8
CutRight2_OutputVIText255
DeliveryStatusLong Integer4DeliveryStatus
DepthEnlargedToDouble8
DepthEnlargedTo_OutputDouble8
DepthEnlargedTo_UnitText255
DescriptionText255
DifferentColorBool1
Dimension1Double8
Dimension1_OutputDouble8
Dimension1_UnitText255
Dimension2Double8
Dimension2_OutputDouble8
Dimension2_UnitText255
DoNotEstimateBool1
EnlargedToDouble8
EnlargedTo_OutputDouble8
EnlargedTo_UnitText255
FromHardwareLong Integer4
InnerColorText255
InnerColorInfoInternalText255
InnerColorTypeInternalLong Integer4
InsertionIdLong Integer4FOREIGN KEY refers to Insertions.InsertionID
InsertionNoLong Integer4
InsertionSubNoLong Integer4
InsideOutsideLong Integer4InsideOutside (Where the profiles are positioned)
IntIdText255ObjectNumber-CadNumber-Increment
IsAdditionalBool10 = no additional profile 1 = additional profile
IsArchedBool10 = not arched 1 = arched
IsDualColorBool10 = no dual color 1 = Dual color
IsInactiveBool10 = Profile is Available 1 = Color IsInactiv or IsInactiveInVar
IsMainBool1
IsMixedPriceBool1
IsSalesPriceItemBool10 = no salesprice item 1 = salesprice item
JobIdLong Integer4
LayerLong Integer4
LengthDouble8Length in meter
Length_OutputDouble8Length in your LogiKal unit
Length_UnitText255Length output unit
LengthAssemblyPlanDouble8
LengthAssemblyPlan_OutputDouble8
LengthAssemblyPlan_UnitText255
LengthOptimizationDouble8
LengthOptimization_OutputDouble8
LengthOptimization_UnitText255
LK_ColorIdLong Integer4LOOKUP KEY refers to Colors.ColorID
LK_InnerColorIdLong Integer4LOOKUP KEY refers to Colors.ColorID
LK_OuterColorIdLong Integer4LOOKUP KEY refers to Colors.ColorID
LK_DiscountIdLong Integer4LOOKUP KEY refers to EstimationDiscounts.EstimationDiscountID
LK_KfmKeyIdLong4LOOKUP KEY refers to KfmKeys.KfmKeyID
LK_ManufacturerIDLong Integer4LOOKUP KEY refers to Manufacturers.ManufacturersID
LockingBarInfoText255
LockingBarPosText255
LockingBarPosEnumLong Integer4
LockingBarPosLongText255
MaterialLong Integer4Material
MaterialDescriptionText255Material description
MaxRadiusDouble8
MaxRadius_OutputDouble8
MaxRadius_UnitText255
MinRadiusDouble8
MinRadius_OutputDouble8
MinRadius_UnitText255
MixedQty1Double8
MixedQty2Double8
MountingOrderLong Integer4
NotchLeftDouble8
NotchLeft_OutputDouble8
NotchLeft_UnitText255
NotchRightDouble8
NotchRight_OutputDouble8
NotchRight_UnitText255
OuterColorText255
OuterColorInfoInternalText255
OuterColorTypeInternalLong Integer4
PerimeterDouble8Perimeter in mm
Perimeter_OutputDouble8Perimeter in your LogiKal unit
Perimeter_UnitText255Perimeter output unit
PerimeterIDouble8Perimeter inside in mm
PerimeterI_OutputDouble8Perimeter inside output in your LogiKal unit
PerimeterI_UnitText255Perimeter inside output unit
PerimeterODouble8Perimeter outside in mm
PerimeterO_OutputDouble8Perimeter outside output in your LogiKal unit
PerimeterO_UnitText255Perimeter outside output unit
Picture12_CompCadOLE-Objekt-
Picture12_FileText255Path and filename of Item drawing 1
Picture12_HeightMMDouble8Item drawing 1 height in mm
Picture12_InsideBool10 = Item drawing 1 is outside 1 = Item drawing 1 is inside
Picture12_ScaleDouble81 divided by Picture12_Scale = scale
Picture12_WidthMMDouble8Item drawing 1 width in mm
Picture13_CompCadOLE-Objekt-
Picture13_FileText255Path and filename of Item drawing 2
Picture13_HeightMMDouble8Item drawing 2 height in mm
Picture13_InsideBool10 = Item drawing 2 is outside 1 = Item drawing 2 is inside
Picture13_ScaleDouble81 divided by Picture13_Scale = scale
Picture13_WidthMMDouble8Item drawing 2 width in mm
Picture14_CompCadOLE-Objekt-
Picture14_FileText255Path and filename of Item drawing 3
Picture14_HeightMMDouble8Item drawing 3 height in mm
Picture14_InsideBool10 = Item drawing 3 is outside 1 = Item drawing 3 is inside
Picture14_ScaleDouble81 divided by Picture14_Scale = scale
Picture14_WidthMMDouble8Item drawing 3 width in mm
Picture6_CompCadOLE-Objekt-
Picture6_FileText255Path and filename of profile section 1
Picture6_HeightMMDouble8Profile section 1 height in mm
Picture6_InsideBool10 = Profile section 1 is outside 1 = Profile section 1 is inside
Picture6_ScaleDouble81 divided by Picture6_Scale = scale
Picture6_WidthMMDouble8Profile section 1 width in mm
Picture7_CompCadOLE-Objekt-
Picture7_FileText255Path and filename of profile section 2
Picture7_HeightMMDouble8Profile section 2 height in mm
Picture7_InsideBool10 = Profile section 2 is outside 1 = Profile section 2 is inside
Picture7_ScaleDouble81 divided by Picture7_Scale = scale
Picture7_WidthMMDouble8Profile section 2 width in mm
PictureBending_CompCadOLE-Objekt-
PictureBending_FileText255Path and filename of bending plan (Picture24)
PictureBending_HeightMMDouble8Bending plan picture height in mm
PictureBending_InsideBool10 = Bending plan picture is outside 1 = Bending plan picture is inside
PictureBending_ScaleDouble81 divided by PictureBending_Scale = scale
PictureBending_WidthMMDouble8Bending plan picture width in mm
PictureCuttingDetail18_CompCadOLE-Objekt-
PictureCuttingDetail18_FileText255Path and filename of cutting detail 1 picture
PictureCuttingDetail18_HeightMMDouble8cutting detail 1 picture height in mm
PictureCuttingDetail18_InsideBool10 = Cutting detail 1 picture is outside 1 = Cutting detail 1 picture is inside
PictureCuttingDetail18_ScaleDouble81 divided by PictureCuttingDetail18_Scale = scale
PictureCuttingDetail18_WidthMMDouble8Cutting detail 1 picture width in mm
PictureCuttingDetail19_CompCadOLE-Objekt-
PictureCuttingDetail19_FileText255Path and filename of cutting detail 2 picture
PictureCuttingDetail19_HeightMMDouble8cutting detail 2 picture height in mm
PictureCuttingDetail19_InsideBool10 = Cutting detail 2 picture is outside 1 = Cutting detail 2 picture is inside
PictureCuttingDetail19_ScaleDouble81 divided by PictureCuttingDetail19_Scale = scale
PictureCuttingDetail19_WidthMMDouble8Cutting detail 2 picture width in mm
PieceIdLong Integer4
PieceListTypeLong Integer4PieceListType
PriceDouble8Price per meter
PriceGrossDouble8Price gross per meter
PriceWithColBool1
ProcessingPointText255Processing point description
ProcessingPointTypeLong Integer4ProcessingPointType
ProductGroupText255
ProfileClassLong Integer4ProfileClass
ProfileHeightDouble8ProfileHeight in mm
ProfileHeight_OutputDouble8ProfileHeight in your LogiKal unit
ProfileHeight_UnitText255ProfileHeight output unit
ProfileIDLong Integer4PRIMARY KEY
ProfileSubTypeInteger4ProfileSubType
ProfileUsageLong Integer4ProfileUsage
ProfileWidthDouble8ProfileWidth in mm
ProfileWidth_OutputDouble8ProfileWidth in your LogiKal unit
ProfileWidth_UnitText255ProfileWidth output unit
RealLengthDouble8RealLength in meter
RealLength_OutputDouble8RealLength in your LogiKal unit
RealLength_UnitText255RealLength output unit
RealViewLengthDouble8
RealViewLength_OutputDouble8
RealViewLength_UnitText255
RebateDimensionDoulbe8Rebate dimension in meter
RebateDimension_OutputDouble8Rebate dimension in your LogiKal unit
RebateDimension_UnitText255Rebate dimension output unit
SubNoLong Integer4
TConnLeftText255
TConnRightText255
TopExtensionDouble8
TopExtension_OutputDouble8
TopExtension_UnitText255
UsageOfferText255
ValidityLong Integer40 = wie Position 1 = gueltig 2 = ungueltig
VisibleSurfaceDouble8Visible surface in mm
VisibleSurface_OutputDouble8Visible surface in your LogiKal unit
VisibleSurface_UnitText255Visible surface output unit
WeightDouble8Weight in kilogram
Weight_OutputDouble8Weight in your LogiKal unit
Weight_UnitText255Weight output unit
WeightEstimationDouble8Weight (Estimation) in kilogram
WeightEstimation_OutputDouble8Weight (Estimation) in your LogiKal unit
WeightEstimation_UnitText255Weight (Estimation) output unit
WoodTypeLong Integer4WoodType
WoodTypeDescriptionText255Description of woodtype
xGUIDText255
xSashGUIDText255
xSegmentGUIDText255