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 5 Next »

Use

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

Limitations

The following has to exist already

  • Customer

  • Product

Optionally the following may be needed

  • Reserve Customer

Notes

This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.        

[Item could be derived from Product if needed]

[Item only optional not mandatory]

Fields

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

Field Type

Nulls

Notes

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

RotationLine

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

Must exist in the product table

DateReceived

date

Mandatory

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

ReceiptType

nvarchar(2)

Mandatory

Receipt Type

InBondValue

decimal(8.2)

Conditional

Must be provided for underbond goods but optional for all others

InBondValueCurrency

nvarchar(3)

Conditional

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies

InsuranceValue

decimal(8.2)

NULL

InsuranceValueCurrency

nvarchar(3)

NULL

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies

FreightValue

decimal(8.2)

NULL

FreightValueCurrency

nvarchar(3)

NULL

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies

Strength

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

int

Conditional

Integer field whole numbers only, for cigarettes

KgPerCase

decimal (8.5)

Conditional

Decimal 18,5   for tobacco

FreeCirculation

bit

Mandatory

UKMade

bit

Mandatory

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

int

Mandatory

must be > 1

ChangeofOwnership

bit

Mandatory

DutyPaidStock

bit

Mandatory

CustomsDutyPaidUK

bit

Mandatory

QuotaNumber

nvarchar(50)

 

COO

nvarchar(2)

Mandatory

ISO 3166 alpha-2 code required for the country of origin

CWC

nvarchar(2)

Mandatory

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

ReceiptDetails1

nvarchar(50)

Free Text -Arc or Warrant

ReceiptDetails2

nvarchar(50)

Free Text – Ship

ReceiptDetails3

nvarchar(50)

Free Text

ReserveCustomer

nvarchar(8)

Must exist in the reserve customers table

BestBeforeDate

date

 

ReceiptDeliveryType

nvarchar(3)

Mandatory

Receipt Delivery Types

TaxCode

nvarchar(3)

DutyStampsApplied

bit

Mandatory

CommodityCode

nvarchar(20)

Mandatory

ProductType

nvarchar(1)

Yes

Product Types

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

CigarettesPerUnit

int

Conditional

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

FreeRent

bit

Mandatory

PreferenceCertificateNumber

nvarchar(50)

 

PackagingType

nvarchar(8)

Mandatory

 Packaging Types

DegreePlato

decimal(5,2)

 

CFSPDocumentCode

nvarchar(2)

 

OriginalReceiptDate

date

 

VICertificateNumber

nvarchar(50)

 

VICertificateFKCFSPDocumentCode

nvarchar(50)

 

FirstDateReceivedToStore

date

 

Currency_VATValueAdjustment

nvarchar(3)

https://visionsoftware.atlassian.net/wiki/spaces/IMP/pages/3183116289/WMS+Import+Code+Lists#Currencies

LicenseRequired

bit

Mandatory

NilVATApplicable

nvarchar(50)

Mandatory

PresentBottles

int

Integer Value – do not include frozen quantity within this

PresentCases

int

Integer Value – do not include frozen quantity within this

VATValueAdjustment

decimal (8.2)

BottlesFrozen

int

SiteCode

nvarchar(2)

Mandatory

Must be one of the pre-agreed site codes

SingleSize

decimal(8.5)

Mandatory

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

FKSupplierOption

int

NULL

Integer Value assigning to tblStock.FKSupplierOption – pointing to systblSupplierOption.PKSupplierOption

  • No labels