Lawson Insight Technical Documentation |
|
ARREMIT
ARREMIT FILE
AR Payment Remittance
The AR Payment Remittance file contains remittance records originating from
the lock box interface process or online cash entry. Remittance records are
used in automatic cash application and act as a reference record to an
invoice, debit memo or credit memo.
REFERENCED BY
AR220 BR02.3 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR156 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR420 BR521
UPDATED BY
AR130 AR21.2 AR21.4 AR21.5 AR21.1 AR21.3
AR29.1 AR29.2 AR300 AR570 AR575 AR580
AR20.1 AR30.1 AR32.1 AR34.1 CB06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMI-COMPANY Numeric 4 AR21.4 AR21.5
Element: Company The number representing an AR company. AR570 AR575
AR580
RMI-BATCH-NBR Numeric 6 AR21.4 AR21.5
Element: Batch Nbr This number identifies the referenced AR570 AR575
payment batch number to which the AR580
remittance corresponds.
RMI-PAYMENT-SEQ Numeric 6 AR21.4 AR21.5
Element: Seq Number A unique number assigned to each AR29.1 AR570
transaction to be interfaced into the AR575 AR580
Lawson system.
RMI-REMIT-SEQ Numeric 7 AR21.4 AR21.5
Element: Remittance SeqThis is the sequence number for this AR570 AR575
remittance record for the payment. AR580
RMI-TRANS-TYPE Alpha 1 AR21.4 AR21.5
Element: Trans Type Type of record the remittance record is AR570 AR575
referencing. Valid values are: AR580
I = Invoice or Debit Memo
C = Credit Memo
D = Debit Memo
RMI-INVOICE Alpha 22 AR21.4 AR21.5
Element: Invoice Used to identify the invoice. AR570 AR575
AR580
RMI-STATUS Numeric 1 AR130 AR21.4
Element: Status Indicates processing status of the AR21.5
remittance record. Valid values are:
0 = unapplied
1 = application not performed
2 = applied
These values are used by the AR programs
and verified in ARREMIT that these
values are used.
1
1 = Application not performed
RMI-APPLD-AMT Signed 18.2 AR130 AR21.4
Element: Intl Amt The applied amount of the remittance. AR21.5 AR570
AR575 AR580
RMI-PROCESS-FL Alpha 1
Element: Process Fl N = No
Y = Yes
ARREMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMISET1 COMPANY AR130 AR20.1
BATCH-NBR AR21.1 AR21.2
PAYMENT-SEQ AR21.3 AR21.4
REMIT-SEQ AR21.5 AR220
AR29.1 AR29.2
AR30.1 AR300
AR32.1 AR34.1
BR02.3 BR120
BR121 BR122
BR123 BR140
BR151 BR152
BR156 BR20.1
BR20.2 BR20.3
BR20.4 BR20.5
BR420 BR521
...
RMISET2 COMPANY Subset AR130
BATCH-NBR Where TRANS-TYPE = "C"
PAYMENT-SEQ
TRANS-TYPE
REMIT-SEQ
RMISET3 COMPANY Subset AR130
BATCH-NBR Where TRANS-TYPE = "I"
PAYMENT-SEQ Or TRANS-TYPE = "D"
TRANS-TYPE
REMIT-SEQ
ARREMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arpayment ARPAYMENT Required
RMI-COMPANY -> APM-COMPANY
RMI-BATCH-NBR -> APM-BATCH-NBR
RMI-PAYMENT-SEQ -> APM-PAYMENT-SEQ
ARREMIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aroitems AROITEMS Required
RMI-COMPANY -> ARO-COMPANY
RMI-TRANS-TYPE -> ARO-TRANS-TYPE
RMI-INVOICE -> ARO-INVOICE
ARO-PAYMENT-SEQ
|