Where the import reads UNIT then this is the CASE value.
Field Types
Field Type | Explanantion |
|---|---|
int | integer fields |
bit | Yes or No fields 1 for Yes and 0 for No |
date | format dd/mm/yy or dd/mm/yyyy |
nvarchar (11) | text field with maximum length 11 |
decimal (8,2) | Decimal field must include the decimal and 00 e.g 42.00 17.00 18.43 26.40 |
Field Name | Example | Requirement | Field Type | Max Length | Notes |
FKCustomer | 56 | Mandatory | varchar | 12 | The unique code that you provided for the customer when it was imported, usually the code their stock records are held under. |
FKProductGroup | 1 | Mandatory | int | 6 | See reference table Product Groups we are looking for the CODE in RED |
FKVATCode | 2 | Mandatory | int | 1 | Enter Either |
FKCommodityCode | 2204217900 | Mandatory | varchar | 10 | Use the commodity code, no spaces no dashes - should be to 10 digits |
FKCountryWhenceConsigned | DE | Mandatory | varchar | 2 | The 2 digit country code where the goods would normally come from, this is generally the same as the Country of Origin e.g GB for the United Kingdom or NZ for New Zealand. |
FKCountryOfOrigin | CH | Mandatory | varchar | 2 | The 2 digit country code where the goods originate from. e.g GB for the United Kingdom or NZ for New Zealand. |
FKTaxCode | 777 | Mandatory | varchar | 3 | Excise Tax Code - Use 777 if not applicable. |
FKProductType | 2 | Mandatory | varchar | 2 | See reference table Product Types we are looking for the CODE in RED |
ProductCode | 08071A | Mandatory | varchar | 20 | |
ProductDescription | SANTA TERESA GRAND | Mandatory | varchar | 50 | Product Description in English |
PackageDescription | 漢字 | varchar | Product Description NON English | ||
AlternativeCode |
| varchar | |||
AlternativeDescription |
| varchar | |||
KilogramsPerUnit | 0 | Conditional | decimal | 8.2 | For Tobacco products only |
SinglesPerUnit | 6 | Mandatory | int | 5 | Known as SPC or Singles per case. Must be less than 32000 |
SingleSize | 0.7 | Mandatory | decimal | 8.3 | Single size is 1.00 when there is no quantifiable quantity, otherwise in Litres |
UnitsPerPallet | 1 | Mandatory | int | 5 | Known as CPP or Cases per pallet. Max 32000, use 1 if not known |
UnitsPerLayer | 1 | Mandatory | int | 5 | Known as CPL or Cases per Layer Max 256, use 1 if not known |
Height | 0 | decimal | 5.2 | of the pallet in metres | |
ContainerQuantity | 0 | int | 5 | In number of cases Max 32000 | |
NetWeightKG | 4.2 | Mandatory | decimal | 5.2 | per Case in KG with decimal places |
GrossWeightKG | 7.14 | Mandatory | decimal | 5.2 | per Case in KG with decimal places Must be more or equal to netweightkg |
MinStockLevel | 0 | int | 5 | in cases | |
MinPurchaseOrderQuantity | 0 | int | 5 | in cases | |
MinSalesOrderQuantity | 0 | int | 5 | in cases | |
TraderUnitCode | NULL | varchar | 20 | Barcode for the Case | |
SubUnitCode | NULL | varchar | 20 | Barcode for the Single Item | |
StrengthABV | 37.9 | Conditional | decimal | 8.2 | The ABV % strength e.g. 37.5% = 37.50 Mandatory for liquid alcoholic products otherwise blank |
LitresLiquidPerUnit | 4.2 | decimal | 8.2 | Known as LOL - per Case e.g. SPC x SS = LOL Mandatory for liquid alcoholic products otherwise blank | |
LitresAlcoholPerUnit | 1.68 | decimal | 8.2 | Known as LOA - per Case e.g LOL x (Strength/100) = LOA Mandatory for liquid alcoholic products otherwise blank | |
CigarettesPerUnit | 0 | int | 3 | per Case Mandatory for cigarettes | |
CigarettesSellingPricePerUnit | 0 | decimal | 8.2 | Money field must include the 2 digits after the decimal. Mandatory for cigarettes | |
ProductLife | 0 | int | 3 | No of days product should have on receipt into the warehouse | |
ShelfLifeDays | 0 | int | 3 | No of days for this product which must availble for when stock is selected for the order. This is the default EDI orders are able to over ride this. e.g. 90 days means it must expire at least 90 days after the order pick begins. | |
ProductCostPerUnit | 17 | decimal | 8.2 | Money field must include the 2 digits after the decimal. | |
ProductCostCurrency | GBP | varchar | 3 | The 3 digit ISO code for the currency e.g. GBP, USD, EUR | |
FKBrand | Brand Name or Producer | Mandatory | varchar | 50 | |
Vintage | 2007 | Mandatory | varchar | 4 | Use either a 4 digit year OR NA or NV |
SSCCMandatory | 0 | bit | 1 | Requirement to collect SSCC on receipt (not advised - use Despatches need SSCC when possible) | |
TransportAdjustment | 50 | decimal | 3.2 | Used for Vision Distribution connected systems only. The discount or surcharge from the standard CASE calculation for this product e.g. a -50% means that this case would could as a 0.5 case towards the transport invoice total. | |
TransportAdjustmentSign | - | varchar | 1 | Either - or + to indicate whether the transport adjustment field is a discount or a surcharge | |
DegreePlato | 1 | Conditional | int | 2 | Mandatory for liquid alcoholic products otherwise blank Used for products being shipped to DE/AT/CZ/CH/SK/SL/BG/PL and some others in east europe as they calculate duties based on the degree plato. |
FKTaxCodeAdditional | 777 | Conditional | varchar | 3 | If the product is an items with an additional code then this is mandatory otherwise it should be left blank. The code should be the additional excise code in addition to the standard one. |
DoNotApplyTransportDiscount | 0 | NA | 1 | New field introduction during 2019 replacing Transport Adjustment | |
DespatchesNeedSSCC | 0 | bit | 1 | If you want to record all items leaving the warehouse of this product with their SSCC codes then this should be set to Y otherwise you can leave blank. | |
FKUOM | 1 | Mandatory | int | 1 | See Reference Table UOM Options we are looking for the CODE in RED |
CubicMetres | NULL | decimal | 8.3 | The size of the product and used only when charging is based on the size of the product. | |
If we ask you to ADD any further fields they would be added at the end of the existing import table |