|
|
ARLOCKBOX FILE
AR Lock Box Location
AR Lock Box Location
REFERENCED BY
AC115 AC15.2 AC450 AR08.1 AR150 AR155
AR161 AR20.1 AR214 AR220 AR228 AR27.1
AR28.8 AR28.9 AR570 AR575 AR580 BL04.1
BL120 BL121 BL122 BL123 BL130 BL20.1
BL20.3 BL202 BL204 BL21.2 BL21.5 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 BL80.1 BL80.3 BL802 BL81.1 BL820
BL85.1 BL85.2 BL90.1 BL902 BL92.1 BL940
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 OE112 OE113 OE114 OE129 OE130
OE14.3 OE14.4 OE15.1 OE15.2 OE15.3 OE15.4
OE15.5 OE15.7 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 OE54.1 OE60.1 OE80.1
OE80.2 OE81.1 OE81.2 OE810 OE830 OE85.1
OE90.1 OE90.2 OE920 OE950 PBIP.1 SA03.1
SA100 SA252 SA254 SA256 SA261 SA271
SA281 SA291 SA300 SA80.2 SA90.2 TX140
TX40.1 WH110 WH120 WH130 WH132 WH190
WH20.2 WH20.7 WH21.2 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
WH33.5 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
UPDATED BY
AR01.1 AR10.1 AR14.1 AR501 AR550 AR700
AR980 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
County For use in a future release.
ARL-USED-FL Alpha 1 AR10.1 AR501
Used Flag This field indicates whether the lock AR550 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. AR980
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).
ARL-REGION Alpha 2 AR14.1
Region Code The region code, if applicable for the
country. Used only by Intrastat. Must be
defined in IN02.1 (Region Maintenance).
ARLOCKBOX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARLSET1 LOCK-BOX This path is used for record AC115 AC15.2
uniqueness. AC450 AR01.1
AR08.1 AR10.1
AR14.1 AR150
AR155 AR161
AR20.1 AR214
AR220 AR228
AR27.1 AR28.8
AR28.9 AR501
AR550 AR570
AR575 AR580
AR700 AR980
BL02.1 BL02.2
BL04.1 BL120
BL121 BL122
...
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
|