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       The company number represents an          MA531
                       established company and is entered on
                       all function codes.

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 Number   This field contains the line number.      MA531

MRP-SEQ                Numeric 3                                 MA53.5  MA53.7
Element: Sequence NumbeThis 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 Number    This field contains the identifier for    MA531
                       the homogeneous quantity of material.

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

MRP-SERIAL             Alpha 16                                  MA53.5  MA53.7
Element: Serial Number                                           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 Number   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: Quantity                                                MA531

MRP-HOLD-FLAG          Alpha 1                                   MA53.5  MA53.7
Element: On 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: Date                                                    MA531

                         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