Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACRECLINE


                            MACRECLINE FILE

UPDATED BY

MA53.1    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRL-COMPANY            Numeric 4                                 MA53.1  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.

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

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

MRL-REC-NUMBER         Numeric 10                                MA531
Element: Receiver NumbeThe receiver number.  Assigned when
                       this receiving information was added.

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

MRL-DESCRIPTION        Alpha 30  (Lower Case)                    MA53.1  MA531
Element: Description   This field displays the description.

MRL-ITEM-TYPE          Alpha 1                                   MA53.1  MA531
Element: Item Type     This field identifies the line item
                       type.

MRL-VEN-ITEM           Alpha 32                                  MA53.1  MA531
Element: Item Number   The vendor's item identifer.

MRL-LOCATION           Alpha 5                                   MA53.1  MA531
Element: Location Code This field contains a valid stocking
                       location within the company inventory.

MRL-ENT-REC-QTY        Signed 13.4                               MA53.1  MA531
Element: Quantity      Entered receipt quantity.

MRL-ENT-REC-UOM        Alpha 4                                   MA53.1  MA531
Element: Unit of MeasurEntered valid receipt unit of measure.

MRL-ENT-RUOM-MULT      Signed 13.7                               MA531
Unit of Measure        This multiplier is used to convert
Multiplier             entered unit of measure quantity down
                       to stocking unit of measure.

MRL-CATCH-WT-QTY       Signed 13.4                               MA53.1  MA531
Element: Quantity      This field contains the quantity
                       received for catch weight shipments.

MRL-ORIG-UNIT-CST      Signed 18.5                               MA53.1  MA531
Element: Intl Cost

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

MRL-CANCEL-BO-FL       Alpha 1                                   MA53.1
Element: All Flag      This flag indicates whether the
                       backordered quantity is to be cancelled
                       and the line is to be considered closed.


MRL-REC-COMMENTS       Alpha 100  (Lower Case)
Element: Ers Comments

MRL-STATUS             Numeric 1                                 MA53.1  MA531
Element: Status        This field displays the status of the
                       transaction.

MRL-UPDATE-DATE        Numeric 8  (yyyymmdd)                     MA53.1  MA531
Element: Update Date   This field contains the date the record
                       was updated.

MRL-UPDATE-TIME        Numeric 6                                 MA53.1  MA531
Element: Update Time   This field contains the system time
                       when the record was updated.

MRL-ELEMENT-01         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-02         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-03         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-04         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-05         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-06         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-07         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-08         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-09         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-ELEMENT-10         Alpha 32                                  MA53.1  MA531
Element: Element 01

MRL-VPRI-QUANTITY      Signed 13.4                               MA531
Element: Quantity      The entered line quantity system
                       converted to vendor pricing terms.

MRL-VPRI-UOM           Alpha 4                                   MA531
Element: Unit of MeasurThis is the vendor pricing unit of
                       measure.

MRL-VPRI-UOM-MULT      Signed 13.7                               MA531
Unit of Measure        This is the vendor pricing unit of
Multiplier             measure multiplier. It is used to
                       convert unit cost to stock unit of
                       measure terms.

MRL-BUOM-QTY           Signed 13.4                               MA531
Element: Quantity

MRL-VBUY-UOM           Alpha 4                                   MA531
Element: Unit of MeasurThe vendor's buying unit of measure.

MRL-VBUY-UOM-MULT      Signed 13.7                               MA531
Unit of Measure        Vendor Buy Unit Of Measure Multiplier.
Multiplier             Used to convert quantity and unit cost.

MRL-TAX-CODE           Alpha 10                                  MA53.1  MA531
Element: Tax Code      This field contains a code representing
                       specific tax information.  This must be
                       valid Tax Code.


MRL-ACCT-UNIT          Alpha 15                                  MA53.1  MA531
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


MRL-ACCOUNT            Numeric 6                                 MA53.1  MA531
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

MRL-SUB-ACCT           Numeric 4                                 MA53.1  MA531
Element: Subaccount    This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

MRL-TAX-USAGE-CD       Alpha 10                                  MA53.1  MA531
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

MRL-MSDS-FLAG          Alpha 1                                   MA53.1  MA531
Element: All Flag      This flag indicates if this item
                       requires a Material Safety Data Sheet.

MRL-MSDS-VERSION       Alpha 4                                   MA53.1  MA531
Element: Msds Version  The version number of the most recent
                       MSDS that was received.

MRL-MSDS-DOCUMENT      Alpha 30                                  MA53.1  MA531
Element: Msds Document The document number from the most
                       recent MSDS that was received.

MRL-SEGMENT-BLOCK      Alpha 103                                 MA53.1  MA531
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

MRL-CATCH-WGT-COST     Signed 18.5
Element: Intl Cost

MRL-TAX-UNIT-CST       Signed 18.5
Element: Intl Cost

                         MACRECLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRLSET1   COMPANY                                                MA53.1  MA53.5
          REFERENCE-NO                                           MA531
          LINE-NBR