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    MA531

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MRA-COMPANY            Numeric 4                                 MA53.1  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.

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

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



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

MRA-AOC-CODE           Alpha 2                                   MA53.1  MA531
Element: Add On Cost CoThis field contains the identifier for
                       the add on cost associated with this
                       line item.

MRA-REC-TYPE           Alpha 1
Element: Record 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 NumUsed 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
Purchase From          The vendor's purchase from location.
Location Code

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

MRA-AOC-RATE           Percent 7.3  (Percent)
Element: Add On Cost RaAdd 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
Element: Quantity      This field contains the desired
                       quantity.

MRA-ENT-UNIT-CST       Signed 18.5
Element: Intl Cost     The entered unit cost.

MRA-TOTAL-AOC          Signed 18.2                               MA53.1  MA531
Element: Intl Amt      The total add on cost amount can be an
                       entered amount if  entered at this
                       level, or a calculated  amount if a unit
                       add on cost or add on  cost percent is
                       entered.

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
Taxable or             Defines if Taxable.
Non-Taxable Flag

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 FlagDefines if this tax record is allowed
                       to have a  zero unit cost.

MRA-CLOSED-FL          Alpha 1
Element: Closed Flag   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-FL          Alpha 1
Element: Landed Fl     This flag will denote if the AOC of
                       record is landed or not landed.  Landed
                       means the AOC takes on the
                       characteristics of the goods it is
                       landed to.

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

                         MACRECAOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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