Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARILOCKBOX FILE

                         AR Lock Box Interface

AR Lock Box Interface

UPDATED BY

AR570     AR97.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARB-LOCK-TYPE        Numeric 1                                   AR97.4
Record Type          Record type indicator. Valid values
                     are:

                     4 = Remittance detail
                     6 = Payment detail
                     7 = Payment header

ARB-LOCK-BATCH       Numeric 3                                   AR97.4
Batch Number         Bank assigned batch number. This number
                     will be a reference only number on the
                     created payment header record.

ARB-LOCK-SEQ         Numeric 3                                   AR97.4
Sequence Number      Sequence number indicating variable
                     information based on record type.

ARB-LOCK-FILLERA     Alpha 5                                     AR97.4
Filler A             Variable field data based on record
                     type.

ARB-LOCK-BOX         Alpha 2                                     AR97.4
Lock Box Code        Lock box code identifying receiving
                     lock box of payments.

ARB-LOCK-FILLERB     Alpha 66                                    AR97.4
Filler B             Variable field data based on record
                     type.

                         ARILOCKBOX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARBSET1   LOCK-TYPE     The path is used to keep records unique  AR97.4
          LOCK-BATCH    and to maintain records.
          LOCK-SEQ
          LOCK-FILLERA
          LOCK-BOX
          LOCK-FILLERB

ARBSET2   LOCK-BOX      The path is used to read payment header  AR570
          LOCK-BATCH    records.
                        Subset
                        Where (LOCK-TYPE = 7 )

ARBSET3   LOCK-BATCH    The path is used to read payment detail  AR570
          LOCK-SEQ      records.
                        Subset
                        Where (LOCK-TYPE = 6 )

ARBSET4   LOCK-BATCH    The path is used to read remit detail    AR570
          LOCK-SEQ      records.
                        Duplicates, Subset
                        Where (LOCK-TYPE = 4 )