Articles
4 minute read
This table show the articles, which are used in the insertions.
| Name | Type | Size | Description |
|---|---|---|---|
| Alias | Text | 255 | The Alias of the articles set in the stammdaten |
| Amount | Long Integer | 4 | Article amount |
| AreaOffer | Text | 255 | AreaOffer |
| ArticleCode | Text | 255 | |
| ArticleCode_BaseNumber | Text | 255 | |
| ArticleCode_Number | Text | 255 | |
| ArticleCode_OrderCode | Text | 255 | |
| ArticleCode_Supplier | Text | 255 | |
| ArticleID | Long Integer | 4 | PRIMARY KEY |
| ArticleType | Long Integer | 4 | ArticleType |
| ArticleTypePrintout | Long Integer | 4 | ArticleType for printouts |
| BottomExtension | Double | 8 | |
| BottomExtension_Output | Double | 8 | |
| BottomExtension_Unit | Text | 255 | |
| Color | Text | 255 | |
| ColorInfoInternal | Text | 255 | |
| ColorTypeInternal | Long Integer | 4 | ColorTypeInternal |
| CustomerStockItem | Bool | 1 | 0 = no customer stock item 1 = customer stock item |
| DeliveryStatus | Long Integer | 4 | DeliveryStatus |
| Depth | Double | 8 | |
| Depth_Output | Double | 8 | |
| Depth_Unit | Text | 255 | |
| Description | Text | 255 | |
| Dimension1 | Double | 8 | |
| Dimension1_Output | Double | 8 | |
| Dimension1_Unit | Text | 255 | |
| Dimension2 | Double | 8 | |
| Dimension2_Output | Double | 8 | |
| Dimension2_Unit | Text | 255 | |
| Dimension3 | Double | 8 | |
| Dimension3_Output | Double | 8 | |
| Dimension3_Unit | Text | 255 | |
| Discount | Double | 8 | Discount in % |
| DoNotEstimate | Bool | 1 | 0 = estimate this article 1 = do not estimate this article |
| FromHardware | Long Integer | 4 | FromHardware |
| Hashcode | Text | 255 | |
| HasSubArticles | Bool | 1 | |
| InsertionId | Long Integer | 4 | FOREIGN KEY refers to Insertions.InsertionID |
| InsertionNo | Long Integer | 4 | |
| InsertionSubNo | Long Integer | 4 | |
| IsAdditional | Bool | 1 | 0 = no additional article 1 = additional article |
| IsArea | Bool | 1 | 0 = no is area article 1 = area article |
| IsLength | Bool | 1 | 0 = no length article 1 = length article |
| IsInactive | Bool | 1 | 0 = Article is Available 1 = Color IsInactiv or IsInactiveInVar |
| IsManual | Bool | 1 | |
| IsMixedPrice | Bool | 1 | |
| IsPair | Bool | 1 | 0 = no is pair article 1 = pair article |
| IsPiece | Bool | 1 | 0 = no piece article 1 = piece article |
| IsSalesPriceItem | Bool | 1 | 0 = no salespriceitem 1 = salespriceitem |
| IsVolume | Bool | 1 | 0 = no volume article 1 = volume article |
| IsWeight | Bool | 1 | 0 = no weight article 1 = weight article |
| Layer | Long Integer | 4 | |
| Length | Double | 8 | Length in meter |
| Length_Output | Double | 8 | Length in your LogiKal unit |
| Length_Unit | Text | 255 | Lenght output unit |
| 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 KEY refers to KfmKeys.KfmKeyID |
| LK_SupplierId | Long Integer | 4 | LOOKUP KEY refers to Suppliers.SupplierID |
| LockingBarInfo | Text | 255 | |
| LockingBarPos | Text | 255 | |
| LockingBarPosEnum | Long Integer | 4 | |
| LockingBarPosLong | Text | 255 | |
| Material | Long Integer | 4 | Material |
| MaterialDescription | Text | 255 | Material description |
| MixedQty1 | Double | 8 | |
| MixedQty2 | Double | 8 | |
| MountingOrder | 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 |
| PieceListType | Long Integer | 4 | PieceListType |
| Price | Double | 8 | |
| PriceGross | Double | 8 | |
| ProcessingPoint | Text | 255 | Processing 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 |
| SubType | Long Integer | 4 | SubType |
| SupplierCode | Long Integer | 4 | |
| TopExtension | Double | 8 | |
| TopExtension_Output | Double | 8 | |
| TopExtension_Unit | Text | 255 | |
| Units | Double | 8 | |
| Units_Output | Double | 8 | |
| Units_Unit | Text | 255 | |
| UsageOffer | Text | 255 | |
| 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 |
| xSashGUID | Text | 255 | |
| xSegmentGUID | Text | 255 |