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.7    MA53.1    MA53.2    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRP-COMPANY            Numeric 4                                 MA53.5  MA53.7
Element: Company       Identifies the AP company if the          MA531
                       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  MA53.7
Element: Reference No                                            MA531

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

MRP-SEQ                Numeric 3                                 MA53.5  MA53.7
Element: Seq           This field contains the record sequence   MA531
                       number.

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

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

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

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

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

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

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

MRP-SECONDARY-QTY      Signed 13.4                               MA53.5  MA53.7
Element: Secondary Qty This field contains the secondary         MA531
                       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  MA53.7
Element: Hold Flag     This field enables this entire lot to     MA531
                       be put on hold, not allowing any issues
                       or transfers to be made for this lot.

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

                         MACRECPOT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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