Page Comparison

Field Name

Field Type

Nulls

Notes

RotationNumber

nvarchar

(50)

NULL

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

nvarchar

(50)

NULL

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

If using rotation lines the underlying Product must be the same

CustomerRef

nvarchar

(50)

NULL

Must exist in the customer table

ProductCode

nvarchar

(50)

NULL

Must exist in the product table

DateReceived

nvarchar

(50)

NULL

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

ReceiptType

nvarchar

(50)

NULL

HMRC 2 digit receipt type code or

InBondValue

decimal(8.2)

NULL

Money value 0.00

InBondValueCurrency

nvarchar

(

3)

NULL

Three digit ISO code e.g. USD, GBP, EUR

InsuranceValue

decimal(8.2)

NULL

Money value 0.00

InsuranceValueCurrency

nvarchar

(

3)

NULL

Three digit ISO code e.g. USD, GBP, EUR

FreightValue

decimal(8.2)

NULL

Money value 0.00

FreightValueCurrency

nvarchar

(

3)

NULL

Three digit ISO code e.g. USD, GBP, EUR

Strength

nvarchar

(50)

NULL

Decimal field 8,3

LOL

nvarchar

(50)

NULL

Decimal field 18,5

LOA

nvarchar

(50)

NULL

Decimal field 18,5

1000perCase

nvarchar

(50)

NULL

Integer field whole numbers only, for cigarettes

KgPerCase

nvarchar

(50)

NULL

Decimal 18,5   for tobacco

FreeCirculation

nvarchar

(50)

NULL

true / false (case sensitive!)

UKMade

nvarchar

(50)

NULL

True / False

RentDate

nvarchar

(50)

NULL

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

FAFSatisfied

nvarchar

(50)

NULL

True / False

BottlesPerCase

nvarchar

(50)

NULL

Integer field

ChangeofOwnership

nvarchar

(50)

NULL

true / false (case sensitive!)

DutyPaidStock

nvarchar

(50)

NULL

true / false (case sensitive!)

CustomsDutyPaidUK

nvarchar

(50)

NULL

True / False

QuotaNumber

nvarchar

(50)

NULL

COO

nvarchar

(50)

NULL

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

CWC

nvarchar

(50)

NULL

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

ReceiptDetails1

nvarchar

(50)

NULL

Free Text -Arc or Warrant

ReceiptDetails2

nvarchar

(50)

NULL

Free Text – Ship

ReceiptDetails3

nvarchar

(50)

NULL

Free Text

OriginalRotationNo

nvarchar

(50)

NULL

Only use if you have the original rotation available.

OriginalRotationLine

nvarchar

(50)

NULL

UKCustomsValue

nvarchar

(50)

NULL

For vat value adjustment

ReserveCustomer

nvarchar

(50)

NULL

Must exist in the reserve customers table

CustomsPaymentDocumentReference

nvarchar

(50)

NULL

If known

CustomsPayDate

nvarchar

(50)

NULL

If known

BestBeforeDate

nvarchar

(50)

NULL

SupplierCode

nvarchar

(50)

NULL

AlternativeProduct

nvarchar

(50)

NULL

LotMark

nvarchar

(50)

NULL

Not used

ReceiptDeliveryType

nvarchar

(50)

NULL

Was this a PUR – Purchase  RET- Return  - COL- Collection

If not known then use DTO – Data Take On

NoOfPallets

nvarchar

(50)

NULL

Cases per Pallet

TaxCode

nvarchar

(50)

NULL

Is required

DutyStampsApplied

nvarchar

(50)

NULL

true / false (case sensitive!)

CommodityCode

nvarchar

(50)

NULL

Is required

DutyCategory

nvarchar

(50)

NULL

HMRC Duty Category

ProductType

nvarchar

(50)

NULL

As per the product -  B / T/ W / S / I / Z / C etc

CustomerBatchNo

nvarchar

(50)

NULL

Batch number

SellByDate

datetime

NULL

GrossWeight

nvarchar

(50)

NULL

Vintage

nvarchar

(10)

NULL

TradeTerm

nvarchar

(5)

NULL

A/ B / E

CigarettesPerUnit

nvarchar

(50)

NULL

FreeRent

nvarchar

(10)

NOT NULL

true / false (case sensitive!)

PreferenceCertificateNumber

nvarchar

(50)

NULL

PackagingType

nvarchar

(5)

NULL

DegreePlato

decimal

(5,2)

NULL

CFSPDocumentCode

nvarchar

(2)

NULL

OriginalReceiptDate

nvarchar

(50)

NULL

VICertificateNumber

nvarchar

(50)

NULL

VICertificateFKCFSPDocumentCode

nvarchar

(50)

NULL

FirstDateReceivedToStore

nvarchar

(50)

NULL

Currency_VATValueAdjustment

nvarchar

(50)

NULL

Three digit ISO code e.g. USD, GBP, EUR

LicenseRequired

nvarchar

(50)

NULL

true / false (case sensitive!)

NilVATApplicable

nvarchar

(50)

NULL

True / False

PresentBottles

nvarchar

(50)

NULL

Integer Value – do not include frozen quantity within this

PresentCases

nvarchar

(50)

NULL

Integer Value – do not include frozen quantity within this

ReceiptDocRef

nvarchar

(50)

NULL

UCRReference

nvarchar

(50)

NULL

UCRSubReference

nvarchar

(50)

NULL

VATValueAdjustment

nvarchar

(50)

NULL

Decimal value

BottlesFrozen

nvarchar

(50)

NULL

Integer Value

SiteCode

nvarchar

(50)

NOT NULL

Must be one of the pre-agreed site codes

SingleSize

nvarchar

(50)

NULL

Single (bottle) size, in LITRES, must be greater than 0

FKSupplierOption

int

NULL

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