ITEMLOCBIN

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ILBSET1 COMPANY
LOCATION
ITEM
BIN
UOM
CX100 IC138
IC241 IC38.1


ITEMLOCBIN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 11:17:20 2016

Home
Contact Us



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