Elevations
7 minute read
The table elevations stores information about the positions of a project.
Automatically generated. Cannot be changed
| # | Name | Type | Size | Description | LogiKal Path | Reference (100px) | ||
|---|---|---|---|---|---|---|---|---|
| 1 | ElevationID | Long Integer | 4 | PRIMARY KEY | Automatically generated. Cannot be changed | |||
| 2 | ElevationGroupId | Long Integer | 4 | FOREIGN KEY refers to ElevationGroups.ElevationGroupID**** | ||||
| 3 | LK_BaseInnerColorID | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID | IoE → Position Properties **** **** **** | **** | ||
| 4 | LK_BaseOuterColorID | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID | ||||
| 5 | LK_InsertionInnerColorID | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID | ||||
| 6 | LK_InsertionOuterColorID | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID | ||||
| 7 | Name | Text | 255 | Elevation Name | PC | |||
| 8 | xGUID | Text | 255 | |||||
| 9 | LinkedGUID | |||||||
| 10 | LinkComment | |||||||
| 11 | Amount | Double | 8 | Amount of position | PC | |||
| 12 | OrgAmount | Double | 8 | Original amount of positions (usefull for production units) | ||||
| 13 | InsertionGuidlinesLikeProject | Bool | 1 | |||||
| 14 | OnlyEstemation | |||||||
| 15 | Alternative | Bool | 1 | Alternative Positon | PC | |||
| 16 | Description | Text | 255 | Brief description | PC → Edit Position | |||
| 17 | TextPosText | Text | 255 | |||||
| 18 | AutoDescription | Text | 255 | Automatic description | ||||
| 19 | AutoDescriptionShort | Text | 255 | Short automatic description | ||||
| 20 | Model | Text | 255 | Model description | PC → Edit Position | |||
| 21 | Width | Double | 8 | Width in mm | ||||
| 22 | Width_Output | Double | 8 | Width in your LogiKal settings Unit | ||||
| 23 | Width_Unit | Text | 255 | Width Unit like LogiKal settings | ||||
| 24 | Height | Double | 8 | Height in mm | ||||
| 25 | Height_Output | Double | 8 | Height in your LogiKal Settings Unit | ||||
| 26 | Height_Unit | Text | 255 | Height Unit like LogiKal Settings | ||||
| 27 | Weight | Double | 8 | Weight in kg | ||||
| 28 | Weight_Output | Double | 8 | Weight in your LogiKal settings Unit | ||||
| 29 | Weight_Unit | Text | 255 | Weight Unit like LogiKal settings | ||||
| 30 | Perimeter | Double | 8 | Perimeter in m | ||||
| 31 | Perimeter_Output | Double | 8 | Perimeter in your LogiKal Settings Unit | ||||
| 32 | Perimeter_Unit | Text | 255 | Perimeter Unit like LogiKal Settings | ||||
| 33 | Area | Double | 8 | Area in m2 | ||||
| 34 | Area_Output | Double | 8 | Area in your LogiKal Settings Unit | ||||
| 35 | Area_Unit | Text | 255 | Area Unit like LogiKal Settings | ||||
| 36 | SystemCode | Text | 255 | |||||
| 37 | SystemCode_Supplier | Text | 255 | |||||
| 38 | SystemCode_Number | Text | 255 | |||||
| 39 | SystemCode_BaseNumber | Text | 255 | |||||
| 40 | SystemCode_OrderCode | Text | 255 | |||||
| 41 | SystemCode_OriginalNumber | Text | 255 | |||||
| 42 | SystemName | Text | 255 | |||||
| 43 | SystemLongName | Text | 255 | |||||
| 44 | SystemNameInternal | Text | 255 | |||||
| 45 | SystemType | Long Integer | 4 | SystemType | ||||
| 46 | SystemRulePackage | Text | 255 | |||||
| 47 | SystemGLL | Text | 255 | |||||
| 48 | SystemSub | Text | 255 | |||||
| 49 | SystemSelection1 | Text | 255 | |||||
| 50 | SystemSelection2 | Text | 255 | |||||
| 51 | SubSystemAsMainSystem | Long Integer | 4 | |||||
| 52 | ElevationType | Long Integer | 4 | ElevationType | ||||
| AccessorieWastage | Double | 8 | ||||||
| ActiveTitle | Text | 255 | ||||||
| BaseCorners | Long Integer | 4 | ||||||
| BaseCorners_Description | Text | 255 | ||||||
| CalculationComment | Text | 255 | Path and filename of rtf-text with position text for the estimation | |||||
| CEDataComplete | Bool | 1 | ||||||
| CentreGasket | Long Integer | 4 | ||||||
| CEText | Text | 255 | ||||||
| ChangedBy | Text | 255 | Elevation was changed by username | |||||
| ChangedOn | Datum/Uhrzeit | 8 | Elevation was changed on date | |||||
| CoatingWastage | Double | 8 | ||||||
| ColorBase | Text | 255 | ||||||
| ColorBase_Long | Text | 255 | ||||||
| ColorBaseLongInfo | Text | 255 | ||||||
| ColorBaseRGB1 | Long Integer | 4 | ||||||
| ColorBaseRGB2 | Long Integer | 4 | ||||||
| ColorDoorRGB1 | Long Integer | 4 | ||||||
| ColorDoorRGB2 | Long Integer | 4 | ||||||
| ColorInsertions | Text | 255 | ||||||
| ColorInsertions_Long | Text | 255 | ||||||
| ColorInsertionsLongInfo | Text | 255 | ||||||
| ColorWindowRGB1 | Long Integer | 4 | ||||||
| ColorWindowRGB2 | Long Integer | 4 | ||||||
| Corners | Long Integer | 4 | ||||||
| Corners_Description | Text | 255 | ||||||
| CreatedBy | Text | 255 | Elevation was created by username | |||||
| CreatedOn | Datum/Uhrzeit | 8 | Elevation was created on date | |||||
| CrossSectionComment | Text | 255 | Path and filename of rtf-text with position text for the cross section | |||||
| CWConnectionInside | Text | 255 | ||||||
| CWConnectionOutside | Text | 255 | ||||||
| DeclarationType | Integer | Is the CE-Data EN or ETA | ||||||
| DeliveryComment | Text | 255 | Path and filename of rtf-text with position text for the delivery note | |||||
| Dismantling | Double | 8 | Dismantling time in minutes | |||||
| DoorCorners | Long Integer | 4 | ||||||
| DoorCorners_Description | Text | 255 | ||||||
| Drainage | Long Integer | 4 | Drainage | |||||
| EnergyLabelAllowed | Bool | 1 | ||||||
| EnergyLabelErrCode | Long Integer | 4 | ||||||
| ETA_EuropeanAssessmentDocument | Text | European Assessment Document | ||||||
| ETA_TechnicalAssessment | Text | Technical Assessment | ||||||
| ETA_TechnicalAssessmentBody | Text | Technical Assessment Body | ||||||
| FireProtectionClass | Long Integer | 4 | FireProtectionClass | |||||
| FireProtectionDuration | Long Integer | 4 | ||||||
| FixedPriceGlass | Double | 8 | ||||||
| FixedPriceTotal | Double | 8 | ||||||
| GlassGasket | Long Integer | 4 | ||||||
| GroupId | Long Integer | 4 | ||||||
| HardwareWastage | Double | 8 | ||||||
| HasAlignedProfiles | Bool | 1 | ||||||
| HasDoors | Bool | 1 | ||||||
| HasEnergyLabel | Bool | 1 | ||||||
| HasWindows | Bool | 1 | ||||||
| HistoryComment | Text | 255 | Change comment (for elevation comparisson) | |||||
| HistoryDate | Text | 255 | Last change date (for elevation comparisson) | |||||
| HistoryGroupId | Long Integer | 4 | History group id (for elevation comparisson) | |||||
| HistoryPhase | Long Integer | 4 | HistoryPhase | |||||
| ImportOrigin | Long Integer | 4 | ||||||
| InsideOutSideSegmentType | Long Integer | 4 | ||||||
| InvoiceComment | Text | 255 | Path and filename of rtf-text with position text for the invoice | |||||
| IsArchedOrSlanted | Bool | 1 | ||||||
| IsCurrentVersion | Bool | 1 | ||||||
| IsFreeCad | Bool | 1 | ||||||
| IsSegment | Bool | 1 | ||||||
| JobPlanning | Double | 8 | Job planing 1 time in minutes | |||||
| JobPlanning2 | Double | 8 | Job planing 2 time in minutes | |||||
| JobPlanning3 | Double | 8 | Job planing 3 time in minutes | |||||
| JustDoorpackage | Bool | 1 | ||||||
| JustReplacePackage | Bool | 1 | ||||||
| LengthDimsReferTo | Long Integer | 4 | ||||||
| Manufacturing | Double | 8 | Manufacturing 1 time in minutes | |||||
| Manufacturing2 | Double | 8 | Manufacturing 2 time in minutes | |||||
| Manufacturing3 | Double | 8 | Manufacturing 3 time in minutes | |||||
| Manufacturing4 | Double | 8 | Manufacturing 4 time in minutes | |||||
| Manufacturing5 | Double | 8 | Manufacturing 5 time in minutes | |||||
| Manufacturing6 | Double | 8 | Manufacturing 6 time in minutes | |||||
| Manufacturing7 | Double | 8 | Manufacturing 7 time in minutes | |||||
| Manufacturing8 | Double | 8 | Manufacturing 8 time in minutes | |||||
| Manufacturing9 | Double | 8 | Manufacturing 9 time in minutes | |||||
| Manufacturing10 | Double | 8 | Manufacturing 10 time in minutes | |||||
| Manufacturing11 | Double | 8 | Manufacturing 11 time in minutes | |||||
| Manufacturing12 | Double | 8 | Manufacturing 12 time in minutes | |||||
| Manufacturing13 | Double | 8 | Manufacturing 13 time in minutes | |||||
| Manufacturing14 | Double | 8 | Manufacturing 14 time in minutes | |||||
| Manufacturing15 | Double | 8 | Manufacturing 15 time in minutes | |||||
| Mounting | Double | 8 | Mounting 1 time in minutes | |||||
| Mounting2 | Double | 8 | Mounting 2 time in minutes | |||||
| MountingComment | Text | 255 | Path and filename of rtf-text with position text for the assembly list | |||||
| OfferComment | Text | 255 | Path and filename of rtf-text with position text for the quotation | |||||
| OffsetX | Double | 8 | ||||||
| OffsetX_Output | Double | 8 | ||||||
| OffsetX_Unit | Text | 255 | ||||||
| OffsetY | Double | 8 | ||||||
| OffsetY_Output | Double | 8 | ||||||
| OffsetY_Unit | Text | 255 | ||||||
| OrderComment | Text | 255 | ||||||
| Picture1_File | Text | 255 | Path and filename of position drawing 1 | |||||
| Picture1_HeightMM | Double | 8 | position drawing 1 height in mm | |||||
| Picture1_Inside | Bool | 1 | 0 = Position drawing 1 is outside 1 = Position drawing 1 is inside | |||||
| Picture1_Scale | Double | 8 | 1 divided by Picture1_Scale = scale | |||||
| Picture1_WidthMM | Double | 8 | Position drawing 1 width in mm | |||||
| Picture2_File | Text | 255 | Path and filename of position drawing 2 | |||||
| Picture2_HeightMM | Double | 8 | position drawing 2 height in mm | |||||
| Picture2_Inside | Bool | 1 | 0 = Position drawing 2 is outside1 = Position drawing 2 is inside | |||||
| Picture2_Scale | Double | 8 | 1 divided by Picture2_Scale = scale | |||||
| Picture2_WidthMM | Double | 8 | Position drawing 2 width in mm | |||||
| Picture3_File | Text | 255 | Path and filename of position drawing 3 | |||||
| Picture3_HeightMM | Double | 8 | position drawing 3 height in mm | |||||
| Picture3_Inside | Bool | 1 | 0 = Position drawing 3 is outside1 = Position drawing 3 is inside | |||||
| Picture3_Scale | Double | 8 | 1 divided by Picture3_Scale = scale | |||||
| Picture3_WidthMM | Double | 8 | Position drawing 3 width in mm | |||||
| Picture4_File | Text | 255 | Path and filename of position drawing 4 | |||||
| Picture4_HeightMM | Double | 8 | position drawing 4 height in mm | |||||
| Picture4_Inside | Bool | 1 | 0 = Position drawing 4 is outside1 = Position drawing 4 is inside | |||||
| Picture4_Scale | Double | 8 | 1 divided by Picture4_Scale = scale | |||||
| Picture4_WidthMM | Double | 8 | Position drawing 4 width in mm | |||||
| Picture5_File | Text | 255 | Path and filename of position drawing 5 | |||||
| Picture5_HeightMM | Double | 8 | position drawing 5 height in mm | |||||
| Picture5_Inside | Bool | 1 | 0 = Position drawing 5 is outside1 = Position drawing 5 is inside | |||||
| Picture5_Scale | Double | 8 | 1 divided by Picture5_Scale = scale | |||||
| Picture5_WidthMM | Double | 8 | Position drawing 5 width in mm | |||||
| ProfileMem | Text | 255 | ||||||
| ProfileMemBlob | OLE-Objekt | - | ||||||
| ProfileMemBlobIsZipped | Bool | 1 | ||||||
| ProfileWastage | Double | 8 | ||||||
| SashCorners | Long Integer | 4 | ||||||
| SashCorners_Description | Text | 255 | ||||||
| Sealing | Double | 8 | ||||||
| SealingToStructure | Long Integer | 4 | ||||||
| SegmentGUID | Text | 255 | ||||||
| SegmentLevel | Long Integer | 4 | SegmentLevel | |||||
| StaticCalculation | Bool | 1 | ||||||
| Status | Long Integer | 4 | Status | |||||
| SubId | Long Integer | 4 | ||||||
| SubNo | Long Integer | 4 | ||||||
| SubStructureSegmentType | Long Integer | 4 | ||||||
| SurfaceWastage | Double | 8 | ||||||
| SurveyPicture_CompCad | OLE-Objekt | - | ||||||
| SurveyPicture_File | Text | 255 | ||||||
| SurveyPicture_HeightMM | Double | 8 | ||||||
| SurveyPicture_Inside | Bool | 1 | ||||||
| SurveyPicture_Scale | Double | 8 | ||||||
| SurveyPicture_WidthMM | Double | 8 | ||||||
| Taping | Double | 8 | ||||||
| TConnections | Long Integer | 4 | TConnections | |||||
| TConnections_Description | Text | 255 | ||||||
| TextPosNoQuotation | Bool | 1 | Preis/Stückzahl nicht zeigen im Angebot | |||||
| TextPosPicture | Text | 255 | ||||||
| Units | Text | 255 | ||||||
| UseLabourTimeSuggestion | Bool | 1 | ||||||
| WarningLevel | Long Integer | 4 | WarningLevel | |||||
| WindowCorners | Long Integer | 4 | ||||||
| WindowCorners_Description | Text | 255 | ||||||
| WoddenProfileWastage | Double | 8 | ||||||
| WoodDepth | Double | 8 | Wood depth in mm | |||||
| WoodDepth_Output | Double | 8 | Wood depth in your LogiKal Settings Unit | |||||
| WoodDepth_Unit | Text | 255 | Wood depth like LogiKal Settings | |||||
| WoodType | Long Integer | 4 | WoodType | |||||
| WoodTypeDescription | Text | 255 | Description of wood type |