Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIPMT


                              ARIPMT FILE

This AR Interface Payment file contains interface payment records from an
external source. The record format facilitates a non-bank format. The records
from this file will be interfaced using AR575 (Payment 1 Interface). Records
in this file can be maintained in AR97.3 (Interface Payment 1) to comply with
edit requirements of AR575.

UPDATED BY

AR575     AR97.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ART-COMPANY            Numeric 4                                 AR575   AR97.6
Element: Company       The number representing an AR company.

ART-BATCH-NBR          Numeric 6                                 AR97.6
Element: Batch Nbr     This identifies the batch the entered
                       payments are a part of.

ART-PAYMENT-SEQ        Numeric 6                                 AR97.6
Element: Seq Number    Payment Sequence. This sequence number
                       is used for record uniqueness of a
                       payment.

ART-REMIT-SEQ          Numeric 7                                 AR97.6
Element: Remit Seq     Remit Sequence. This sequence number
                       is used for record uniqueness of a
                       payment remittance record.

ART-LOCK-BOX           Alpha 2                                   AR97.6
Element: Lock Box

ART-PROCESS-LEVEL      Alpha 5                                   AR97.6
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

ART-CASH-CODE          Alpha 4                                   AR97.6
Element: Cash Code     A cash code represents a bank account.
                       More than one company can use the same
                       cash code.  The cash code must be linked
                       to a bank in the Lawson Cash Ledger
                       system.


ART-CURRENCY-CD        Alpha 5                                   AR97.6
Element: Currency Code The currency code of the batch.

ART-ORIG-RATE          Signed 14.7                               AR97.6
Element: Orig Rate     The currency exchange rate from payment
                       currency to company base currency.

ART-DEPOSIT-DATE       Numeric 8  (yyyymmdd)                     AR97.6
Element: Deposit Date  The deposit date of the batch.

ART-GL-DATE            Numeric 8  (yyyymmdd)                     AR97.6
Element: Gl Date       This field contains the general ledger
                       posting date.

ART-CUSTOMER           Alpha 9  (Right Justified)                AR575   AR97.6
Element: Customer      This field contains the number that
                       represents a customer.

ART-BANK-ENTITY        Alpha 15                                  AR97.6
Element: Bank Entity   Represents a bank institution location.

ART-BANK-ACCT-NBR      Alpha 35                                  AR97.6
Element: Bank Acct Nbr The bank-assigned account number
                       identification for the payment.

ART-EDI-NBR            Alpha 15                                  AR97.6
Element: Edi Nbr       The customer EDI number identifing a
                       customer.

ART-TRANS-NBR          Alpha 10  (Right Justified)               AR97.6
Element: Trans Nbr     A unique, user-defined value used to
                       identify the transaction.


ART-TRAN-AMT           Signed 18.2                               AR97.6
Element: Intl Amt      The payment amount.

ART-REMIT-TYPE         Alpha 1                                   AR97.6
Element: Remit Type    This field contains remittance type.
                       Valid values are:

                       C = Credit Memo
                       I = Invoice / Debit Memo
                       D = Debit Memo indicator

ART-TRANS-REM-NBR      Alpha 22                                  AR97.6
Element: Trans Rem Nbr The remittance number that relates to
                       the remittance type.

ART-APPLD-AMT          Signed 18.2                               AR97.6
Element: Intl Amt      The amount of the payment to be applied
                       to the specified remittance transaction.

ART-USR-FLD-01         Alpha 20                                  AR97.6
Element: Usr Fld 01    Payment user field 1.

ART-USR-FLD-02         Alpha 20                                  AR97.6
Element: Usr Fld 02    Payment user field 2.

ART-USR-FLD-03         Alpha 20                                  AR97.6
Element: Usr Fld 03    Payment user field 3.

ART-USR-FLD-04         Alpha 20                                  AR97.6
Element: Usr Fld 04    Payment user field 4.

ART-USR-FLD-05         Alpha 20                                  AR97.6
Element: Usr Fld 05    Payment user field 5.

ART-RIBKEY             Numeric 2
Element: Ribkey        The bank account Ribkey value.

ART-VBANK-IDENT        Alpha 1
Element: Alphadata1

ART-ACTIVITY           Alpha 15                                  AR575   AR97.6
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.


ART-ACTIVITY-GRP       Alpha 15                                  AR575   AR97.6
Element: Activity Grp  The activity group is the overall
                       project.

ART-CONTRACT           Alpha 15                                  AR575   AR97.6
Element: Contract      Activity Management contract.

                         ARIPMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARTSET1   COMPANY                                                AR575   AR97.6
          BATCH-NBR
          PAYMENT-SEQ
          REMIT-SEQ

ARTSET2   COMPANY       Subset                                   AR575
          BATCH-NBR     Where PAYMENT-SEQ != Zeroes
          PAYMENT-SEQ   And   REMIT-SEQ   =  Zeroes

ARTSET3   COMPANY       Subset                                   AR575   AR97.6
          BATCH-NBR     Where PAYMENT-SEQ = Zeroes
                        And   REMIT-SEQ   = Zeroes

ARTSET4   BATCH-NBR     Subset                                   AR575
          COMPANY       Where PAYMENT-SEQ = Zeroes
                        And   REMIT-SEQ   = Zeroes