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
1 - 0.00 Rate (UK bases specifically exempt business)
2 - 20.00 Standard Rate (default unless business is specifically VAT exempt and UK)

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  - See suggestions under Product Types link below for alternatives where excise duty is 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

Packaging Types

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