Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARILOCKBOX


                            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
Element: Record Type   Record type indicator. Valid values
                       are:

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

ARB-LOCK-BATCH         Numeric 3                                 AR97.4
Element: 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
Element: Sequence NumbeSequence number indicating variable
                       information based on record type.

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

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

ARB-LOCK-FILLERB       Alpha 66                                  AR97.4
Element: 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