Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACRECAOC


                             MACRECAOC FILE

UPDATED BY

MA53.1    MA53.6    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRA-COMPANY            Numeric 4                                 MA53.1  MA53.6
Element: Company       Identifies the AP company if the          MA531
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

MRA-REFERENCE-NO       Alpha 10  (Right Justified)               MA53.1  MA53.6
Element: Reference No                                            MA531

MRA-VENDOR             Alpha 9  (Right Justified)                MA53.1  MA53.6
Element: Vendor        The vendor's identification code.



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

MRA-AOC-CODE           Alpha 2                                   MA53.1  MA53.6
Element: Aoc Code      This field contains the identifier for    MA531
                       the add on cost associated with this
                       line item.

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

MRA-REC-TYPE           Alpha 1
Element: Rec Type      The file record type.

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

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

MRA-PO-CODE            Alpha 4
Element: Po Code       This is the purchase order code.

MRA-PURCH-FR-LOC       Alpha 4
Element: Purch Fr Loc  The vendor's purchase from location.

MRA-LOCATION           Alpha 5
Element: Location      This field contains a valid stocking
                       location within the company inventory.

MRA-AOC-RATE           Percent 7.3  (Percent)
Element: Aoc Rate      Add On Cost Percentage Rate. If add on
                       cost is spread by rate, this value times
                       the line unit cost is the unit add on
                       cost for the PO line.

MRA-ENTRY              Alpha 1
Element: Entry         Amount Entry Method.

MRA-QUANTITY           Signed 13.4                               MA53.6
Element: Quantity      This field contains the desired
                       quantity.

MRA-ENT-UNIT-CST       Signed 18.5
Element: Intl Cost

MRA-TOTAL-AOC          Signed 18.2                               MA53.1  MA53.6
Element: Intl Amt                                                MA531

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


MRA-TAXABLE-FLAG       Alpha 1
Element: Taxable Flag  Defines if Taxable.

MRA-AOC-ON-PO          Alpha 1
Element: Aoc On Po     Indicates if the add-on cost is to
                       appear on the Purchase Order document
                       that is issued to the vendor.

MRA-SUMMARY-FLAG       Alpha 1
Element: Summary Flag  Defines if add on cost is printed in
                       summary or at a detail level on the
                       Lawson Purchase Order document.

MRA-ZERO-COST-FLG      Alpha 1
Element: Zero Cost Flg Defines if this tax record is allowed
                       to have a  zero unit cost.

MRA-CLOSED-FL          Alpha 1
Element: Closed Fl     The Closed Flag.

MRA-ELEMENT-01         Alpha 32
Element: Element 01

MRA-ELEMENT-02         Alpha 32
Element: Element 01

MRA-ELEMENT-03         Alpha 32
Element: Element 01

MRA-ELEMENT-04         Alpha 32
Element: Element 01

MRA-ELEMENT-05         Alpha 32
Element: Element 01

MRA-ELEMENT-06         Alpha 32
Element: Element 01

MRA-ELEMENT-07         Alpha 32
Element: Element 01

MRA-ELEMENT-08         Alpha 32
Element: Element 01

MRA-ELEMENT-09         Alpha 32
Element: Element 01

MRA-ELEMENT-10         Alpha 32
Element: Element 01

MRA-LANDED-FLAG        Numeric 1
Element: Landed Flag

MRA-FREIGHT-TERMS      Alpha 1
Element: Freight Terms Freight terms are used to define who
                       pays for freight costs incurred when
                       goods are shipped. Prepaid, for
                       instance, would normally mean that the
                       vendor would pay for freight. Collect
                       would mean the customer would pay for
                       freight.

                       A freight terms code can be entered on
                       a purchase order, or defaulted by vendor
                       or company.

MRA-VENDOR-GROUP       Alpha 4
Element: Vendor Group  A vendor group represents a group of
                       vendors that can be shared by one or
                       more companies.

MRA-XREF-VENDOR        Alpha 9  (Right Justified)
Element: Xref Vendor   This is a vendor that is supported on a
                       system outside Lawson.  When records are
                       interfaces we will maintain this vendor
                       on the file but we will use the Lawson
                       vendor while in the lawson application.

MRA-MATCH-REF-NBR      Alpha 22
Element: Match Ref Nbr

MRA-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

MRA-REC-CNV-RATE       Signed 14.7
Element: Ent Cnv Rate  Currency conversion rate at Purchase
                       Order entry time.

                         MACRECAOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MRASET1   COMPANY                                                MA53.1  MA53.6
          REFERENCE-NO                                           MA531
          LINE-NBR
          AOC-CODE
          SEQ-NBR