ARIPMT FILE
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
payments are a part of.
ART-PAYMENT-SEQ Numeric 6 AR97.6
Payment Seq Payment Sequence. This is the generated
sequence number to separate individual
invoice payment requirements.
ART-REMIT-SEQ Numeric 5 AR97.6
Remit Seq
ART-LOCK-BOX Alpha 2 AR97.6
Lock Box
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
ART-ORIG-RATE Signed 12.6 AR97.6
Orig Rate
ART-DEPOSIT-DATE Numeric 8 (yyyymmdd) AR97.6
Deposit Date
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
ART-TRANS-NBR Alpha 10 (Right Justified) AR97.6
Trans Nbr A unique, user-defined value used to
identify the transaction.
ART-TRAN-AMT Signed 15.2 AR97.6
Transaction Amount
ART-REMIT-TYPE Alpha 1 AR97.6
Remittance Type This field contains remittance type.
ART-TRANS-REM-NBR Alpha 22 AR97.6
Trans Rem Nbr
ART-APPLD-AMT Signed 15.2 AR97.6
Applied Amount
ART-USR-FLD-01 Alpha 20 AR97.6
Usr Fld 01
ART-USR-FLD-02 Alpha 20 AR97.6
Usr Fld 02
ART-USR-FLD-03 Alpha 20 AR97.6
Usr Fld 03
ART-USR-FLD-04 Alpha 20 AR97.6
Usr Fld 04
ART-USR-FLD-05 Alpha 20 AR97.6
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
|
