Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARILOCKBOX FILE

                         AR Lock Box Interface

The AR Lock Box Interface file is used for lock box interfacing of external
payment records via a formatted banking record specification. AR570 (Lock Box
Interface), will load records from this file to create payment header and
payment detail records. Optional payment remittance records will also be
created.

Records in this file can be changed in AR97.3 (Interface Lock Box) to comply
with edit requirements of AR570.

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-BOX      The path is used to read payment detail  AR570   AR97.4
          LOCK-BATCH    records.
          LOCK-SEQ      Subset
                        Where (LOCK-TYPE = 6 )

ARBSET4   LOCK-BATCH    The path is used to read remit detail    AR570   AR97.4
          LOCK-SEQ      records.
          LOCK-TYPE     Subset
          LOCK-FILLERA  Where (LOCK-TYPE = 4 )
          LOCK-FILLERB
          LOCK-BOX