|
|
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 comapny, process level
cash code, and cusrrency for cash entry.
REFERENCED BY
AC56.1 AC560 AR08.1 AR120 AR150 AR155
AR161 AR20.1 AR214 AR219 AR220 AR228
AR27.1 AR28.8 AR28.9 AR48.1 AR48.3 AR570
AR575 AR580 BL04.1 BL10.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
BL81.1 BL82.1 BL820 BL85.1 BL85.2 BL90.1
BL92.1 BR00.1 BR00.2 BR02.3 BR10.1 BR10.9
BR11.1 BR120 BR121 BR122 BR123 BR140
BR151 BR152 BR155 BR156 BR16.1 BR16.2
BR17.1 BR180 BR19.1 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.7 BR21.2 BR210 BR211
BR216 BR217 BR220 BR251 BR252 BR253
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR51.1 BR51.2 BR52.1 BR52.2 BR521
BR53.1 BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1
CB06.2 IC02.1 PW110 TX40.1 WH110 WH120
WH130 WH132 WH190 WH20.1 WH20.2 WH20.7
WH21.2 WH224 WH226 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
UPDATED BY
AR01.1 AR09.1 AR10.1 AR14.1 AR301 AR501
AR550 BL02.1 BL802 PW550 TX140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARL-COMPANY Numeric 4 AR14.1
Element: Company The number representing an AR company.
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
BL802 PW550
TX140
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 AC56.1 AC560
AR01.1 AR08.1
AR09.1 AR10.1
AR120 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 BL10.1
...
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
|
