Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACRECPOT


                             MACRECPOT FILE

UPDATED BY

MA53.5    MA53.1    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRP-COMPANY            Numeric 4                                 MA53.5  MA531
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.

MRP-REFERENCE-NO       Alpha 10  (Right Justified)               MA53.5  MA531
Element: Reference No

MRP-LINE-NBR           Numeric 6                                 MA53.5  MA531
Element: Line Number   This field contains the line number.

MRP-SEQ                Numeric 3                                 MA53.5  MA531
Element: Sequence NumbeThis field contains the record sequence
                       number.

MRP-ADJ-REF-NBR        Alpha 10  (Right Justified)               MA531
Element: Reference No

MRP-LOT                Alpha 10                                  MA53.5  MA531
Element: Lot Number    This field contains the identifier for
                       the homogeneous quantity of material.

MRP-SUBLOT             Alpha 6                                   MA53.5  MA531
Element: Sublot Number This field contains the identifier for
                       a detail breakdown of a lot number.

MRP-SERIAL             Alpha 16                                  MA53.5  MA531
Element: Serial Number

MRP-BIN                Alpha 7                                   MA53.5  MA531
Element: Bin           This field contains a storage area for
                       an item or any number of items.

MRP-ITEM               Alpha 32                                  MA531
Element: Item Number   This field contains the item
                       identifier.

MRP-QUANTITY           Signed 13.4                               MA53.5  MA531
Element: Quantity      This field contains the desired
                       quantity.

MRP-SECONDARY-QTY      Signed 13.4                               MA53.5  MA531
Element: Secondary QuanThis field contains the secondary
                       quantity, which is tracked if the item
                       is a catch weight item.  This quantity
                       is a memo quantity only.  It is not used
                       for valuation.


MRP-HOLD-FLAG          Alpha 1                                   MA53.5  MA531
Element: On Hold Flag  This field enables this entire lot to
                       be put on hold, not allowing any issues
                       or transfers to be made for this lot.

MRP-EXPIRE-DATE        Numeric 8  (yyyymmdd)                     MA53.5  MA531
Element: Expiration DatThis field contains the expiration date
                       for an entire lot.

                         MACRECPOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRPSET1   COMPANY                                                MA53.1  MA53.5
          REFERENCE-NO                                           MA531
          LINE-NBR
          SEQ

MRPSET2   COMPANY                                                MA531
          REFERENCE-NO
          ADJ-REF-NBR
          LINE-NBR
          SEQ