Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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     BR152

UPDATED BY

AR130     AR21.2    AR21.4    AR21.5    AR21.1    AR21.3
AR29.1    AR29.2    AR300     AR570     AR575     AR580
AR700     AR20.1    AR30.1    AR30.2    AR30.4    CB06.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RMI-COMPANY            Numeric 4                                 AR21.4  AR21.5
Element: Company       Company number.                           AR570   AR575
                                                                 AR580

RMI-BATCH-NBR          Numeric 6                                 AR21.4  AR21.5
Element: Batch Number  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
Record Sequence                                                  AR29.1  AR570
Number                                                           AR575   AR580

RMI-REMIT-SEQ          Numeric 5                                 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: Transaction TyType of record the remittance record is   AR570   AR575
                       referencing. Valid values are:            AR580

                       I = Invoice or Debit Memo
                       C = Credit Memo

RMI-INVOICE            Alpha 22                                  AR21.4  AR21.5
Element: Invoice NumberUsed 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 = Applied

RMI-APPLD-AMT          Signed 15.2                               AR130   AR21.4
Element: Adj Amt       The applied amount of the remittance.     AR21.5  AR570
                                                                 AR575   AR580

RMI-PROCESS-FL         Alpha 1                                   AR130   AR21.4
Element: All Flag      N = No                                    AR21.5  AR570
                       Y = Yes                                   AR575   AR580
                                                                 AR700

                         ARREMIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RMISET1   COMPANY       This path is used for record uniqueness  AR130   AR20.1
          BATCH-NBR     and record selection.                    AR21.1  AR21.2
          PAYMENT-SEQ                                            AR21.3  AR21.4
          REMIT-SEQ                                              AR21.5  AR220
                                                                 AR29.1  AR29.2
                                                                 AR30.1  AR30.2
                                                                 AR30.4  AR300
                                                                 AR700   BR152
                                                                 CB06.2

RMISET2   COMPANY       This path is used to select records      AR130
          BATCH-NBR     that reference a credit memo.
          PAYMENT-SEQ   Subset
          TRANS-TYPE    Where TRANS-TYPE = "C"
          REMIT-SEQ

RMISET3   COMPANY       This path is used to select records      AR130
          BATCH-NBR     that reference an invoice or debit memo.
          PAYMENT-SEQ
          TRANS-TYPE    Subset
          REMIT-SEQ     Where TRANS-TYPE = "I"

                         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