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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

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

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

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

MRP-SERIAL           Alpha 16                                    MA53.5
Serial Number

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

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

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

MRP-SECONDARY-QTY    Signed 13.4                                 MA53.5
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
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
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
          REFERENCE-NO
          LINE-NBR
          SEQ

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