ARIPMT FILE The 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 (Payment1 Interface). Records in this file can be maintained in AR97.6 (interface Payment1) to comply with edit requirements of AR575. 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 invoices, debit memos, and credit memos are a part of. ART-PAYMENT-SEQ Numeric 6 AR97.6 Payment Sequence Payment Sequence. This is the generated sequence number to separate individual invoice payment requirements. ART-REMIT-SEQ Numeric 5 AR97.6 Remittance Sequence Total number of remittance records that have been created from the lock box interface program for this payment. ART-LOCK-BOX Alpha 2 AR97.6 Lock Box This is the remit-to location if a lock box is being used for payment receipts. Must be a valid lock box code. 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 Currency code of the payment. ART-ORIG-RATE Signed 12.6 AR97.6 Exchange Rate The rate used to convert a transaction amount from a non-base currency to the company base currency. ART-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR97.6 Deposit Date The deposit date of the payment. 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 Electronic data interchange number associated with the payment. ART-TRANS-NBR Alpha 10 (Right Justified) AR97.6 Transaction Number A unique, user-defined value used to identify the transaction. ART-TRAN-AMT Signed 15.2 AR97.6 Transaction Amount The transaction amount. ART-REMIT-TYPE Alpha 1 AR97.6 Remittance Type This field contains remittance type. ART-TRANS-REM-NBR Alpha 10 AR97.6 Transaction Required. Remit number representing a Remittance Number Remittance Number invoice/debit memo or credit memo number. ART-APPLD-AMT Signed 15.2 AR97.6 Applied Amount Applied amount of the payment in company base currency. ARIPMT FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN ARTSET1 COMPANY Identifies a payment remittance record. AR575 AR97.6 BATCH-NBR PAYMENT-SEQ REMIT-SEQ ARTSET2 COMPANY Identifies a payment record. AR575 BATCH-NBR Subset PAYMENT-SEQ Where PAYMENT-SEQ != Zeroes And REMIT-SEQ = Zeroes ARTSET3 COMPANY Identifies a batch record. AR575 AR97.6 BATCH-NBR Subset Where PAYMENT-SEQ = Zeroes And REMIT-SEQ = Zeroes |