Use
Stock Import, a product has multiple stock records, each record should have a unique rotation number.
...
[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.
...
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 | ||||
|---|---|---|---|---|
|
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 | CustomerRefnvarchar(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|||||||||
FKReceiptCode | nvarchar(2) | Mandatory | Receipt Type we are looking for the CODE in RED | InBondValue|||||||||
ProductCostperUnit | decimal(8.2) | Conditional | Must be provided for underbond goods but optional for all others | InBondValueCurrency|||||||||
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 | InsuranceValueCurrency||||||||||
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 | FreightValueCurrency||||||||||
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, | for cigarettes||||||||
KgPerCase | decimal (8.5) | Conditional | Decimal 18,5 for tobacco | |||||||||
FreeCirculation | bit | Mandatory | UKMade | bit | Mandatoryneeded if your using pallets otherwise set to 1 | |||||||
ISFreeCirculation | 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 | DutyPaidStock1 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 | 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) | 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 |
| ReceiptDeliveryType||||||||||
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 | Product Types we are looking for the CODE in RED | |||||||||
CustomerBatchNo | nvarchar(50) | Batch number | SellByDatedate |
| ||||||||
GrossWeight | decimal(8,2) | Weight in kg for the case | ||||||||||
Vintage | nvarchar(10) | Mandatory | Options are one of
| |||||||||
TradeTerm | nvarchar(5) | Mandatory | Customs or Excise Goods - Usually A or B | |||||||||
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, | 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 we are looking for the CODE in RED | ||||||||||
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