...
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 e.g 42.00 17.00 18.43 26.40 |
Field Name | Field Type | Nulls | Notes |
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 | |
NoOfCases | int | Do not include frozen quantity within this | |
NoOfBottles | 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 |
...