|
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
|