AllProfiles
3 minute read
The table AllProfiles summarize all amounts of the same profilebars.
| Name | Type | Size | Description |
|---|---|---|---|
| AllProfileID | Long Integer | 4 | PRIMARY KEY |
| Amount | Long Integer | 4 | |
| ArticleCode | Text | 255 | |
| ArticleCode_BaseNumber | Text | 255 | |
| ArticleCode_Number | Text | 255 | |
| ArticleCode_OrderCode | Text | 255 | |
| ArticleCode_Supplier | Text | 255 | |
| ArticleType | Long Integer | 4 | ArticleType |
| BottomExtension | Double | 8 | |
| BottomExtension_Output | Double | 8 | |
| BottomExtension_Unit | Text | 255 | |
| CoatingColor | Bool | 1 | True if coating will be done by coating company. |
| Color | Text | 255 | |
| ColorInfoInternal | Text | 255 | |
| ColorTypeInternal | Long Integer | 4 | ColorTypeInternal |
| CustomerStockItem | Bool | 1 | 0 = no customerstockitem 1 = customerstockitem |
| DeliveryStatus | Long Integer | 4 | DeliveryStatus |
| Description | Text | 255 | |
| Discount | Double | 8 | Discount in % |
| DoNotEstimate | Bool | 1 | |
| InnerColor | Text | 255 | |
| InnerColorInfoInternal | Text | 255 | |
| InnerColorTypeInternal | Long Integer | 4 | |
| IsAdditional | Bool | 1 | |
| IsArched | Bool | 1 | |
| IsDualColor | Bool | 1 | |
| IsFixedLength | Bool | 1 | |
| IsInactive | Bool | 1 | 0 = Profile is Available 1 = Color IsInactiv or IsInactiveInVar |
| IsManual | Bool | 1 | |
| IsMixedPrice | Bool | 1 | |
| IsResidualLength | Bool | 1 | |
| IsSalesPriceItem | Bool | 1 | |
| IsSpecialLength | Bool | 1 | |
| Length | Double | 8 | |
| Length_Output | Double | 8 | |
| Length_Unit | Text | 255 | |
| LK_ColorId | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID |
| LK_DiscountId | Long Integer | 4 | LOOKUP KEY refers to EstimationDiscounts.EstimationDiscountID |
| LK_ManufacturerId | Long Integer | 4 | LOOKUP KEY refers to Manufacturers.ManufacturersID |
| LK_KfmKeyId | Long | 4 | LOOKUP KEYrefers to KfmKeys.KfmKeyID |
| Material | Long Integer | 4 | Material |
| MaterialDescription | Text | 255 | Material description |
| MixedQty1 | Double | 8 | |
| MixedQty2 | Double | 8 | |
| OuterColor | Text | 255 | |
| OuterColorInfoInternal | Text | 255 | |
| OuterColorTypeInternal | Long Integer | 4 | |
| Perimeter | Double | 8 | |
| Perimeter_Output | Double | 8 | |
| Perimeter_Unit | Text | 255 | |
| 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_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 1 is outside 1 = Item drawing 1 is inside |
| Picture13_Scale | Double | 8 | 1 divided by Picture13_Scale = scale |
| Picture13_WidthMM | Double | 8 | Item drawing 2 width in mm |
| 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 1 is outside 1 = Item drawing 1 is inside |
| Picture14_Scale | Double | 8 | 1 divided by Picture14_Scale = scale |
| Picture14_WidthMM | Double | 8 | Item drawing 3 width in mm |
| Price | Double | 8 | Price per meter |
| 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 | |
| ProfileHeight | Double | 8 | |
| ProfileHeight_Output | Double | 8 | |
| ProfileHeight_Unit | Text | 255 | |
| ProfileWidth | Double | 8 | |
| ProfileWidth_Output | Double | 8 | |
| ProfileWidth_Unit | Text | 255 | |
| PUAmount | 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 |
| ResidualIgnored | Bool | 1 | |
| ResidualLength | Double | 8 | |
| ResidualLength_Output | Double | 8 | |
| ResidualLength_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 |
| TopExtension | Double | 8 | |
| TopExtension_Output | Double | 8 | |
| TopExtension_Unit | Text | 255 | |
| Units | Double | 8 | |
| Units_Output | Double | 8 | |
| Units_Unit | Text | 255 | |
| UsedLength | Double | 8 | |
| UsedLength_Output | Double | 8 | |
| UsedLength_Unit | Text | 255 | |
| VisibleSurface | Double | 8 | |
| VisibleSurface_Output | Double | 8 | |
| VisibleSurface_Unit | Text | 255 | |
| Weight | Double | 8 | |
| Weight_Output | Double | 8 | |
| Weight_Unit | Text | 255 | |
| WeightEstimation | Double | 8 | Weight (Estimation) in kilogram |
| WeightEstimation_Output | Double | 8 | Weight (Estimation) in your LogiKal unit |
| WeightEstimation_Unit | Text | 255 | Weight (Estimation) output unit |