AllArticles
4 minute read
This table summarize all amounts of different articles.
| Name | Type | Size | Description | |
|---|---|---|---|---|
| AllArticleID | Long Integer | 4 | PRIMARY KEY | **** |
| Amount | Long Integer | 4 | Article amount | |
| AreaOffer | Text | 255 | AreaOffer | |
| ArticleCode | Text | 255 | Suppliercode + Article number | |
| ArticleCode_BaseNumber | Text | 255 | - | |
| ArticleCode_Number | Text | 255 | - | / |
| ArticleCode_OrderCode | Text | 255 | - | AllArticles.ArticleCode_OrderCode |
| ArticleCode_Supplier | Text | 255 | Suppliername | /\ |
| ArticleType | Long Integer | 4 | ArticleType | |
| ArticleTypePrintout | Long Integer | 4 | ArticleType for printouts | |
| BottomExtension | Double | 8 | Length of BottomExtension in meter | |
| BottomExtension_Output | Double | 8 | BottomExtension in your LogiKal unit | |
| BottomExtension_Unit | Text | 255 | BottomExtension_Output Unit | |
| CoatingColor | Bool | 1 | True if coating will be done by coating company. | |
| Color | Text | 255 | Articlecolor | |
| ColorInfoInternal | Text | 255 | Description for RAL Color | |
| ColorTypeInternal | Long Integer | 4 | ColorTypeInternal (Internal Color type code) | |
| CustomerStockItem | Bool | 1 | 0 = no customerstockitem 1 = customerstockitem | |
| DeliveryStatus | Long Integer | 4 | DeliveryStatus | |
| Depth | Double | 8 | Depth for sheet or isulation | |
| Depth_Output | Double | 8 | Depth in your LogiKal unit | |
| Depth_Unit | Text | 255 | Depth_Output Unit | |
| Description | Text | 255 | Article Description | |
| Dimension1 | Double | 8 | - | |
| Dimension1_Output | Double | 8 | Dimension1 in your LogiKal unit | |
| Dimension1_Unit | Text | 255 | Dimension1_Output Unit | |
| Dimension2 | Double | 8 | - | |
| Dimension2_Output | Double | 8 | Dimension2 in your LogiKal unit | |
| Dimension2_Unit | Text | 255 | Dimension2_Output Unit | |
| Dimension3 | Double | 8 | - | |
| Dimension3_Output | Double | 8 | Dimension3 in your LogiKal unit | |
| Dimension3_Unit | Text | 255 | Dimension3_Output Unit | |
| Discount | Double | 8 | Discount in % | |
| DoNotEstimate | Bool | 1 | 0 = do estimate 1 = do not estimate | |
| HashCode | Text | 255 | To group same Articles | |
| HasSubArticles | Bool | 1 | 0 = has no subarticles 1 = has subarticles | |
| IsAdditional | Bool | 1 | 0 = no additional article 1 = additional article | |
| IsArea | Bool | 1 | 0 = Unit is not area 1 = Unit is area | |
| IsLength | Bool | 1 | 0 = Unit is not length 1 = Unit is length | |
| IsInactive | Bool | 1 | 0 = Article is Available 1 = Color IsInactiv or IsInactiveInVar | |
| IsManual | Bool | 1 | 0 = no manual article 1 = manual article | |
| IsMixedPrice | Bool | 1 | 0 = no mixed price 1 = mixed price | |
| IsPair | Bool | 1 | 0 = packing unit is not pair 1 = packing unit pair | |
| IsPiece | Bool | 1 | 0 = Unit is not Piece 1 = Unit is Piece | |
| IsResidual | Bool | 1 | 0 = no residual length 1 = residual length | |
| IsSalesPriceItem | Bool | 1 | 0 = no sales price item 1 = sale price item | |
| IsVolume | Bool | 1 | 0 = Unit is not Volume 1 = Unit is Volume | |
| IsWeight | Bool | 1 | 0 = Unit is not Weight 1 = Unit is Weight | |
| Length | Double | 8 | Length in meter | |
| Length_Output | Double | 8 | Length in your LogiKal unit | |
| Length_Unit | Text | 255 | Length output unit | |
| LK_ManufacturerId | Long Integer | 4 | LOOKUP KEY refers to Manufacturers.ManufacturersID | **** |
| LK_ColorID | Long Integer | 4 | LOOKUP KEY refers to Colors.ColorID | **** |
| LK_DiscountId | Long Integer | 4 | LOOKUP KEY refers to EstimationDiscounts.EstimationDiscountID | **** |
| 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 | ||
| Perimeter | Double | 8 | Perimeter in meter | |
| Perimeter_Output | Double | 8 | Perimeter in your LogiKal unit | |
| Perimeter_Unit | Text | 255 | Perimeter output unit | |
| 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 | |
| PieceListType | Long Integer | 4 | PieceListType | |
| Price | Double | 8 | Price (netto) | |
| PriceGross | Double | 8 | Price (brutto) | |
| ProcessingPoint | Text | 255 | Processing point description | |
| ProcessingPointType | Long Integer | 4 | ProcessingPointType | |
| ProductGroup | Text | 255 | Customized product groups only in user Database | |
| PUAmount | Double | 8 | Amount of packaging unit | |
| PUSize | Double | 8 | Size of packaging unit | |
| PUSize_Output | Double | 8 | Amount of your LogiKal packaging unit | |
| PUSize_Unit | Text | 255 | Packaging output unit | |
| SubNo | Long Integer | 4 | Subposition number | |
| SubSize | Double | 8 | Sub amount of one packaging unit | |
| SubType | Long Integer | 4 | SubType | |
| SupplierCode | Long Integer | 4 | ||
| SupplierId | Long Integer | 4 | FOREIGN KEY refers to Suppliers.SupplierID | **** |
| TopExtension | Double | 8 | Length of TopExtension in meter | |
| TopExtension_Output | Double | 8 | TopExtension in your LogiKal unit | |
| TopExtension_Unit | Text | 255 | TopExtension_Output Unit | |
| 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 |