KfmEntries
2 minute read
| Name | Type | Description |
|---|---|---|
| KfmEntryId | Integer | PRIMARY KEY |
| ManufacturerId | Integer | **FOREIGN KEY **references on Manufacturer.ManufacturerId |
| ArticleNumber | Text | Suppliercode + Article number |
| ArticleNumber_Supplier | Text | Suppliername |
| ArticleNumber_Number | Text | - |
| ArticleNumber_BaseNumber | Text | - |
| ArticleNumber_OrderCode | Text | - |
| ArticleNumber_OriginalNumber | Text | - |
| Description | Text | - |
| ArticleType | Integer | |
| Perimeter | Integer | Perimeter in meter |
| Perimeter_Output | Integer | Perimeter in your LogiKal unit |
| Perimeter_Unit | Integer | Perimeter output unit |
| PerimeterBoundaryBox | Integer | |
| PerimeterBoundaryBox_Output | Integer | |
| PerimeterBoundaryBox_Unit | Text | |
| VisibleSurface | Integer | |
| VisibleSurface_Output | Integer | |
| VisibleSurface_Unit | Text | |
| Weight | Integer | Weight in kilogram |
| Weight_Output | Integer | Weight in your LogiKal unit |
| Weight_Unit | Text | Weight output unit |
| ProfileHeight | Integer | ProfileHeight in meter |
| ProfileHeight_Output | Integer | ProfileHeight in your LogiKal unit |
| ProfileHeight_Unit | Text | ProfileHeight output unit |
| SubSize | Integer | |
| ProcessingPoint | Text | |
| IxValue | Integer | |
| IxValue_Output | Integer | |
| IxValue_Unit | Text | |
| IxValue15 | Integer | |
| IxValue15_Output | Integer | |
| IxValue15_Unit | Text | |
| IxValue20 | Integer | |
| IxValue20_Output | Integer | |
| IxValue20_Unit | Text | |
| IxValue25 | Integer | |
| IxValue25_Output | Integer | |
| IxValue25_Unit | Text | |
| IxValue30 | Integer | |
| IxValue30_Output | Integer | |
| IxValue30_Unit | Text | |
| IxValue35 | Integer | |
| IxValue35_Output | Integer | |
| IxValue35_Unit | Text | |
| IyValue | Integer | |
| IyValue_Output | Integer | |
| IyValue_Unit | Text | |
| WxValue | Integer | |
| WxValue_Output | Integer | |
| WxValue_Unit | Text | |
| WyValue | Integer | |
| WyValue_Output | Integer | |
| WyValue_Unit | Text | |
| BarLength | Integer | |
| BarLength_Output | Integer | |
| BarLength_Unit | Text | |
| IsActive | Bool | |
| IsOnlyRolledByCustomer | Bool | |
| IsPair | Bool | 0 = packing unit is not pair 1 = packing unit pair |
| PUSize | Integer | Amount of packaging unit |
| PUSize_Output | Integer | Amount of your LogiKal packaging unit |
| PUSize_Unit | Text | Packaging output unit |
| ArticlePicture_File | Text | |
| ArticlePicture_WidthMM | Integer | |
| ArticlePicture_HeightMM | Integer | |
| ArticlePicture_Scale | Integer | 1 divided by ArticlePicture_Scale = scale |
| ArticlePicture_Inside | Bool | 0 = Item drawing 1 is outside 1 = Item drawing 1 is inside |
| ArticlePicture_CompCad | BLOB | |
| IsDummyArticle | Bool | 0 = Item is no dummy article 1 = Item is a dummy article |