ARLOCKBOX

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 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 BR49.1 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 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 WH32.5
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830 ZW130 AR214


UPDATED BY
AR01.1 AR09.1 AR10.1 AR14.1 AR301 AR501
AR550 TX140

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARL-COMPANY
Element: Company		Numeric 4
The number representing an AR company.
AR14.1
ARL-LOCK-BOX
Element: Lock Box		Alpha 2
Lock box number that identifies a lock box.
AR14.1
ARL-PROCESS-LEVEL
Element: Process Level		Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AR14.1
ARL-CASH-CODE
Element: Cash Code		Alpha 4
Cash code that this lock box will reference during processing. Cash codes are tied to GL cash accounts.
AR14.1
ARL-NAME
Element: Lock Box Name		Alpha 30 (Lower Case)
This is the name given for the lock box location.
AR14.1
ARL-REMIT-ADDR1
Element: Lock Box Address 1		Alpha 30
First address line of lock box address.
AR14.1
ARL-REMIT-ADDR2
Element: Lock Box Address 2		Alpha 30
Second address line of lock box address.
AR14.1
ARL-REMIT-ADDR3
Element: Lock Box Address 3		Alpha 30
Third address line of lock box address.
AR14.1
ARL-REMIT-ADDR4
Element: Lock Box Address 4		Alpha 30
Fourth address line of lock box address.
AR14.1
ARL-CITY
Element: City		Alpha 18 (Lower Case)
City name in the lock box address.
AR14.1
ARL-STATE
Element: State or Province		Alpha 2
State or province abbreviation in the lock box address.
AR14.1
ARL-ZIP
Element: Postal Code		Alpha 10
Postal code in the lock box address.
AR14.1
ARL-COUNTRY
Element: Country or Other		Alpha 30 (Lower Case)
This field contains the country of the address, or it can be used for additional information such as an attention name.
AR14.1
ARL-COUNTY
Element: County		Alpha 25 (Lower Case)
This field contains the county of the address, or it can be used for additional information such as an attention name.
AR14.1
ARL-USED-FL
Element: Used Flag		Alpha 1
This field indicates whether the lock box has been used.
AR09.1 AR10.1
AR301 AR501
AR550 TX140
ARL-JRNL-BOOK-NBR
Element: Journal Book Number		Alpha 12
This field contains the journal book number for the lock box.
AR14.1
ARL-CURRENCY-CD
Element: Currency Code		Alpha 5
The currency code of the lockbox.
AR14.1
ARL-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AR14.1


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
AR14.1 AR214
AR301 AR501
AR550 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


ARLOCKBOX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:09:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.