SubProfiles
3 minute read
| Name | Type | Size | Description |
|---|---|---|---|
| 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 |
| 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 | Subprofile description |
| InnerColor | Text | 255 | |
| InnerColorInfoInternal | Text | 255 | |
| InnerColorTypeInternal | Long Integer | 4 | |
| IsDualColor | Bool | 1 | 0 = No dual color 1 = Dual color |
| Length | Double | 8 | Length in meter |
| Length_Output | Double | 8 | Length in your LogiKal unit |
| Length_Unit | Text | 255 | Length output unit |
| LK_ColorId | Long Integer | 4 | FOREIGN KEY refers to Colors.ColorID |
| LK_DiscountId | Long Integer | 4 | FOREIGN KEY refers to EstimationDiscounts.EstimationDiscountID |
| LK_KfmKeyId | Long | 4 | FOREIGN KEYrefers to KfmKeys.KfmKeyID |
| 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 |
| 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 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_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 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 (incl. coating) |
| PriceCoating | Double | 8 | Price coating per meter |
| PriceGross | Double | 8 | |
| ProductGroup | Text | 255 | |
| ProfileBarID | Long Integer | 4 | FOREIGN KEY refers to ProfileBars.ProfileBarID |
| PUSize | Double | 8 | Amount of packaging unit |
| PUSize_Output | Double | 8 | Amount of your LogiKal packaging unit |
| PUSize_Unit | Text | 255 | Packaging output unit |
| Side | Long Integer | 4 | |
| SubProfileID | Long Integer | 4 | PRIMARY KEY |
| SubSize | Double | 8 | Sub amount of one packaging unit |
| SupplierCode | Long Integer | 4 | |
| VisibleSurface | Double | 8 | |
| VisibleSurface_Output | Double | 8 | |
| VisibleSurface_Unit | Text | 255 | |
| Weight | Double | 8 | Weight in kilogram |
| Weight_Output | Double | 8 | Weight in your LogiKal unit |
| Weight_Unit | Text | 255 | Weight output unit |