Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACINVDTL


                             MACINVDTL FILE

                      Invoice Conversion/Interface

The Invoice Conversion/Interface file contains invoice detail information
that has been interfaced or converted from an external source.

UPDATED BY

MA54.1    MA54.3    MA540

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MOP-COMPANY            Numeric 4                                 MA54.3  MA540
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.

MOP-VENDOR             Alpha 9  (Right Justified)                MA54.3  MA540
Element: Vendor ID     The vendor's identification code.



MOP-EDI-NBR            Alpha 15                                  MA54.3  MA540
Element: EDI Number    The electronic data interchange (EDI)
                       number assigned to the vendor.

MOP-INVOICE            Alpha 22                                  MA54.3  MA540
Element: Invoice NumberUsed to identify the invoice.

MOP-SUFFIX             Numeric 3                                 MA54.3  MA540
Element: Invoice SuffixThis is the suffix for the invoice.

MOP-SEQ-NBR            Numeric 4                                 MA54.3  MA540
Element: Sequence NumbeAn automatically assigned sequence
                       number.

MOP-LINE-NBR           Numeric 6                                 MA54.3  MA540
Element: Line Number   This field contains the line number of
                       the purchase order.

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

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

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

MOP-ITEM               Alpha 32                                  MA54.3  MA540
Element: Item Number   This field contains the item
                       identifier.

MOP-VEN-ITEM           Alpha 32                                  MA54.3  MA540
Element: Item Number   The vendor's item identifer.

MOP-ENTERED-QTY        Signed 13.4                               MA54.3  MA540
Element: Quantity      Required. The quantity of goods being
                       invoiced on the detail line.

MOP-ENT-UOM            Alpha 4                                   MA54.3  MA540
Element: Unit of MeasurThe unit of measure the Entered
                       Quantity is expressed in. If left blank,
                       the unit of measure will default from
                       the item/vendor definition, if it
                       exists. If no item/vendor definition
                       exists, the default vendor buy unit of
                       measure will be used.

                       The unit of measure must be valid for
                       the item.

MOP-UNIT-COST          Signed 18.5                               MA54.3  MA540
Element: Intl Cost     Required. The unit cost of the line
                       item detail.

MOP-EXTENDED-AMT       Signed 18.2                               MA540
Element: Extended AmounThe total value of all the items
                       received on a given receiver.

MOP-LOCATION           Alpha 5                                   MA54.3  MA540
Element: Location Code This field contains a valid stocking
                       location within the company inventory
                       system. Must be equal to the invoice
                       company location.

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

MOP-TOTAL-AOC          Signed 18.2                               MA540
Element: Intl Amt      The total add on cost amount. Required
                       if an AOC code is defined.

MOP-RTL-UNIT-COST      Signed 18.5                               MA54.3  MA540
Element: Retail Unit CoThe retail unit cost of the line item
                       detail.

MOP-ELEMENT-VAL        Alpha 32 Occurs 10 Times                  MA54.3  MA540
Element: Element Value

MOP-DIST-COMPANY       Numeric 4                                 MA54.3  MA540
Element: Company       The company number used for posting the
                       transaction. A valid intercompany
                       relationship must be defined in the
                       Lawson General Ledger system.

MOP-ACCT-UNIT          Alpha 15                                  MA54.3  MA540
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.


MOP-ACCOUNT            Numeric 6                                 MA54.3  MA540
Element: Account       This field along with the accounting
                       unit and subaccount make up the location
                       (account) where amounts and other
                       account information is stored.

MOP-SUB-ACCT           Numeric 4                                 MA54.3  MA540
Element: Subaccount    This field contains the subaccount from
                       your general ledger chart of accounts
                       that was charged with the amount carried
                       on this record.

MOP-ACTIVITY           Alpha 15                                  MA54.3  MA540
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


MOP-ACCT-CATEGORY      Alpha 5                                   MA54.3  MA540
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

MOP-BILL-CATEGORY      Alpha 32                                  MA54.3  MA540
Element: Bill Category

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


MOP-NO-TAX-FLAG        Alpha 1                                   MA54.3  MA540
Element: Account Flag  N = No
                       Y = Yes

MOP-TAX-USAGE-CD       Alpha 10                                  MA54.3  MA540
Element: Tax Usage Cd  The tax usage coe for the vendor.  This
                       filed is required if the AP Company
                       inidcates that VAT reporting required.

MOP-ICN-CODE           Alpha 8                                   MA54.3  MA540
Element: Icn Code

MOP-SUPLMNTARY-QTY     Signed 13.4                               MA54.3  MA540
Element: Quantity

MOP-WEIGHT             Signed 9.3                                MA54.3  MA540
Element: Unit Weight   This field contains the unit weight of
                       the item based on the stocking UOM.

MOP-SEGMENT-BLOCK      Alpha 103                                 MA54.3  MA540
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.

MOP-PREPAY-QTY         Signed 13.4
Element: Prepay Qty

MOP-PRPY-UNIT-CST      Signed 18.5
Element: Intl Cost

MOP-PRPY-TAX-CODE      Alpha 10
Element: Prpy Tax Code

MOP-PRPY-TAX-AMT       Signed 18.2
Element: Intl Amt

MOP-PRPY-RTL-UCST      Signed 18.5
Element: Intl Cost

MOP-PREPAY-DATE        Numeric 8  (yyyymmdd)
Element: Prepay Date

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

MOP-CATCH-WGT-COST     Signed 18.5
Element: Intl Cost

                         MACINVDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MOPSET1   COMPANY                                                MA54.1  MA54.3
          VENDOR                                                 MA540
          EDI-NBR
          INVOICE
          SUFFIX
          SEQ-NBR