|
|
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
Element: Company 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 Alpha 5 IC38.1
Element: Location Code This field contains a valid stocking
location within the company inventory.
ILB-ITEM Alpha 32 IC38.1
Element: Item Number This field contains the item
identifier.
ILB-BIN Alpha 7 IC38.1
Element: Bin This field contains a storage area for
an item or any number of items.
ILB-UOM Alpha 4 IC38.1
Element: Unit of MeasurThis is a valid tracking unit of
measure for this bin for this item.
ILB-REPL-FROM-BIN Alpha 7 IC38.1
Element: Bin This field contains the replenishment
from bin. This bin number is in the
replenishment from location.
ILB-ORDER-POLICY Alpha 3 IC38.1
Element: Ordering PolicThis field contains the method of
reordering.
FOP = Fixed Order Point Method
ILB-REORD-PT-CD Alpha 1 IC38.1
Element: Reorder Point 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
Element: 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
Element: 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
Element: Order MultipleThis 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
|
