Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            MACRECLINE FILE

UPDATED BY

MA53.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MRL-COMPANY          Numeric 4                                   MA53.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

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

MRL-REC-NUMBER       Numeric 10
Receiver Number      The receiver number.  Assigned when
                     this receiving information was added.

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

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

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

MRL-VEN-ITEM         Alpha 32                                    MA53.1
Vendor Item          The vendor's item identifer.

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

MRL-ENT-REC-QTY      Signed 13.4                                 MA53.1
Entered Received     Entered receipt quantity.
Quantity

MRL-ENT-REC-UOM      Alpha 4                                     MA53.1
Entered Received UOM Entered valid receipt unit of measure.

MRL-ENT-RUOM-MULT    Signed 13.7
Entered Recvd UOM    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
Catch Weight         This field contains the quantity
Quantity             received for catch weight shipments.

MRL-ORIG-UNIT-CST    Signed 13.5                                 MA53.1
Orig Unit Cst

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

MRL-REC-COMMENTS     Alpha 100  (Lower Case)
Receiving Comments

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

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

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

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

MRL-ELEMENT-02       Alpha 32                                    MA53.1
Element 02

MRL-ELEMENT-03       Alpha 32                                    MA53.1
Element 03

MRL-ELEMENT-04       Alpha 32                                    MA53.1
Element 04

MRL-ELEMENT-05       Alpha 32                                    MA53.1
Element 05

MRL-ELEMENT-06       Alpha 32                                    MA53.1
Element 06

MRL-ELEMENT-07       Alpha 32                                    MA53.1
Element 07

MRL-ELEMENT-08       Alpha 32                                    MA53.1
Element 08

MRL-ELEMENT-09       Alpha 32                                    MA53.1
Element 09

MRL-ELEMENT-10       Alpha 32                                    MA53.1
Element 10

MRL-VPRI-QUANTITY    Signed 13.4
Vendor Price         The entered line quantity system
Quantity             converted to vendor pricing terms.

MRL-VPRI-UOM         Alpha 4
Vendor Price Unit    This is the vendor pricing unit of
of Measure           measure.

MRL-VPRI-UOM-MULT    Signed 13.7
Vendor Price UOM     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
Buom Qty

MRL-VBUY-UOM         Alpha 4
Vendor Buy Unit of   The vendor's buying unit of measure.
Measure

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

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

MRL-ACCT-UNIT        Alpha 15                                    MA53.1
Accounting 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
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
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
Tax Usage Cd         The tax usage coe for the vendor.  This
                     filed is required if the AP Company
                     inidcates that VAT reporting required.

MRL-SEGMENT-BLOCK    Alpha 103                                   MA53.1
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
          LINE-NBR