Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MACINVOICE


                            MACINVOICE FILE

                      Invoice Conversion/Interface

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

UPDATED BY

MA54.1    MA54.2    MA540

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MAI-RUN-GROUP          Alpha 15                                  MA54.1  MA540
Element: Run Group     Run group is used to group records so
                       that data for multiple companies can be
                       processed.

                       Note: Either the run group or the
                       company is required.

MAI-COMPANY            Numeric 4                                 MA54.1  MA540
Element: Company       Required. The company number.

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

                       Note: Either the vendor ID or the EDI
                       number is required.

MAI-EDI-NBR            Alpha 15                                  MA54.1  MA540
Element: Edi Nbr       The electronic data interchange (EDI)
                       number assigned to the vendor.
                       Used to retrieve the vendor ID.

                       Note: Either the EDI number or the
                       vendor ID is required.

MAI-INVOICE            Alpha 22                                  MA54.1  MA540
Element: Invoice       Required. Used to identify the invoice.

MAI-SUFFIX             Numeric 3                                 MA54.1  MA540
Element: Suffix        This is the suffix for the invoice.
                       Zeroes will be entered.

MAI-BATCH-NUM          Numeric 6                                 MA54.1  MA540
Element: Batch Nbr     This identifies the batch the entered
                       invoices, debit memos, and credit memos
                       are a part of.

MAI-VOUCHER-NBR        Alpha 10                                  MA54.1  MA540
Element: Voucher Nbr   The voucher number assigned to the
                       invoice. Used only if the company has
                       Yes selected in the Invoice Registration
                       Option field.

MAI-AUTH-CODE          Alpha 3                                   MA54.1  MA540
Element: Auth Code     A user-defined code representing a
                       person or department responsible for
                       approving a registered invoice.

MAI-PROC-LEVEL         Alpha 5                                   MA54.1  MA540
Element: Process Level The process level represents a
                       reporting level below company. If left
                       blank, the AP default process level will
                       default. If there is no AP default
                       process level defined, this field is
                       required.

MAI-INVOICE-TYPE       Alpha 1                                   MA54.1  MA540
Element: Invoice Type  Identifies the type of invoice. Valid
                       values are:
                       " " = Invoice
                       D = Debit Memo
                       C = Credit Memo

MAI-INV-CURRENCY       Alpha 5                                   MA54.1  MA540
Element: To Base Curr  The currency of the invoice. Must be a
                       valid record in the Currency Code file.
                       If left blank, the vendor currency
                       defaults.

MAI-INVOICE-DTE        Numeric 8  (yyyymmdd)                     MA54.1  MA540
Element: Invoice Dte   Required. The date assigned to the
                       invoice. Used when updating the vendor's
                       purchase  balance.

MAI-DISTRIB-DATE       Numeric 8  (yyyymmdd)                     MA54.1  MA540
Element: Date          This field displays the system date
                       when this was created.

MAI-PURCH-FR-LOC       Alpha 4                                   MA54.1  MA540
Element: Purch Fr Loc  The vendor's purchase from location.

MAI-PO-CODE            Alpha 4                                   MA54.1  MA540
Element: Purchase OrderPurchase order number code. Used to
                       keep purchase orders unique. Can be used
                       for reporting purposes.

MAI-PO-NUMBER          Alpha 14  (Right Justified)               MA54.1  MA540
Element: Po Number     This field contains the number
                       representing the purchase order. This
                       field is required if the PO Required
                       flag is set to "Yes" on the assigned
                       invoice handling code.

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

MAI-DESCRIPTION        Alpha 30  (Lower Case)                    MA54.1  MA540
Element: Description   This field displays the description.

MAI-TRAN-INV-AMT       Signed 18.2                               MA54.1  MA540
Element: Intl Amt      The amount of the invoice in the
                       currency of the invoice.

MAI-TRAN-ALOW-AMT      Signed 18.2                               MA54.1  MA540
Element: Intl Amt      The amount of the invoice available for
                       discount in the currency of the invoice.
                       If left blank, the Invoice Amount
                       defaults.

MAI-TRAN-TXBL-AMT      Signed 18.2                               MA54.1  MA540
Element: Intl Amt      The taxable amount of the invoice in
                       the currency of the invoice.

MAI-TRAN-TAX-AMT       Signed 18.2                               MA54.1  MA540
Element: Intl Amt

MAI-TRAN-DISC-AMT      Signed 18.2                               MA54.1  MA540
Element: Intl Amt      The discount amount of the invoice in
                       the currency of the invoice. If left
                       blank, the terms code assigned to the
                       invoice, alternate location (type P or
                       B), or vendor, if assigned, will be used
                       to calculate the discount amount.

MAI-ORIG-CNV-RATE      Signed 14.7                               MA54.1  MA540
Element: Acct Rate

MAI-DISCOUNT-RT        Percent 5.3  (Percent)                    MA54.1  MA540
Element: Discount Rt   The rate used to calculate the discount
                       amount of the invoice. If left blank,
                       the terms code assigned to the invoice,
                       alternate location (type P or B),
                       vendor, or vendor class, if assigned,
                       will be used to calculate due date and
                       discount information.

MAI-DISC-DATE          Numeric 8  (yyyymmdd)                     MA54.1  MA540
Element: Date          The discount date assigned to the
                       invoice. Used by Cash Requirements
                       (AP150) to determine whether a discount
                       will be taken on the invoice. If left
                       blank, the terms code assigned to the
                       invoice, alternate location (type P or
                       B), or vendor, if assigned, will be used
                       to calculate due date and discount
                       information.

MAI-DUE-DATE           Numeric 8  (yyyymmdd)                     MA54.1  MA540
Element: Due Date      The transaction due date.

MAI-REMIT-TO-CODE      Alpha 4                                   MA54.1  MA540
Element: Remit To Code A user-defined code that represents a
                       vendor's remittance address.

MAI-RETAIL-AMT         Signed 18.2                               MA54.1  MA540
Element: Retail Amount The retail amount of the invoice.

MAI-RCPT-INV-DATE      Numeric 8  (yyyymmdd)                     MA54.1  MA540
Element: Invoice ReceipThe date the invoice was received.

MAI-REASON-CODE        Alpha 4                                   MA54.1  MA540
Element: Reason Code   This field contains the reason code,
                       which indicates the cause for credit
                       memos.

MAI-MATCH-REF-NBR      Alpha 22                                  MA54.1  MA540
Matching Reference     Matching reference number.
Number

MAI-HANDLING-CODE      Alpha 4                                   MA54.1  MA540
Element: Handling Code Invoice handling code. The invoice
                       handling code contains processing rules
                       for invoice matching.

MAI-OPERATOR           Alpha 10                                  MA54.1  MA540
Element: Operator      This field is used to store the login
                       id of the person who entered the record.


MAI-TERM-CODE          Alpha 5                                   MA54.1  MA540
Element: Term Code     A user-defined code representing a
                       method of determining invoice due and
                       discount dates.

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


MAI-TAX-CODE-CNTL      Alpha 1                                   MA54.1  MA540
Element: Tax Code Cntl This control field defines the tax code
                       usage in invoicing and approving taxes.

                       For PO Invoices, if set to O (Override)
                       all lines approved for payment will use
                       the tax code defined for the whole
                       invoice.

                       If set to I (Ignore) no PO lines
                       approved for payment will be taxed.
                       1 = Override
                       2 = Ignore
                       3 = Calculate
                       4 = Override Product and AOC
                       5 = Ignore product and AOC
                       6 = Ignore tax tol ovr goods tax
                       7 = Ignore tax tol ovr goods/aoc t

MAI-LOCATION           Alpha 5                                   MA54.1  MA540
Element: Location      This field contains a valid stocking
                       location within the company inventory
                       system.

                       Note: Required if pool option for
                       vendor/company = 3.

MAI-RECORD-ERROR       Alpha 1                                   MA54.1  MA540
Element: Record Error  Indicates if an error was found during
                       interface or conversion, and if the
                       error has been corrected.

                       Valid values are:

                       Y = Error found
                       N = No error found or error corrected

MAI-CBPRINT-FL         Alpha 1                                   MA54.1  MA540
Element: Print ChargebaPrint chargebacks flag. Indicates
                       whether to generate chargebacks.
                       N = No
                       Y = Yes

MAI-INVC-REF-TYPE      Alpha 2                                   MA54.1
Element: Invc Ref Type Indicates the type of number the vendor
                       is providing to reference the invoice.

MAI-INV-USR-FLD-01     Alpha 20                                  MA54.1  MA540
Element: Invoice User FInvoice user-defined field number 1.

MAI-INV-USR-FLD-02     Alpha 20                                  MA54.1  MA540
Element: Invoice User FInvoice user-defined field number 2.

MAI-INV-USR-FLD-03     Alpha 20                                  MA54.1  MA540
Element: Invoice User FInvoice user-defined field number 3.

MAI-INV-USR-FLD-04     Alpha 20                                  MA54.1  MA540
Element: Invoice User FInvoice user-defined field number 4.

MAI-INV-USR-FLD-05     Alpha 20                                  MA54.1  MA540
Element: Invoice User FInvoice user-defined field number 5.

MAI-RETURN-NUMBER      Numeric 10                                MA54.1  MA540
Element: Return Number This is the number assigned to the
                       return for purposes of referencing the
                       return internally and with the customer
                       or vendor.

MAI-JRNL-BOOK-NBR      Alpha 12                                  MA54.1
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

MAI-SEGMENT-BLOCK      Alpha 103                                 MA54.1  MA540
Element: Segment Block 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.

MAI-NOTC               Alpha 2                                   MA54.1  MA540
Element: Notc          The Nature of Transaction code.  Must
                       be a valid code defined in IN07.1 (NOTC
                       Maintenance).

MAI-STAT-PROC          Alpha 6                                   MA54.1  MA540
Element: Stat Proc     The statistical procedure code applied
                       to the data.  The code must be defined
                       in IN06.1. (Statistical Procedure
                       Maintenance).

MAI-SHIP-VIA           Alpha 12  (Lower Case)                    MA54.1  MA540
Element: Ship Via

MAI-UNLOADING-PORT     Alpha 5                                   MA54.1  MA540
Element: Unloading PortThe prot where the goods are unloaded if
                       required.  Must be defined in IN04.1
                       (Port Maintenance)

MAI-INTRASTAT-NBR      Numeric 12
Element: Intrastat Nbr The number assigned by the Intrastat
                       system to a transaction that involves
                       Intrastat reporting after it has been
                       added.

MAI-DROPSHIP-FL        Alpha 1                                   MA54.1  MA540
Element: Dropship Fl   This flag indicates whether goods being
                       shipped by the vendor directly to a non
                       standard location need to have the
                       receiving process performed.

MAI-FOB-CODE           Alpha 3                                   MA54.1  MA540
Element: Fob Code      The user defined Free On Board Code.

MAI-PAY-IMM-FLAG       Alpha 1                                   MA54.1  MA540
Element: All Flag

MAI-DIVERSE-CODE       Alpha 5                                   MA54.1  MA540
Element: Diverse Code  Diversity Code for Account Payable
                       Vendors

MAI-MTCH-PREPAY-FL     Alpha 1                                   MA54.1
Element: Mtch Prepay FlFlag that notes if the invoice will be
                       prepaid.  This is for match invoices.

MAI-MTCH-PREPAY-MT     Numeric 1                                 MA54.1
Element: Mtch Prepay MtFlag denotes the method of match
                       prepayment.
                       0 = NO
                       1 = prepay from Invoice
                       2 = Eligible for Prepayment

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

MAI-PRPY-DISC-CODE     Alpha 10
Element: Prpy Disc Code

MAI-PRPY-REF-NBR       Alpha 22
Element: Prpy Ref Nbr

MAI-PRPY-RTL-AMT       Signed 18.2
Element: Intl Amt

MAI-PRPY-AMT           Signed 18.2
Element: Intl Amt

MAI-PRPY-AOC-AMT       Signed 18.2
Element: Intl Amt

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

MAI-PRPY-SERV-AMT      Signed 18.2
Element: Intl Amt

MAI-FLEX-FLAG          Alpha 1                                   MA54.1
Element: Flex Flag     Notes terms has been overriden

MAI-RULE-GROUP         Alpha 10                                  MA54.1  MA540
Element: Match Rule

                         MACINVOICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MAISET1   COMPANY                                                MA54.1  MA54.2
          VENDOR                                                 MA54.3  MA54.8
          EDI-NBR                                                MA540
          INVOICE
          SUFFIX

MAISET2   RUN-GROUP     KeyChange                                MA54.1  MA540
          RECORD-ERROR
          COMPANY
          VENDOR
          EDI-NBR
          INVOICE
          SUFFIX

MAISET4   RUN-GROUP     KeyChange                                MA540
          COMPANY
          VENDOR
          EDI-NBR
          INVOICE
          SUFFIX

                         MACINVOICE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Macinverr      MACINVERR

                            MAI-COMPANY    -> MCI-COMPANY
                            MAI-VENDOR     -> MCI-VENDOR
                            MAI-EDI-NBR    -> MCI-EDI-NBR
                            MAI-INVOICE    -> MCI-INVOICE
                            MAI-SUFFIX     -> MCI-SUFFIX
                                              MCI-DIST-SEQ
                                              MCI-RECORD-TYPE
                                              MCI-SEQ-NBR