Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MACRECADJ FILE

UPDATED BY

MA53.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

MRJ-REC-REF-NBR      Alpha 10  (Right Justified)
Rec Ref Nbr

MRJ-ADJ-REF-NBR      Alpha 10  (Right Justified)
Adj Ref Nbr

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

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

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

MRJ-ORIG-REF-NO      Alpha 10  (Right Justified)                 MA53.2
Orig Ref No

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

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

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

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

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

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

MRJ-ELEMENT-02       Alpha 32                                    MA53.2
Element 02

MRJ-ELEMENT-03       Alpha 32                                    MA53.2
Element 03

MRJ-ELEMENT-04       Alpha 32                                    MA53.2
Element 04

MRJ-ELEMENT-05       Alpha 32                                    MA53.2
Element 05

MRJ-ELEMENT-06       Alpha 32                                    MA53.2
Element 06

MRJ-ELEMENT-07       Alpha 32                                    MA53.2
Element 07

MRJ-ELEMENT-08       Alpha 32                                    MA53.2
Element 08

MRJ-ELEMENT-09       Alpha 32                                    MA53.2
Element 09

MRJ-ELEMENT-10       Alpha 32                                    MA53.2
Element 10

MRJ-VEN-ITEM         Alpha 32                                    MA53.2
Vendor Item          The vendor's item identifer.

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

MRJ-OPER-ID          Alpha 10
Operator
Identification

MRJ-TRANS-DATE       Numeric 8  (yyyymmdd)
Transaction Date     The date of the transaction.

MRJ-ADJ-QTY          Signed 13.4                                 MA53.2
Adj Qty

MRJ-ORIG-UNIT-CST    Signed 13.5                                 MA53.2
Orig Unit Cst

MRJ-ENT-REC-UOM      Alpha 4                                     MA53.2
Entered Received UOM Entered valid receipt unit of measure.

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

MRJ-CATCH-WT-QTY     Signed 13.4
Catch Weight         This field contains the quantity
Quantity             received for catch weight shipments.

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

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

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

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

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

MRJ-ACTUAL-TIME      Numeric 4
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
New Element 01

MRJ-NEW-ELEMENT-02   Alpha 32                                    MA53.2
New Element 02

MRJ-NEW-ELEMENT-03   Alpha 32                                    MA53.2
New Element 03

MRJ-NEW-ELEMENT-04   Alpha 32                                    MA53.2
New Element 04

MRJ-NEW-ELEMENT-05   Alpha 32                                    MA53.2
New Element 05

MRJ-NEW-ELEMENT-06   Alpha 32                                    MA53.2
New Element 06

MRJ-NEW-ELEMENT-07   Alpha 32                                    MA53.2
New Element 07

MRJ-NEW-ELEMENT-08   Alpha 32                                    MA53.2
New Element 08

MRJ-NEW-ELEMENT-09   Alpha 32                                    MA53.2
New Element 09

MRJ-NEW-ELEMENT-10   Alpha 32                                    MA53.2
New Element 10

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

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

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

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

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

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

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


MRJ-ACCOUNT          Numeric 6                                   MA53.2
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
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
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
Record Error         Y = Yes
                     N = No

                         MACRECADJ FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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