GasketFrames
3 minute read
| Name | Type | Size | Description |
|---|---|---|---|
| Amount | Long Integer | 4 | Gasketframe 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 |
| CustomerStockItem | Bool | 1 | 0 = no customerstockitem 1 = customerstockitem |
| DeliveryStatus | Long Integer | 4 | DeliveryStatus |
| Description | Text | 255 | Gasketframe description |
| Discount | Double | 8 | Discount in % |
| FieldNo | Long Integer | 4 | |
| FrameType | Long Integer | 4 | 0 = Centre gasket 1 = Glass gasket |
| Gasket1 | Text | 255 | |
| Gasket1_BaseNumber | Text | 255 | |
| Gasket1_Number | Text | 255 | |
| Gasket1_OrderCode | Text | 255 | |
| Gasket1_Supplier | Text | 255 | |
| Gasket2 | Text | 255 | |
| Gasket2_BaseNumber | Text | 255 | |
| Gasket2_Number | Text | 255 | |
| Gasket2_OrderCode | Text | 255 | |
| Gasket2_Supplier | Text | 255 | |
| GasketFrameID | Long Integer | 4 | PRIMARY KEY |
| Height | Double | 8 | Height in meter |
| Height_Output | Double | 8 | Height in your LogiKal unit |
| Height_Unit | Text | 255 | Height output unit |
| InsertionId | Long Integer | 4 | FOREIGN KEY refers to Insertions.InsertionID |
| Layer | Long Integer | 4 | |
| Len1 | Double | 8 | |
| Len1_Output | Double | 8 | |
| Len1_Unit | Text | 255 | |
| Len2 | Double | 8 | |
| Len2_Output | Double | 8 | |
| Len2_Unit | Text | 255 | |
| LK_DiscountId | Long Integer | 4 | LOOKUP KEY refers to EstimationDiscounts.EstimationDiscountID |
| LK_ManufacturerId | Long Integer | 4 | LOOKUP KEY refers to ManufacturersID.ManufacturersID |
| LK_SupplierId | Long Integer | 4 | LOOKUP KEY refers to Suppliers.SupplierID |
| LK_KfmKeyId | Long | 4 | LOOKUP KEYrefers to KfmKeys.KfmKeyID |
| 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 |
| Picture17_CompCad | OLE-Objekt | - | |
| Picture17_File | Text | 255 | Path and filename of gasketframe drawing |
| Picture17_HeightMM | Double | 8 | Gasketframe drawing height in mm |
| Picture17_Inside | Bool | 1 | 0 = Gasketframe drawing is outside 1 = Gasketframe drawing is inside |
| Picture17_Scale | Double | 8 | 1 divided by Picture17_Scale = scale |
| Picture17_WidthMM | Double | 8 | Gasketframe drawing 3 width in mm |
| Price | Double | 8 | |
| PriceGross | Double | 8 | |
| ProcessingPoint | Text | 255 | Proecessing point description |
| ProcessingPointType | Long Integer | 4 | ProcessingPointType |
| ProductGroup | Text | 255 | |
| PUSize | Double | 8 | Amount of packaging unit |
| PUSize_Output | Double | 8 | Amount of your LogiKal packaging unit |
| PUSize_Unit | Text | 255 | Packaging output unit |
| SubNo | Long Integer | 4 | |
| SubSize | Double | 8 | Sub amount of one packaging unit |
| TrilateralType | Long Integer | 4 | TrilateralType |
| Weight | Double | 8 | Weight in Kg |
| Width | Double | 8 | Width in meter |
| Width_Output | Double | 8 | Width in your LogiKal unit |
| Width_Unit | Text | 255 | Width output unit |