Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARIPMT


                              ARIPMT FILE

UPDATED BY

AR575     AR97.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ART-COMPANY            Numeric 4                                 AR97.6
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.

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


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


ART-REMIT-SEQ          Numeric 7                                 AR97.6
Element: Remit Seq

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

ART-ORIG-RATE          Signed 14.7                               AR97.6
Element: Orig Rate

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

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

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

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


ART-BANK-ACCT-NBR      Alpha 35                                  AR97.6
Element: Bank Account NThe bank-assigned account number
                       identification to be used for the cash
                       code.


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

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

ART-REMIT-TYPE         Alpha 1                                   AR97.6
Element: Remittance TypThis field contains remittance type.

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

ART-APPLD-AMT          Signed 18.2                               AR97.6
Element: Intl Amt

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

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

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

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

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

ART-RIBKEY             Numeric 2
Element: Ribkey

ART-VBANK-IDENT        Alpha 1
Element: Alphadata1    This field indicates if the account
                       number is an IBAN number that requires
                       an account validation check.

                         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