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.
UPDATED 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.	IC38.1
ILB-LOCATION Element: Location	Alpha 5 This field contains a valid stocking location within the company inventory.	IC38.1
ILB-ITEM Element: Item	Alpha 32 This field contains the item identifier.	IC38.1
ILB-BIN Element: Bin	Alpha 7 This field contains a storage area for an item or any number of items.	IC38.1
ILB-UOM Element: Uom	Alpha 4 This is a valid tracking unit of measure for this bin for this item.	IC38.1
ILB-REPL-FROM-BIN Element: Bin	Alpha 7 This field contains the replenishment from bin. This bin number is in the replenishment from location.	IC38.1
ILB-ORDER-POLICY Element: Order Policy	Alpha 3 This field contains the method of reordering. FOP = Fixed Order Point Method	IC38.1
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	IC38.1
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	IC38.1
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.	IC38.1
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.	IC38.1
ILB-ORDER-MULT Element: Order Mult	Numeric 4 This field contains the order multiple. The reorder quantity is a multiple of this quantity.	IC38.1
ILB-MAX-ORDER Element: Max Order	Signed 13.4 This field contains the maximum level of inventory needed.	IC38.1

ITEMLOCBIN FILE INDEX

ITEMLOCBIN FILE RELATIONS

ONE TO ONE RELATIONS

ITEMLOCBIN FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.