Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use

Stock Import, a product has multiple stock records, each record should have a unique rotation number.

...

[Item only optional not mandatory]

You can copy the section below and paste this into an excel spreadsheet to populate the columns, any additional columns shown when pasting which are not in the definition below are surplus to requirement and not needed, you can leave those or simply remove them from the spreadsheet.

SiteCode

CustomerCode

ProductCode

RotationNumber

RotationLineNo

DateReceived

FKReceiptCode

ProductCostperUnit

ProductCostCurrency

InsuranceCostperUnit

InsuranceCostCurrency

FreightCostperUnit

FreightCostCurrency

StrengthABV

UnitsPerPallet

ISFreeCirculation

RentDate

SinglesPerUnit

HasOwnerChangeinUK

ISExciseDutyPaidinUK

CustomsDutyPaidUK

QuotaNumber

CWC

ReceiptDetails1

ReceiptDetails2

ReceiptDetails3

ReserveCustomer

BestBeforeDate

FKDeliveryType

TaxCode

DutyStampsApplied

CommodityCode

CustomerBatchNo

GrossWeight

Vintage

TradeTerm

CigarettesPerUnit

FreeRent

ProductionDate

PackagingType

DegreePlato

OriginalReceiptDate

FirstDateReceivedToStore

Currency_VATValueAdjustment

NilVATApplicable

VATValueAdjustment

SingleSize

Fields

Include Page
VEDI:References Acronymns
VEDI:References Acronymns
RotationLineMust exist in the product tableReceiptTypeInBondValueInBondValueCurrencyInsuranceValueInsuranceValueCurrencyFreightValueFreightValueCurrencyStrength for cigarettesFreeCirculationChangeofOwnershipDutyPaidStockISO 3166 alpha-2 code required for the country of originReceiptDeliveryTypeProduct Types we are looking for the CODE in RED nvarchar(50)2)nvarchar(nvarchar(50)MandatoryInteger Value – do not include frozen quantity within this2)nvarchar(Must be one of the pre-agreed site codesInteger Value assigning to tblStock.FKSupplierOption – pointing to systblSupplierOption.PKSupplierOption

Field Name

Field Type

Nulls

Notes

SiteCode

nvarchar(2)

Mandatory

Must be one of the pre-agreed site codes

CustomerCode

nvarchar(6)

Mandatory

Must exist in the customer table

ProductCode

nvarchar(50)

Mandatory

Must exist in the product table

RotationNumber

nvarchar(10)

Mandatory

The format of the rotation number is

YY/D000000

YY is the year

D is the duty indicator at the time of receipt  D = Duty Paid 0 = Underbond

000000 is a sequential number starting at 0

RotationLineNo

int

Line number can be blank and then starting from 1 upwards.

If using rotation lines the underlying Product must be the same

CustomerRef

nvarchar(6)

Mandatory

Must exist in the customer table

ProductCode

nvarchar(50)

Mandatory

DateReceived

date

Mandatory

Format dd/mm/yyyy or dd/mm/yy

FKReceiptCode

nvarchar(2)

Mandatory

Receipt Type we are looking for the CODE in RED

ProductCostperUnit

decimal(8.2)

Conditional

Must be provided for underbond goods but optional for all others

ProductCostCurrency

nvarchar(3)

Conditional

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies we are looking for the CODE in RED

InsuranceCostperUnit

decimal(8.2)

NULL

InsuranceCostCurrency

nvarchar(3)

NULL

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies we are looking for the CODE in RED

FreightCostperUnit

decimal(8.2)

NULL

FreightCostCurrency

nvarchar(3)

NULL

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies we are looking for the CODE in RED

StrengthABV

decimal (3.2)

NULL

ABV%

LOL

decimal (8.5)

Mandatory

Litres of Liquid / Case - where this is no a liquid then use 1

LOA

decimal (8.5)

Conditional

Litres of Alcohol / Case - must be provided if strength abv provided

1000perCase

UnitsPerPallet

int

Conditional

Integer field whole numbers only,

KgPerCase

decimal (8.5)

Conditional

Decimal 18,5   for tobacco

needed if your using pallets otherwise set to 1

ISFreeCirculation

bit

Mandatory

UKMade

bit

Mandatory

Has customs duty been paid, if yes then 1 otherwise 0

RentDate

date

Rent start date.  Only applicable if an advanced date is required for the start of rent charging

FAFSatisfied

bit

No longer used

SinglesPerCase

SinglesPerUnit

int

Mandatory

must be > 1 (Unit = Case)

HasOwnerChangeinUK

bit

Mandatory

1 is YES and 0 is NO

ISExciseDutyPaidinUK

bit

Mandatory

1 is YES and 0 is NO

CustomsDutyPaidUK

bit

Mandatory

1 is YES and 0 is NO

QuotaNumber

nvarchar(50)

 

COO

nvarchar(2)

Mandatory

CWC

nvarchar(2)

Mandatory

ISO 3166 alpha-2 code required for the country whence consigned

ReceiptDetails1

nvarchar(50)

Header Level - Free Text -Arc or Warrant

ReceiptDetails2

nvarchar(50)

Header Level Free Text – Ship

ReceiptDetails3

nvarchar(50)

Header Level Free Text

ReserveCustomer

nvarchar(8)

Must exist in the reserve customers table

BestBeforeDate

date

 

FKDeliveryType

nvarchar(3)

Mandatory

Receipt Delivery Types we are looking for the CODE in RED

TaxCode

nvarchar(3)

DutyStampsApplied

bit

Mandatory

1 is YES and 0 is NO

CommodityCode

nvarchar(20)

Mandatory

ProductType

nvarchar(1)

Yes

CustomerBatchNo

nvarchar(50)

Batch number

SellByDate

date

GrossWeight

decimal(8,2)

 Weight in kg for the case

Vintage

nvarchar(10)

Mandatory

 Options are one of

  • NV

  • NA

  • 4 digit year

TradeTerm

nvarchar(5)

Mandatory

Customs or Excise Goods - Usually A or B
Determines whether Product OR PIF (CIF) is needed
https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Trade-Terms we are looking for the CODE in RED

CigarettesPerUnit

int

Conditional

 Cigarettes only - depends on what unit of measure you intend to use for this type of product.

FreeRent

bit

Mandatory

PreferenceCertificateNumber

ProductionDate

date

 

PackagingType

nvarchar(8)

Mandatory

 Packaging Types we are looking for the CODE in RED

DegreePlato

decimal(5,

 

CFSPDocumentCode

2)

 

OriginalReceiptDate

date

 

VICertificateNumber

nvarchar(50)

 

VICertificateFKCFSPDocumentCode

 

FirstDateReceivedToStore

date

 

Currency_VATValueAdjustment

nvarchar(3)

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies we are looking for the CODE in RED

LicenseRequired

bit

NilVATApplicable

nvarchar(50)

Mandatory

PresentBottles

int

Integer Value – do not include frozen quantity within this

PresentCases

int

VATValueAdjustment

decimal (8.

BottlesFrozen

int

SiteCode

2)

Mandatory

SingleSize

decimal(8.5)

Mandatory

Where no applicable use 1.00 otherwise Single size, in LITRES, must be greater than 0

FKSupplierOption

int

NULL