...
This import originated from an older system so some of the fields are not relevant but remain as part of the standard import tables.
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
Include Page | ||||
---|---|---|---|---|
|
Field Name | Field Type | Nulls | Notes | |||||||||||||
Site Code | nvarchar(2) | Mandatory | Must be one of the pre-agreed site codes | |||||||||||||
WarehouseLocation | nvarchar(20) | Mandatory | This is the location name and must exist already on the system | |||||||||||||
RotationNo | nvarchar(10) | Mandatory | This needs to exist in the stock table already | |||||||||||||
RotationLine | int | Must exist if used in the stock table already | ||||||||||||||
NoOfCasesTotalConvertedSingles | int | Mandatory | Do not include frozen quantity within this | |||||||||||||
NoOfBottlesTotalConvertedSinglesReceived | int | Do not include frozen quantity within this | FrozenCases | int |
| FrozenBottles | int |
| FrozenReason | nvarchar(50) | As you can not split this at data take on use a common reason to identify it afterwards. | SiteCode | nvarchar(2) | Mandatory | Must be one of the pre-agreed site codes |