Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

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
(8,2) the total number of digits before and after the decimal point.

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
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  - 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.

Prod Dimensions

Prod Analysis

Produ Notes

Product Waste

+ about 15 more fields.

If we ask you to ADD any further fields they would be added at the end of the existing import table

  • No labels