Import - Stock Frozen
Use
This defines where the stock is located within the warehouse, a product has one or more stock records and each stock record can have one or more location stock records
Limitations
It is important to ensure the total provided here agrees to the stock
Notes
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 Name | type | Required | Notes |
|---|---|---|---|
SiteCode | varchar(2) | Mandatory | Must be the 2 character code we agreed at the configuration stage |
RotationNo | varchar(10) | Mandatory | Must exist |
RotationLineNo | varchar(4) |
|
|
WarehouseLocation | varchar(10) | Mandatory | Must exist |
DateFrozen | date | Mandatory |
|
Reason | varchar(50) | Mandatory | text description of the reason the stock is frozen |
TotalConvertedSinglesFrozen | int | Mandatory |
|
AutoUnfreezeAfter | date |
|
|
FrozenReasonCode | varchar(8) |
| We use “IMP” to indicate on import if you need something else then please discuss this with us. |
FrozenBy | varchar(30) |
| text of the user, if you leave blank we will input “System Import” |
Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.