...
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 |