| Name | Description | Type | Additional information |
|---|---|---|---|
| ID |
Caliq internal unique identifier |
integer |
None. |
| Code |
User entered unique part number |
string |
Max length: 25 |
| Description |
Short product description |
string |
Max length: 80 |
| Status |
Item status Values: "1" - an active item, "2" - item is still active but when stock is gone no more will be ordered, "3" - item is no longer available for sale |
integer |
None. |
| CanSell |
Can this item be sold?. This overrrides any brand level settings for display of the item |
boolean |
None. |
| Code2 |
User entered secondary reference |
string |
Max length: 25 |
| Code3 |
User entered tertiary reference |
string |
Max length: 25 |
| Barcode1 |
Caliq Item barcode |
string |
Max length: 25 |
| Barcode2 |
Caliq Inner barcode |
string |
Max length: 25 |
| Barcode3 |
Caliq Outer barcode |
string |
Max length: 25 |
| Barcode4 |
Caliq EPOS barcode |
string |
Max length: 25 |
| DrawingRef | string |
Max length: 40 |
|
| SpareRef1 |
Extra field which can be used for sundry data |
string |
Max length: 30 |
| SpareRef2 |
Extra field which can be used for sundry data |
string |
Max length: 30 |
| SpareRef3 |
Extra field which can be used for sundry data |
string |
Max length: 30 |
| Style | string |
Max length: 25 |
|
| StockingPolicy |
Stocked, BTO, BTB (Stocked, Bought To Order, Back To Back) |
string |
Max length: 7 |
| StyleRule |
(H)eader, (V)ariant, (N)ormal |
string |
Max length: 1 |
| HandlingType | string |
Max length: 6 |
|
| OverrideDespatchMethodID |
If not null, this product should always be shipped by this despatch method |
integer |
None. |
| VATRate |
VAT Rate applicable to this item |
decimal number |
None. |
| SurchargeBandID |
Links to surchargebands api to give percentage for this item |
integer |
None. |
| MainSupplier |
Name of the main supplier of the item |
string |
Max length: 40 |
| SupplierPart |
Suppliers part number - may be blank |
string |
Max length: 40 |
| SupplierDesc |
Suppliers description - may be blank |
string |
Max length: 50 |
| LeadTimeSupplier |
Suppliers quoted lead time in days |
integer |
None. |
| LeadTimeTransit |
Addition transit days from supplier |
integer |
None. |
| LeadTimeDays |
Total lead time in days - sum of LeadTimeSupplier and LeadTimeTransit |
integer |
None. |
| Manufacturer |
Name of the manufacturer of the item |
string |
Max length: 40 |
| ManufacturerPartNo |
Manufacturer part number |
string |
Max length: 25 |
| UOM |
Unit of measure |
string |
Max length: 10 |
| LaunchYear |
Year the product was launched YYYY |
string |
None. |
| LaunchSeason |
Description of the season the product was launched |
string |
Max length: 40 |
| SeasonSellStart |
Selling season starts in DDMM format |
string |
Max length: 4 |
| SeasonSellEnd |
Selling season ends in DDMM format |
string |
Max length: 4 |
| SeasonBuyStart |
Buying season starts in DDMM format |
string |
Max length: 4 |
| SeasonBuyEnd |
Buying season ends in DDMM format |
string |
Max length: 4 |
| CountryOfOrigin |
Country of origin of the item |
string |
Max length: 30 |
| CataloguePageNo1 |
Page number where the item appears in the catalogue |
string |
Max length: 6 |
| CataloguePageNo2 |
Page number where the item appears in the catalogue |
string |
Max length: 6 |
| CataloguePageNo3 |
Page number where the item appears in the catalogue |
string |
Max length: 6 |
| UsageClass | string |
Max length: 40 |
|
| Cost_Std |
The unit standard cost in main company currency |
decimal number |
None. |
| InnerPackSize |
The number of items in an inner pack |
integer |
None. |
| InnerPackRule |
Do we allow the item to be sold in less that an inner pack? Values: "1" Cannot split a pack, "2" Can Split but warn, "3" Can Split |
integer |
None. |
| OuterPackSize |
The number of items in an outer pack |
integer |
None. |
| OuterPackRule |
Do we allow the item to be sold in less that an outer pack? Values: "1" Cannot split a pack, "2" Can Split but warn, "3" Can Split |
integer |
None. |
| OrderQty |
The quantity to which OrderQtyRule applies |
integer |
None. |
| OrderQtyRule |
What quantities are allowed to be sold? Values: "1" Cannot order less than qty, "2" Can order less but warn, "3" Can order any qty, "4" Can only order multiples of qty, "5" Should order multiples but warn |
integer |
None. |
| ItemHeight |
Height of the item in cm to 3dp |
decimal number |
None. |
| ItemWidth |
Width of the item in cm to 3dp |
decimal number |
None. |
| ItemDepth |
Depth of the item in cm to 3dp |
decimal number |
None. |
| OuterHeight |
Height of the outer pack in cm to 3dp |
decimal number |
None. |
| OuterWidth |
Width of the outer pack in cm to 3dp |
decimal number |
None. |
| OuterDepth |
Depth of the outer pack in cm to 3dp |
decimal number |
None. |
| InnerHeight |
Height of the inner pack in cm to 3dp |
decimal number |
None. |
| InnerWidth |
Width of the inner pack in cm to 3dp |
decimal number |
None. |
| InnerDepth |
Depth of the inner pack in cm to 3dp |
decimal number |
None. |
| ItemWeight |
Weight of the item in kg to 4 dp |
decimal number |
None. |
| ItemCube |
Cubic metres of the item |
decimal number |
None. |
| InnerCube |
Cubic metres of the inner pack |
decimal number |
None. |
| OuterCube |
Cubic metres of the outer pack |
decimal number |
None. |
| InnerWeight |
Weight of the inner in kg to 4 dp |
decimal number |
None. |
| OuterWeight |
Weight of the outer in kg to 4 dp |
decimal number |
None. |
| CommodityCode |
Commodity Code |
string |
Max length: 12 |
| ProductGroup1Code |
Product group level 1 code |
string |
Max length: 4 |
| ProductGroup2Code |
Product group level 2 code |
string |
Max length: 4 |
| ProductGroup3Code |
Product group level 3 code |
string |
Max length: 4 |
| ProductGroup4Code |
Product group level 4 code |
string |
Max length: 4 |
| ProductGroup1Desc |
Product group level 1 description |
string |
Max length: 40 |
| ProductGroup2Desc |
Product group level 2 description |
string |
Max length: 40 |
| ProductGroup3Desc |
Product group level 3 description |
string |
Max length: 40 |
| ProductGroup4Desc |
Product group level 4 description |
string |
Max length: 40 |
| SliceGroup1Code |
Slice group level 1 code |
string |
Max length: 4 |
| SliceGroup2Code |
Slice group level 2 code |
string |
Max length: 4 |
| SliceGroup3Code |
Slice group level 3 code |
string |
Max length: 4 |
| SliceGroup1Desc |
Slice group level 1 description |
string |
Max length: 30 |
| SliceGroup2Desc |
Slice group level 2 description |
string |
Max length: 30 |
| SliceGroup3Desc |
Slice group level 3 description |
string |
Max length: 30 |
| WatchStatus |
Watch status description |
string |
Max length: 30 |
| DateCreated |
Date item was created in Caliq YYYYMMDD |
string |
None. |
| DateFirstRecd |
Date item was first received into stock YYYYMMDD |
string |
None. |
| CanGoOnPallet |
Can this item fit on a pallet |
boolean |
None. |
| RESUDFS |
Collection of user defined fields for this item |
Collection of RESUDFS |
None. |
| Materials |
Collection of materials from which this item is made |
Collection of Materials |
None. |
| IsSalesKit |
Is this items a sales kit? |
boolean |
None. |
| KitBreakdown |
Collection of products which make up this sales kit |
Collection of KitBreakdown |
None. |
| BOMBreakdown |
Collection of products which make up this BOM |
Collection of BOMBreakdown |
None. |
| ImagesAvailable |
Collection of available image types for this item |
Collection of ProductsProductImage |
None. |
| WebData |
Collection of web specifc data |
Collection of WebData |
None. |