Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

AR560

AR560 - Transaction Interface

AR560 (Transaction Interface) processes files containing data that have been
loaded from a source external to the Lawson Accounts Receivable system.
Invoice, debit memo, and credit memo transactions will be processed along with
optional distribution and comment records. The program edits each field and
creates a report of all transactions that fail these edits. The report
includes each record field that failed the edits, an error description
identifying the type of error, and totals for the number of transactions
processed, successfully added, and not processed.


Updated Files

    ACCOMMIT   - Used as part of Activity commitment update.

    ACCOMMITX  - Used as part of Activity commitment update.

    ARAPPLIED  - Applied records created for Bills of Exchange.

    ARCOMMENT  - Open item level comments created.

    ARCOMP     - Validates company.

    ARCUSTOMER - Last invoicing information updated.

    ARCUSTPER  - Customer period amounts updated for transaction activity.

    ARDISTRIB  - Distribution records created for general ledger transactions.

    ARDRAFTS   - Bills of Exchange are created for open items to be applied via
                 this method.


    ARICOMMENT - Deletes interface comment record after like record has been
                 created.


    ARIDISTRIB - Deletes interface distribution record after like record has
                 been created.


    ARIITEM    - Deletes interface line item record after like open item record
                 has been created.


    ARISGBLK   - Updates user analysis information.

    ARITRANS   - Deletes interface open item record after like record has been
                 created.


    AROIHDR    - Creates open item header records for invoices, debit memos,
                 and credit memos.


    AROITEMS   - Creates open item records for invoices, debit memos, and
                 credit memos.


    AROPIVOT   -

    ARPAYMENT  - Updates payment information.

    ARPYMNTHDR - Creates payment header records.

    ARSUMMARY  - Summary records updated with open item activity.

    ARUDISTRIB - Updates user analysis information.

    ARUOIHDR   - Updates user analysis information.

    CBBANKENT  - Used as part of cash ledger validation.

    CBBANKINST - Used as part of payment code validation.

    CBCASHCODE - Used as part of cash code validation.

    CKPOINT    - Used for restart purposes.

    CUSTDESC   - Validates customer description record.

    INSTDETAIL - Maintains Intrastat detail information.

    INSTHEADER - Maintains Intrastat header information.

    INSTNBR    - Keeps track of most recently assigned Intrastat number and
                 assigns the next number to the next transaction that requires
                 Intrastat reporting.

    JBOOKHDR   - Used in journal book processing.

    NATBALANCE - National account balance updated for interfaced open items.

    TERMS      - Used flag updated.

    TXCODEMAST - Validates tax code flag.

    TXCOMPANY  - Validates tax code company.

    TXTAXCODE  - Validates tax codes.

    TXTAXTABLE - Validates tax table transaction records.

    TXTAXTRAN  - Creates tax transaction records for distribution taxable
                 distribution lines.



Referenced Files

    ACACCTCAT  - Used as part of Activity validation.

    ACACTGRP   - Used as part of Activity validation.

    ACACTIVITY - Used as part of Activity validation.

    ACCAL      - Used as part of Activity validation.

    ACCALX     - Used as part of Activity validation.

    APACCRCODE - Used as part of vendor validation.

    APCOMPANY  - Used as part of vendor validation.

    APCPYVND   - Used as part of vendor validation.

    APHLDINV   - Used as part of vendor validation.

    APVENCLASS - Used as part of vendor validation.

    APVENGROUP - Used as part of vendor validation.

    APVENMAST  - Used as part of vendor validation.

    ARADJUST   - Part of edit logic for duplicates.

    ARCODE     - Used to validate general ledger accounts receivable code.

    ARCUSTGRP  - Used to validate customer group.

    ARCUSTTOTS - Used to validate process level inclusions.

    ARPROCLEVL - Used to validate process level.

    BILLTO     - Validates customer bill to address record.

    CBUSER     - Used as part of cash ledger validation.

    CBUSRCLASS - Used as part of cash ledger validation.

    CUCONV     - Used as part of currency validation.

    CURELAT    - Validates currency relationships.

    DTCUSTBANK - Validates Bills of Exchange bank accounts.

    GLADDRESS  - Validates general ledger company information.

    GLCHART    - Used as part of general ledger account validation.

    GLCODES    - Used to validate system control.

    GLINTCO    - Used to validate inter company general ledger relationships.

    GLSYSTEM   - Used as part of general ledger account validation.

    INSTATPROC - Validates Intrastat procedure code.

    INSTCMDTY  - Validates Intrastat commodity code.

    INSTCTRYCD - Validates Intrastat country code.

    INSTNOTC   - Validates Intrastat nature of transaction code.

    INSTPORTS  - Validates Intrastat ports code.

    INSTREGN   - Validates Intrastat region code.

    INSTUOM    - Validates the Intrastat secondary unit of measure.

    JBKOPCODE  - Used in journal book processing.

    JBKSYSCODE - Used in journal book processing.

    NATACCT    - Used to validate national account customer relationship.

    SALESREP   - Used to validate sales representative.

    SYSTEMCODE - Validates the system code updating general ledger and updated
                 the object id.


    TXTAXRATE  - Validates tax rate.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS
    IFSC