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

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

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

MRL-ENT-REC-UOM        Alpha 4                                   MA53.1  MA531
Element: Unit of Measure

MRL-ENT-RUOM-MULT      Signed 13.7                               MA531
Unit of Measure
Multiplier

MRL-CATCH-WT-QTY       Signed 13.4                               MA53.1  MA531
Element: Quantity

MRL-ORIG-UNIT-CST      Signed 13.5                               MA53.1  MA531
Element: Base 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

MRL-REC-COMMENTS       Alpha 100  (Lower Case)                   MA53.1
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: Date

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

MRL-VPRI-UOM           Alpha 4                                   MA53.1  MA531
Element: Unit of Measure

MRL-VPRI-UOM-MULT      Signed 13.7                               MA53.1  MA531
Unit of Measure
Multiplier

MRL-BUOM-QTY           Signed 13.4                               MA531
Element: Quantity

MRL-VBUY-UOM           Alpha 4                                   MA531
Element: Unit of Measure

MRL-VBUY-UOM-MULT      Signed 13.7                               MA531
Unit of Measure
Multiplier

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

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.

                         MACRECLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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