Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACRECADJ


                             MACRECADJ FILE

UPDATED BY

MA53.2    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRJ-COMPANY            Numeric 4                                 MA53.2  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.

MRJ-DOC-NBR-NUM        Numeric 10
Element: Doc Nbr Num

MRJ-DOC-TYPE           Alpha 2                                   MA53.2  MA531
Element: Doc Type      This field contains the type of
                       transaction.
                       RA = Receiving Adjustment
                       LO = Line Only Addition

MRJ-REC-REF-NBR        Alpha 10  (Right Justified)               MA53.2  MA531
Element: Reference No

MRJ-ADJ-REF-NBR        Alpha 10  (Right Justified)               MA53.2  MA531
Element: Reference No

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

MRJ-LINE-NBR           Numeric 6                                 MA53.2  MA531
Element: Line Nbr      This field contains the line number.

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

MRJ-ORIG-REF-NO        Alpha 10  (Right Justified)               MA53.2
Element: Reference No

MRJ-PO-NUMBER          Alpha 14  (Right Justified)               MA53.2  MA531
Element: Po Number     This field contains the number
                       representing the purchase order.

MRJ-PO-RELEASE         Numeric 4                                 MA53.2  MA531
Element: Po Release    Used to identify a purchase order
                       release (created from a Blanket or
                       Standing order).

MRJ-PO-CODE            Alpha 4                                   MA53.2  MA531
Element: Po Code       This is the purchase order code.

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

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

MRJ-ELEMENT-01         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-02         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-03         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-04         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-05         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-06         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-07         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-08         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-09         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-ELEMENT-10         Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-VEN-ITEM           Alpha 32                                  MA53.2  MA531
Element: Item          This field contains the item
                       identifier.

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

MRJ-OPER-ID            Alpha 10                                  MA531
Element: Operator      This field is used to store the login
                       id of the person who entered the record.


MRJ-TRANS-DATE         Numeric 8  (yyyymmdd)                     MA53.2  MA531
Element: Trans Date    The date of the transaction.

MRJ-ADJ-QTY            Signed 13.4                               MA53.2  MA531
Element: Quantity      This field contains the desired
                       quantity.

MRJ-ORIG-UNIT-CST      Signed 18.5                               MA53.2  MA531
Element: Intl Cost

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


MRJ-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.

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

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

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

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

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

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

MRJ-ACTUAL-TIME        Numeric 4                                 MA53.2  MA531
Element: Actual Time   This field contains the actual time the
                       receiver was entered into the system.
                       This filed defaults to the system date
                       if an actual time was not entered.

MRJ-NEW-ELEMENT-01     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-02     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-03     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-04     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-05     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-06     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-07     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-08     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-09     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-NEW-ELEMENT-10     Alpha 32                                  MA53.2  MA531
Element: Element 01

MRJ-VPRI-QUANTITY      Signed 13.4                               MA531
Element: Quantity      This field contains the desired
                       quantity.

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


MRJ-VPRI-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.

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


MRJ-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.

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

MRJ-TAX-USAGE-CD       Alpha 10                                  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.

MRJ-ACCT-UNIT          Alpha 15                                  MA53.2  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.


MRJ-ACCOUNT            Numeric 6                                 MA53.2  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.

MRJ-SUB-ACCT           Numeric 4                                 MA53.2  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.

MRJ-SEGMENT-BLOCK      Alpha 103                                 MA53.2  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.

MRJ-RECORD-ERROR       Alpha 1                                   MA53.2  MA531
Element: Record Error  Y = Yes
                       N = No

                         MACRECADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRJSET1   COMPANY                                                MA53.2  MA53.7
          REC-REF-NBR                                            MA531
          DOC-TYPE
          LINE-NBR

MRJSET2   RECORD-ERROR  KeyChange                                MA531
          COMPANY
          REC-REF-NBR
          DOC-TYPE
          LINE-NBR