|
|
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
BR10.1 BR11.1 BR120 BR121 BR122 BR123
BR15.1 BR151 BR152 BR155 BR156 BR16.1
BR16.2 BR210 BR211 BR215 BR220 BR251
BR252 BR253 BR420 BR450 BR51.1 BR51.2
BR52.1 BR52.2 BR521 BR53.1 BR55.2 BR91.1
BRIP.1 BRPI.1 CB06.2 IC02.1 IC531 PBIP.1
PR197 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 AR10.1 AR14.1 AR501 AR550 AR700
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 AR10.1 AR501
Element: Used Flag This field indicates whether the lock AR550
box has been used.
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 AR700
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 AC551 AR01.1
uniqueness. AR08.1 AR10.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
BR10.1 BR11.1
BR120 BR121
BR122 BR123
...
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
|
