Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMLOCBIN


                            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