Where the import reads UNIT then this is the CASE value.
...
SiteCode | CustomerCode | FKProductGroup | FKVATCode | FKCommodityCode | FKCountryWhenceConsigned | FKCountryOfOrigin | FKTaxCode | FKUnitToChargeBy | FKProductType | ProductCode | ProductDescription | PackageDescription | AlternativeCode | AlternativeDescription | KilogramsPerUnit | SinglesPerUnit | SingleSize | UnitsPerPallet | UnitsPerLayer | Height | ContainerQuantity | NetWeightKG | GrossWeightKG | MinStockLevel | MinPurchaseOrderQuantity | MinSalesOrderQuantity | TraderUnitCode | SubUnitCode | StrengthABV | UsePackageQuantity | IsSerialNumberRequired | LitresLiquidPerUnit | LitresAlcoholPerUnit | CigarettesPerUnit | CarriagePricePerUnit | CIFPricePerUnit | SalesPricePerUnit | UnderBondSalesPricePerUnit | PurchaseCostPerUnit | InsurancePricePerUnit | FKSubtituteProduct1 | FKSubtituteProduct2 | FKSubtituteProduct3 | CigarettesSellingPricePerUnit | ProductLife | sysTimeStamp | ShelfLifeDays | ProductCostPerUnit | FKProductCostCurrency | FKInsuranceCostCurrency | FKFreightCostCurrency | ProductCostCurrency | InsuranceCostCurrency | FreightCostCurrency | IsArchive | FKBrand | Vintage | SSCCMandatory | TransportAdjustment | TransportAdjustmentSign | UPCTraderUnitCode | UPCSubUnitCode | DegreePlato | VLProductCode | ProductGroup | CasesPerLayer | SubstituteProduct1 | SubstituteProduct2 | SubstituteProduct3 | FKTaxCodeAdditional | DoNotApplyTransportDiscount | DespatchesNeedSSCC | FKUOM | CubicMetres | BOM | FKPackagingType | AdditionalInfo1 | AdditionalInfo2 | AdditionalInfo3 | AdditionalInfo4 | AdditionalInfo5 | AdditionalInfo6 | AdditionalInfo7 | LengthCM | WidthCM | HeightCM | SingleHeightCM | SingleLengthCM | SingleWidthCM | PrimaryWeightGSingle | SecondaryWeightGSingle | TertiaryWeightGSingle |
Field Name | Example | Requirement | Field Type | Notes |
SiteCode | XY | Mandatory | varchar(2) | The site code for where the customer record exists, when you provided the site information we would have either used your existing or provided a code for Vision. |
CustomerCode | JONES01 | 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 | See reference table Product Groups we are looking for the CODE in RED |
FKVATCode | 2 | Mandatory | int | 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(50) | Product Description NON English only | |
AlternativeCode |
| varchar(20) | ||
AlternativeDescription |
| varchar(50) | ||
KilogramsPerUnit | 0 | Conditional | decimal(8,2) | For Tobacco products only |
SinglesPerUnit | 6 | Mandatory | int | 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 | Known as CPP or Cases per pallet. Max 32000, use 1 if not known |
UnitsPerLayer | 1 | Mandatory | int | 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 | 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 | in cases | |
MinPurchaseOrderQuantity | 0 | int | in cases | |
MinSalesOrderQuantity | 0 | int | 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 | 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 | No of days product should have on receipt into the warehouse | |
ShelfLifeDays | 0 | int | 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 | Requirement to collect SSCC on receipt (not advised - use Despatches need SSCC when possible) | |
TransportAdjustment | 50 | decimal(5,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 | 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. |
VLProductCode | varchar(30) | Used to store the Livex product code. | ||
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 | Required | bit | New field to replacing Transport Adjustment (0 - No and 1 - Yes) |
DespatchesNeedSSCC | 0 | Required | bit | 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 | 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. | |
BOM | 0 | Required | bit | Is this a Bill of Materials Product - if you state yes to this then you MUST also supplie the ProductMixComponents import for any product marked as 1 in this list. |
FKPackagingType | Mandatory | int | ||
AdditionalInfo1 | varchar(50) | Additional fields, generally not used but can be setup for specific purposes on a product level. e.g. These are used by Livex lookup for wine and spirit products where Livex are able to supply considerable additional product informaiton for the product. | ||
AdditionalInfo2 | varchar(50) | |||
AdditionalInfo3 | varchar(50) | |||
AdditionalInfo4 | varchar(50) | |||
AdditionalInfo5 | varchar(50) | |||
AdditionalInfo6 | varchar(50) | |||
AdditionalInfo7 | varchar(50) | |||
LengthCM | int | Case measurements | ||
WidthCM | int | |||
HeightCM | int | |||
SingleHeightCM | int | Single item measurements | ||
SingleLengthCM | int | |||
SingleWidthCM | int | |||
PrimaryWeightGSingle | decimal(8,3) | Waste packaging information which will be used on the waste packaging report. | ||
SecondaryWeightGSingle | decimal(8,3) | |||
TertiaryWeightGSingle | decimal(8,3) | |||
If we ask you to ADD any further fields they would be added at the end of the existing import table |