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       The company number represents an
                       established company and is entered on
                       all function codes.

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
Number

ART-REMIT-SEQ          Numeric 5                                 AR97.6
Element: App 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
Accounts Receivable
Code

ART-CURRENCY-CD        Alpha 5                                   AR97.6
Element: Currency Code

ART-ORIG-RATE          Signed 12.6                               AR97.6
Element: Account Rate

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

ART-GL-DATE            Numeric 8  (yyyymmdd)                     AR97.6
Element: 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 17                                  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 15.2                               AR97.6
Element: Adj 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 15.2                               AR97.6
Element: Adj 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

                         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