Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARLOCKBOX


                             ARLOCKBOX FILE

                          AR Lock Box Location

The AR Lock Box Location file contains lock box records representing the
address location of a lock box, as well as a default process level and cash
code for cash entry.

REFERENCED BY

AR08.1    AR150     AR155     AR161     AR20.1    AR214
AR219     AR220     AR228     AR27.1    AR28.8    AR28.9
AR48.1    AR48.3    AR570     AR575     AR580     BL04.1
BL120     BL121     BL122     BL123     BL125     BL130
BL20.1    BL20.3    BL20.6    BL202     BL204     BL21.2
BL21.5    BL217     BL220     BL231     BL246     BL29.1
BL29.2    BL290     BL291     BL31.1    BL31.2    BL31.3
BL31.5    BL31.7    BL32.3    BL32.4    BL33.1    BL331
BL34.1    BL46.1    BL46.2    BL520     BL530     BL546
BL80.1    BL80.3    BL802     BL81.1    BL82.1    BL820
BL85.1    BL85.2    BL90.1    BL92.1    BR00.1    BR00.2
BR02.3    BR10.1    BR11.1    BR120     BR121     BR122
BR140     BR16.1    BR17.1    BR19.1    BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR20.7    BR21.2    BR210
BR211     BR216     BR217     BR220     BR400     BR420
BR45.1    BR450     BR46.1    BR46.2    BR46.4    BR521
BRIP.1    CB06.2    IC02.1    IC531     OE10.1    OE10.2
OE10.3    OE10.4    OE10.5    OE10.6    OE10.7    OE10.8
OE11.1    OE11.4    OE11.8    OE11.9    OE110     OE111
OE112     OE113     OE114     OE116     OE129     OE13.2
OE13.3    OE13.5    OE13.6    OE130     OE14.3    OE14.4
OE16.1    OE230     OE254     OE260     OE270     OE271
OE272     OE284     OE285     OE286     OE290     OE291
OE292     OE293     OE294     OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE330
OE510     OE53.1    OE530     OE54.1    OE60.1    OE80.1
OE80.2    OE81.1    OE81.2    OE810     OE830     OE85.1
OE85.3    OE86.1    OE90.1    OE90.2    PBIP.1    PR197
SA03.1    SA100     SA252     SA254     SA256     SA261
SA271     SA281     SA291     SA300     SA80.2    SA90.2
TX140     TX40.1    WH110     WH120     WH130     WH132
WH190     WH20.1    WH20.2    WH20.7    WH21.2    WH224
WH30.1    WH30.2    WH30.3    WH30.4    WH31.1    WH31.2
WH31.3    WH31.4    WH32.1    WH32.2    WH32.3    WH32.4
WH33.5    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     WO30.1

UPDATED BY

AR01.1    AR09.1    AR10.1    AR14.1    AR301     AR501
AR550     BL02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARL-COMPANY            Numeric 4                                 AR14.1
Element: Company       Company number.

ARL-LOCK-BOX           Alpha 2                                   AR14.1
Element: Lock Box      Lock box number that identifies a lock
                       box.

ARL-PROCESS-LEVEL      Alpha 5                                   AR14.1
Element: Process Level This field contains the process level,
                       which is the reporting hierarchy below
                       company.

ARL-CASH-CODE          Alpha 4                                   AR14.1
Element: Cash Code     Cash code that this lock box will
                       reference during processing. Cash codes
                       are tied to GL cash accounts.

ARL-NAME               Alpha 30  (Lower Case)                    AR14.1
Element: Lock Box Name This is the name given for the lock box
                       location.

ARL-REMIT-ADDR1        Alpha 30                                  AR14.1
Element: Lock Box AddreFirst address line of lock box address.

ARL-REMIT-ADDR2        Alpha 30                                  AR14.1
Element: Lock Box AddreSecond address line of lock box
                       address.

ARL-REMIT-ADDR3        Alpha 30                                  AR14.1
Element: Lock Box AddreThird address line of lock box address.

ARL-REMIT-ADDR4        Alpha 30                                  AR14.1
Element: Lock Box AddreFourth address line of lock box
                       address.

ARL-CITY               Alpha 18  (Lower Case)                    AR14.1
Element: City          City name in the lock box address.

ARL-STATE              Alpha 2                                   AR14.1
Element: State or ProviState or province abbreviation in the
                       lock box address.

ARL-ZIP                Alpha 10                                  AR14.1
Element: Postal Code   Postal code in the lock box address.

ARL-COUNTRY            Alpha 30  (Lower Case)                    AR14.1
Element: Country or OthThis field contains the country of the
                       address, or it can be used for
                       additional information such as an
                       attention name.

ARL-COUNTY             Alpha 25  (Lower Case)                    AR14.1
Element: County        This field contains the county of the
                       address, or it can be used for
                       additional information such as an
                       attention name.

ARL-USED-FL            Alpha 1                                   AR09.1  AR10.1
Element: Used Flag     This field indicates whether the lock     AR301   AR501
                       box has been used.                        AR550   BL02.1

ARL-JRNL-BOOK-NBR      Alpha 12                                  AR14.1
Element: Journal Book NThis field contains the journal book
                       number for the lock box.

ARL-CURRENCY-CD        Alpha 5                                   AR14.1
Element: Currency Code The currency code of the lockbox.

ARL-COUNTRY-CODE       Alpha 2                                   AR14.1
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

                         ARLOCKBOX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARLSET1   LOCK-BOX      This path is used for record             AR01.1  AR08.1
                        uniqueness.                              AR09.1  AR10.1
                                                                 AR14.1  AR150
                                                                 AR155   AR161
                                                                 AR20.1  AR214
                                                                 AR219   AR220
                                                                 AR228   AR27.1
                                                                 AR28.8  AR28.9
                                                                 AR301   AR48.1
                                                                 AR48.3  AR501
                                                                 AR550   AR570
                                                                 AR575   AR580
                                                                 BL02.1  BL04.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 ...

                         ARLOCKBOX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ar Company     ARCOMP       Required

                            ARL-COMPANY          -> ACO-COMPANY

Arproclevl     ARPROCLEVL   Required

                            ARL-COMPANY          -> APV-COMPANY
                            ARL-PROCESS-LEVEL    -> APV-PROCESS-LEVEL