Item Location Bin Reorder File
The Item Location Bin Reorder File contains the reorder parameters for replenishing an item at a bin within a location. This reorder data is used to calculate bin to bin replenishment within a location. For example, a picking bin could be set up to be automatically replenished from a bulk bin once the picking bin's stock goes below a specific reorder point.
REFERENCED BY
CX100 | IC138 | IC241 |
IC38.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
ILB-COMPANY Element: Company | Numeric 4 Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. |
|
||
ILB-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||
ILB-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
ILB-BIN Element: Bin | Alpha 7 This field contains a storage area for an item or any number of items. |
|
||
ILB-UOM Element: Uom | Alpha 4 This is a valid tracking unit of measure for this bin for this item. |
|
||
ILB-REPL-FROM-BIN Element: Bin | Alpha 7 This field contains the replenishment from bin. This bin number is in the replenishment from location. |
|
||
ILB-ORDER-POLICY Element: Order Policy | Alpha 3 This field contains the method of reordering. FOP = Fixed Order Point Method |
|
||
ILB-REORD-PT-CD Element: Reord Pt Cd | Alpha 1 This field contains the reorder point code, which indicates how the reorder point quantity is to be determined. F = Fixed Order Point Quantity |
|
||
ILB-REORD-QTY-CD Element: Reord Qty Cd | Alpha 1 This field contains the reorder quantity code, which determines how to order the quantity. F = Fixed Order Quantity D = Difference up to Reorder Point M = Order up to Max Level |
|
||
ILB-REORDER-POINT Element: Reorder Point | Signed 13.4 This field contains the reorder point. Reordering for this item is triggered to occur when the item stock-on-hand quantity falls below this reorder point. |
|
||
ILB-REORDER-QTY Element: Quantity | Signed 13.4 This field contains the normal reorder quantity for the item at this location. This field is maintained by the user or the system, based on reorder quantity code. |
|
||
ILB-ORDER-MULT Element: Order Mult | Numeric 4 This field contains the order multiple. The reorder quantity is a multiple of this quantity. |
|
||
ILB-MAX-ORDER Element: Max Order | Signed 13.4 This field contains the maximum level of inventory needed. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ILBSET1 |
COMPANY LOCATION ITEM BIN UOM |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Iccompany | ICCOMPANY |
Required
| ||||||
Iclocation | ICLOCATION |
Required
| ||||||
Itemmast | ITEMMAST |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Sohdetail | SOHDETAIL |
|
All trademarks and registered trademarks are the property of their
respective owners.