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

MRL-SEQ-NBR            Numeric 4                                 MA53.1
Element: Seq Nbr       An automatically assigned sequence
                       number.

MRL-REC-NUMBER         Numeric 10                                MA531
Element: Rec Number    The receiver number.  Assigned when
                       this receiving information was added.

MRL-ITEM               Alpha 32                                  MA53.1  MA531
Element: Item          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          This field contains the item
                       identifier.

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

MRL-ENT-REC-QTY        Signed 13.4                               MA53.1  MA531
Element: Quantity      This field contains the desired
                       quantity.

MRL-ENT-REC-UOM        Alpha 4                                   MA53.1  MA531
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MRL-ENT-RUOM-MULT      Signed 13.7                               MA531
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

MRL-CATCH-WT-QTY       Signed 13.4                               MA53.1  MA531
Element: Quantity      This field contains the desired
                       quantity.

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

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: 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      This field contains the desired
                       quantity.

MRL-VPRI-UOM           Alpha 4                                   MA53.1  MA531
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MRL-VPRI-UOM-MULT      Signed 13.7                               MA53.1  MA531
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

MRL-BUOM-QTY           Signed 13.4                               MA531
Element: Quantity      This field contains the desired
                       quantity.

MRL-VBUY-UOM           Alpha 4                                   MA531
Element: Uom           This field contains the valid stock
                       unit of measure for this item.


MRL-VBUY-UOM-MULT      Signed 13.7                               MA531
Element: Uom Mult      This field contains the multiplier for
                       converting this unit of measure to the
                       stock unit of measure.

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: Acct Unit     The 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: Sub Acct      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: Segment Block 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

MRL-INSP-REQ-FL        Alpha 1                                   MA53.1
Element: All Flag

MRL-COMMODITY-CODE     Alpha 35                                  MA53.1
Element: Commodity Code

                         MACRECLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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