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
AC551 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 BL121 BL123 BL125 BL202 BL204
BL217 BL220 BL231 BL246 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
BL80.1 BL80.3 BL802 BL81.1 BL82.1 BL85.1
BL85.2 BL90.1 BR10.1 BR11.1 BR120 BR121
BR210 BR211 BR220 BR420 BR450 BRIP.1
IC02.1 PR197 TX140 TX40.1 WH110 WH120
WH130 WH21.2 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
AR01.1 AR14.1 AR501 AR550 AR700 BL02.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARL-COMPANY Numeric 4 AR14.1
Company Company number.
ARL-LOCK-BOX Alpha 2 AR14.1
Lock Box Lock box number that identifies a lock
box.
ARL-PROCESS-LEVEL Alpha 5 AR14.1
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
ARL-CASH-CODE Alpha 4 AR14.1
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
Lock Box Name This is the name given for the lock box
location.
ARL-REMIT-ADDR1 Alpha 30 AR14.1
Lock Box Address 1 First address line of lock box address.
ARL-REMIT-ADDR2 Alpha 30 AR14.1
Lock Box Address 2 Second address line of lock box
address.
ARL-REMIT-ADDR3 Alpha 30 AR14.1
Lock Box Address 3 Third address line of lock box address.
ARL-REMIT-ADDR4 Alpha 30 AR14.1
Lock Box Address 4 Fourth address line of lock box
address.
ARL-CITY Alpha 18 (Lower Case) AR14.1
City City name in the lock box address.
ARL-STATE Alpha 2 AR14.1
State or Province State or province abbreviation in the
lock box address.
ARL-ZIP Alpha 10 AR14.1
Postal Code Postal code in the lock box address.
ARL-COUNTRY Alpha 30 (Lower Case) AR14.1
Country or Other This 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
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 AR501 AR550
Used Flag This field indicates whether the lock BL02.1
box has been used.
ARL-JRNL-BOOK-NBR Alpha 12 AR14.1
Journal Book Number This field contains the journal book
number for the lock box.
ARL-CURRENCY-CD Alpha 5 AR14.1 AR700
Currency Code The currency code of the lockbox.
ARL-COUNTRY-CODE Alpha 2 AR14.1
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 AC551 AR01.1
uniqueness. AR08.1 AR14.1
AR150 AR155
AR161 AR20.1
AR214 AR219
AR220 AR228
AR27.1 AR28.8
AR28.9 AR48.1
AR48.3 AR501
AR550 AR570
AR575 AR580
AR700 BL02.1
BL04.1 BL121
BL123 BL125
BL202 BL204
...
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
|
