Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ARIPMT FILE

UPDATED BY

AR575     AR97.6

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ART-COMPANY          Numeric 4                                   AR97.6
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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


ART-PAYMENT-SEQ      Numeric 6                                   AR97.6
Payment Seq          Payment Sequence. This is the generated
                     sequence number to separate individual
                     invoice payment requirements.


ART-REMIT-SEQ        Numeric 5                                   AR97.6
Remit Seq

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

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


ART-CASH-CODE        Alpha 4                                     AR97.6
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
Currency Code

ART-ORIG-RATE        Signed 12.6                                 AR97.6
Orig Rate

ART-DEPOSIT-DATE     Numeric 8  (yyyymmdd)                       AR97.6
Deposit Date

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

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

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


ART-BANK-ACCT-NBR    Alpha 17                                    AR97.6
Bank Account Number  The bank-assigned account number
                     identification to be used for the cash
                     code.


ART-EDI-NBR          Alpha 15                                    AR97.6
EDI Number

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


ART-TRAN-AMT         Signed 15.2                                 AR97.6
Transaction Amount

ART-REMIT-TYPE       Alpha 1                                     AR97.6
Remittance Type      This field contains remittance type.

ART-TRANS-REM-NBR    Alpha 22                                    AR97.6
Trans Rem Nbr

ART-APPLD-AMT        Signed 15.2                                 AR97.6
Applied Amount

ART-USR-FLD-01       Alpha 20                                    AR97.6
Usr Fld 01

ART-USR-FLD-02       Alpha 20                                    AR97.6
Usr Fld 02

ART-USR-FLD-03       Alpha 20                                    AR97.6
Usr Fld 03

ART-USR-FLD-04       Alpha 20                                    AR97.6
Usr Fld 04

ART-USR-FLD-05       Alpha 20                                    AR97.6
Usr Fld 05

                         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     This index was created as a solution to  AR575
          COMPANY       the Find Nex/Prev Flag error. It is only
                        used where a modify must be done within
                        a 850-FIND-NLT or 850-FIND-BEGRNG loop.
                        Subset
                        Where PAYMENT-SEQ = Zeroes
                        And   REMIT-SEQ   = Zeroes