|
|
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
|
