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                                MA531
Element: Doc Nbr Num

MRJ-DOC-TYPE           Alpha 2                                   MA53.2  MA531
Element: Document 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
Element: Reference No

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

MRJ-REC-NUMBER         Numeric 10                                MA531
Element: Receiver NumbeThe 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 NumUsed 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                                   MA531
Element: Location Code 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 Number   The vendor's item identifer.

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 Code

MRJ-TRANS-DATE         Numeric 8  (yyyymmdd)                     MA531
Element: Transaction DaThe date of the transaction.

MRJ-ADJ-QTY            Signed 13.4                               MA53.2  MA531
Element: Quantity

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

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

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

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

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                                 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      The entered line quantity system
                       converted to vendor pricing terms.

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

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

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

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

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


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: Subaccount    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: 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.

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  MA531
          REC-REF-NBR
          DOC-TYPE
          LINE-NBR

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