Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MACRECPOT FILE

UPDATED BY

MA53.5    MA531

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MRP-COMPANY          Numeric 4                                   MA53.5  MA531
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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

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

MRP-SEQ              Numeric 3                                   MA53.5  MA531
Sequence Number      This field contains the record sequence
                     number.


MRP-ADJ-REF-NBR      Alpha 10  (Right Justified)                 MA531
Adj Ref Nbr

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

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

MRP-SERIAL           Alpha 16                                    MA53.5  MA531
Serial Number

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

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

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

MRP-SECONDARY-QTY    Signed 13.4                                 MA53.5  MA531
Secondary Quantity   This 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
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
Expiration Date      This field contains the expiration date
                     for an entire lot.

                         MACRECPOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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