Use
Stock Import, a product has multiple stock records, each record should have a unique rotation number.
...
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 | |
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% |
UnitsPerPallet | int | Conditional | Integer field whole numbers only, needed 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 | |
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) |
| |
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 | |
CustomerBatchNo | nvarchar(50) | Batch number | |
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 | |
ProductionDate | date |
| |
PackagingType | nvarchar(8) | Mandatory | Packaging Types we are looking for the CODE in RED |
DegreePlato | decimal(5,2) |
| |
OriginalReceiptDate | date |
| |
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 | |
NilVATApplicable | nvarchar(50) | Mandatory | |
VATValueAdjustment | decimal (8.2) | ||
SingleSize | decimal(8.5) | Mandatory | Where no applicable use 1.00 otherwise Single size, in LITRES, must be greater than 0 |
...