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