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.4 (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                                              AR97.4
          LOCK-BATCH
          LOCK-SEQ
          LOCK-FILLERA
          LOCK-BOX
          LOCK-FILLERB

ARBSET2   LOCK-BOX      Subset                                   AR570
          LOCK-BATCH    Where (LOCK-TYPE = 7 )

ARBSET3   LOCK-BOX      Subset                                   AR570   AR97.4
          LOCK-BATCH    Where (LOCK-TYPE = 6 )
          LOCK-SEQ

ARBSET4   LOCK-BOX      Subset                                   AR570   AR97.4
          LOCK-BATCH    Where (LOCK-TYPE = 4 )
          LOCK-SEQ
          LOCK-TYPE
          LOCK-FILLERA
          LOCK-FILLERB