ITEMLOCBIN FILE
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
IC138 IC241
UPDATED BY
IC38.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ILB-COMPANY Numeric 4 IC38.1
Company The company number represents an
established company and is entered on
all function codes.
ILB-LOCATION Alpha 5 IC38.1
Location Code This field contains a valid stocking
location within the company inventory.
ILB-ITEM Alpha 32 IC38.1
Item Number This field contains the item
identifier.
ILB-BIN Alpha 7 IC38.1
Bin This field contains a storage area for
an item or any number of items.
ILB-UOM Alpha 4 IC38.1
Unit of Measure This is a valid tracking unit of
measure for this bin for this item.
ILB-REPL-FROM-BIN Alpha 7 IC38.1
Replenishment From This field contains the replenishment
Bin from bin. This bin number is in the
replenishment from location.
ILB-ORDER-POLICY Alpha 3 IC38.1
Ordering Policy This field contains the method of
reordering.
FOP = Fixed Order Point Method
ILB-REORD-PT-CD Alpha 1 IC38.1
Reorder Point Code 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 Alpha 1 IC38.1
Reorder Quantity This field contains the reorder
Code 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 Signed 13.4 IC38.1
Reorder Point 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 Signed 13.4 IC38.1
Reorder Quantity 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 Numeric 4 IC38.1
Order Multiple This field contains the order multiple.
The reorder quantity is a multiple of
this quantity.
ILB-MAX-ORDER Signed 13.4 IC38.1
Maximum Order This field contains the maximum level
Quantity of inventory needed.
ITEMLOCBIN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILBSET1 COMPANY IC138 IC241
LOCATION IC38.1
ITEM
BIN
UOM
ITEMLOCBIN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
ILB-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
ILB-COMPANY -> ICL-COMPANY
ILB-LOCATION -> ICL-LOCATION
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
ILB-ITEM -> ITE-ITEM
ITEMLOCBIN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Sohdetail SOHDETAIL
ILB-COMPANY -> SDT-COMPANY
ILB-LOCATION -> SDT-LOCATION
ILB-ITEM -> SDT-ITEM
ILB-BIN -> SDT-BIN
SDT-UOM
SDT-LOT
SDT-SUBLOT
|
