ProfileBars
5 minute read
| Name | Type | Size | Description |
|---|---|---|---|
| Amount | Long Integer | 4 | Amount |
| ArticleCode | Text | 255 | |
| ArticleCode_BaseNumber | Text | 255 | |
| ArticleCode_Number | Text | 255 | |
| ArticleCode_OrderCode | Text | 255 | |
| ArticleCode_Supplier | Text | 255 | |
| ArticleType | Long Integer | 4 | ArticleType |
| CalculationSurcharge | Double | 8 | |
| CoatedPCostNeeded | Double | 8 | |
| CoatedPCostOrdered | Double | 8 | |
| CoatedPCostUsed | Double | 8 | |
| CoatingColor | Bool | 1 | True if coating will be done by coating company. |
| CoatingCostNeeded | Double | 8 | |
| CoatingCostOrdered | Double | 8 | |
| CoatingCostUsed | Double | 8 | |
| Color | Text | 255 | |
| ColorDescription | Text | 255 | |
| ColorInfoInternal | Text | 255 | |
| ColorTypeInternal | Long Integer | 4 | ColorTypeInternal |
| CustomerStockItem | Bool | 1 | 0 = no customerstockitem 1 = customerstockitem |
| CuttingLoss | Double | 8 | |
| CuttingLoss_Output | Double | 8 | |
| CuttingLoss_Unit | Text | 255 | |
| CuttingLossMR | Double | 8 | |
| CuttingLossMR_Output | Double | 8 | |
| CuttingLossMR_Unit | Text | 255 | |
| CuttingLossOR | Double | 8 | |
| CuttingLossOR_Output | Double | 8 | |
| CuttingLossOR_Unit | Text | 255 | |
| DeliveryStatus | Long Integer | 4 | DeliveryStatus |
| Description | Text | 255 | |
| Discount | Double | 8 | Discount in % |
| DoubleCuts | Bool | 1 | |
| EndCut | Double | 8 | |
| EndCut_Output | Double | 8 | |
| EndCut_Unit | Text | 255 | |
| Height | Double | 8 | Height in meter |
| Height_Output | Double | 8 | Height in your LogiKal unit |
| Height_Unit | Text | 255 | Height output unit |
| InnerColor | Text | 255 | |
| InnerColorInfoInternal | Text | 255 | |
| InnerColorTypeInternal | Long Integer | 4 | |
| IsArched | Bool | 1 | 0 = profile is not arched 1 = profile is arched |
| IsDual | Bool | 1 | |
| IsDualColor | Bool | 1 | 0 = no dual Color 1 = Dual Color |
| IsFixedLength | Bool | 1 | 0 = profile is not fixed length 1 = Profile is fixed length |
| IsInactive | 0 = Profile is Available 1 = Color IsInactiv or IsInactiveInVar | ||
| IsManual | Bool | 1 | |
| IsResidualLength | Bool | 1 | 0 = profile is no residual length 1 = profile is residual length |
| IsSpecialLength | Bool | 1 | 0 = profile is no special length 1 = profile is special length |
| LeftOver | Double | 8 | |
| LeftOver_Output | Double | 8 | |
| LeftOver_Unit | Text | 255 | |
| Length | Double | 8 | Length in meter |
| Length_Output | Double | 8 | Length in your LogiKal unit |
| Length_Unit | Text | 255 | Length output unit |
| LK_DiscountId | Long Integer | 4 | LOOKUP KEY refers to EstimationDiscounts.EstimationDiscountID |
| LK_ManufacturerId | Long Integer | 4 | LOOKUP KEY refers to Manufacturers.Manufacturers.ID |
| LK_SawId | Long Integer | 4 | LOOKUP KEY refers to Saws.SawID |
| LK_KfmKeyId | Long | 4 | LOOKUP KEYrefers to KfmKeys.KfmKeyID |
| Material | Long Integer | 4 | Material |
| MaterialDescription | Text | 255 | Material description |
| MinUsableLen | Double | 8 | Minimum usable length in mm |
| MinUsableLen_Output | Double | 8 | Minimum usable length in your LogiKal unit |
| MinUsableLen_Unit | Text | 255 | Minimum usalbe length output unit |
| OuterColor | Text | 255 | |
| OuterColorInfoInternal | Text | 255 | |
| OuterColorTypeInternal | Long Integer | 4 | |
| Perimeter | Double | 8 | Perimeter in meter |
| Perimeter_Output | Double | 8 | Perimeter in your LogiKal unit |
| Perimeter_Unit | Text | 255 | Perimeter output unit |
| Picture11_CompCad | OLE-Objekt | - | |
| Picture11_File | Text | 255 | Path and filename ofOptimised bar drawing |
| Picture11_HeightMM | Double | 8 | Optimised bar drawing height in mm |
| Picture11_Inside | Bool | 1 | 0 = Optimised bar drawing is outside 1 = Optimised bar drawing is inside |
| Picture11_Scale | Double | 8 | 1 divided by Picture11_Scale = scale |
| Picture11_WidthMM | Double | 8 | Optimised bar drawing width in mm |
| Picture12_CompCad | OLE-Objekt | - | |
| Picture12_File | Text | 255 | Path and filename of Item drawing 1 |
| Picture12_HeightMM | Double | 8 | Item drawing 1 height in mm |
| Picture12_Inside | Bool | 1 | 0 = Item drawing 1 is outside 1 = Item drawing 1 is inside |
| Picture12_Scale | Double | 8 | 1 divided by Picture12_Scale = scale |
| Picture12_WidthMM | Double | 8 | Item drawing 1 width in mm |
| Picture13_CompCad | OLE-Objekt | - | |
| Picture13_File | Text | 255 | Path and filename of Item drawing 2 |
| Picture13_HeightMM | Double | 8 | Item drawing 2 height in mm |
| Picture13_Inside | Bool | 1 | 0 = Item drawing 2 is outside 1 = Item drawing 2 is inside |
| Picture13_Scale | Double | 8 | 1 divided by Picture13_Scale = scale |
| Picture13_WidthMM | Double | 8 | Item drawing 2 width in mm |
| Picture14_CompCad | OLE-Objekt | - | |
| Picture14_File | Text | 255 | Path and filename of Item drawing 3 |
| Picture14_HeightMM | Double | 8 | Item drawing 3 height in mm |
| Picture14_Inside | Bool | 1 | 0 = Item drawing 3 is outside 1 = Item drawing 3 is inside |
| Picture14_Scale | Double | 8 | 1 divided by Picture14_Scale = scale |
| Picture14_WidthMM | Double | 8 | Item drawing 3 width in mm |
| Picture16_CompCad | OLE-Objekt | - | |
| Picture16_File | Text | 255 | Path and filename of profile view optimised drawing |
| Picture16_HeightMM | Double | 8 | Profile view optimised drawing height in mm |
| Picture16_Inside | Bool | 1 | 0 = Profile view optimised drawing is outside 1 = Profile view optimised drawing is inside |
| Picture16_Scale | Double | 8 | 1 divided by Picture16_Scale = scale |
| Picture16_WidthMM | Double | 8 | Profile view optimised drawing width in mm |
| Price | Double | 8 | Price per meter (incl. coating) |
| PriceCoating | Double | 8 | Price coating per meter |
| PriceGross | Double | 8 | Price gross per meter |
| ProcessingPoint | Text | 255 | |
| ProcessingPointType | Long Integer | 4 | ProcessingPointType |
| ProductGroup | Text | 255 | |
| ProfileBarID | Long Integer | 4 | PRIMARY KEY |
| ProfileCostNeeded | Double | 8 | |
| ProfileCostOrdered | Double | 8 | |
| ProfileCostUsed | Double | 8 | |
| PUSize | Double | 8 | Amount of packaging unit |
| PUSize_Output | Double | 8 | Amount of your LogiKal packaging unit |
| PUSize_Unit | Text | 255 | Packaging output unit |
| RealUsedLength | Double | 8 | |
| RealUsedLength_Output | Double | 8 | |
| RealUsedLength_Unit | Text | 255 | |
| ResidualIgnored | Bool | 1 | |
| Residuallength | Double | 8 | |
| Residuallength_Output | Double | 8 | |
| Residuallength_Unit | Text | 255 | |
| RowForSawFile | Text | 255 | |
| SawCut | Double | 8 | |
| SawCut_Output | Double | 8 | |
| SawCut_Unit | Text | 255 | |
| SubSize | Double | 8 | Sub amount of one packaging unit |
| SupplierCode | Long Integer | 4 | |
| SupplierId | Long Integer | 4 | FOREIGN KEY refers to Suppliers.SupplierId |
| UsedLength | Double | 8 | Used length in meter |
| UsedLength_Output | Double | 8 | Used length in your LogiKal unit |
| UsedLength_Unit | Text | 255 | Used length output unit |
| VisibleSurface | Double | 8 | Visible surface in mm |
| VisibleSurface_Output | Double | 8 | Visible surface in your LogiKal unit |
| VisibleSurface_Unit | Text | 255 | Visible surface output unit |
| 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 |
| WoodType | Long Integer | 4 | WoodType |
| WoodTypeDescription | Text | 255 | WoddType description |
| xGUID | Text | 255 |