GLADDRESS

General Ledger Address

This file contains the name, address, and communication numbers for the company and needed accounting units defined on the Address form tab in GL10.1 (Company).

REFERENCED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC03.7 AC10.1 AC17.3 AC17.4 AC210 AM01.1
AM01.2 AM01.3 AM05.1 AM06.1 AM06.2 AM06.3
AM06.5 AM06.6 AM09.1 AM115 AM117 AM118
AM12.1 AM120 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM152 AM154 AM16.1
AM17.1 AM170 AM18.1 AM18.2 AM180 AM185
AM19.1 AM19.2 AM190 AM192 AM195 AM20.1
AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM20.7
AM20.8 AM205 AM206 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM21.7 AM21.8 AM211
AM212 AM214 AM219 AM220 AM221 AM222
AM223 AM224 AM225 AM230 AM235 AM240
AM241 AM245 AM25.1 AM250 AM251 AM252
AM255 AM258 AM260 AM265 AM266 AM267
AM270 AM275 AM277 AM278 AM280 AM281
AM282 AM285 AM287 AM288 AM290 AM292
AM295 AM30.1 AM30.2 AM30.3 AM300 AM310
AM320 AM330 AM35.1 AM40.1 AM40.2 AM40.3
AM40.4 AM41.1 AM41.2 AM45.1 AM500 AM501
AM502 AM51.1 AM52.1 AM551 AM580 AM60.1
AM70.1 AM75.1 AM80.1 AM85.1 AM88.7 AM90.1
AM90.4 AM90.5 AM90.6 AM91.1 AM91.4 AM91.5
AM92.1 AM93.1 AM95.1 AM95.4 AM95.5 AM95.6
AM96.1 AM97.1 AM98.1 AM99.1 AP00.4 AP00.7
AP01.1 AP05.1 AP05.2 AP05.7 AP05.8 AP115
AP125 AP126 AP130 AP131 AP136 AP150
AP151 AP155 AP156 AP160 AP166 AP170
AP175 AP176 AP180 AP181 AP185 AP190
AP191 AP193 AP195 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.6 AP20.7 AP20.8 AP200
AP201 AP21.1 AP220 AP23.1 AP237 AP25.1
AP25.2 AP255 AP26.1 AP265 AP27.1 AP275
AP28.1 AP28.2 AP30.2 AP30.4 AP305 AP520
AP55.1 AP55.2 AP56.1 AP56.2 AP80.1 AP81.1
AP90.5 AP91.4 AP95.2 AP95.3 API1.1 API2.1
AR01.1 AR13.1 AR13.2 BN00.1 BN00.2 BN15.1
BN150 BN190 BN20.1 BN66.1 BN80.1 BN81.1
BN81.2 CB00.3 CB01.2 CB01.4 CB03.1 CB03.2
CB05.1 CB06.1 CB06.2 CB10.1 CB10.3 CB10.5
CB145 CB15.1 CB15.2 CB150 CB162 CB175
CB180 CB185 CB186 CB187 CB190 CB191
CB195 CB20.1 CB20.6 CB210 CB215 CB220
CB221 CB222 CB25.1 CB255 CB260 CB286
CB30.1 CB43.1 CB44.1 CB45.1 CB46.1 CB50.1
CB500 CB54.1 CB543 CB544 CB55.1 CB554
CB62.1 CB80.1 CB82.1 CB90.2 CB90.5 CB90.7
CB99.3 CB99.4 CB99.5 EE11.1 EE135 EE175
EE20.1 EE20.2 EE20.3 EE20.4 EE220 EE230
EE275 EE35.1 EE35.2 EE520 EE90.3 CA00.1
CA00.2 CA05.1 CA10.1 CA10.2 CA10.4 CA10.5
CA10.6 CA10.7 CA110 CA15.1 CA15.2 CA160
CA190 CA195 CA199 CA210 CA215 CA240
CA290 CA60.1 FB10.1 FB100 FB101 FB11.1
FB11.2 FB111 FB120 FB121 FB122 FB141
FB145 FB160 FB165 FB190 FB195 FB20.1
FB20.2 FB20.3 FB20.4 FB20.6 FB20.7 FB21.1
FB210 FB211 FB215 FB220 FB225 FB230
FB231 FB235 FB240 FB25.1 FB265 FB295
FB296 FB30.1 FB31.1 FB325 FB35.1 FB40.1
FB40.2 FB40.3 FB40.4 FB45.1 FB60.1 FB65.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL111 GL120 GL122 GL135 GL141 GL145
GL146 GL148 GL165 GL167 GL170 GL179
GL190 GL191 GL192 GL195 GL196 GL197
GL199 GL230 GL235 GL238 GL240 GL241
GL243 GL245 GL250 GL265 GL267 GL270
GL275 GL276 GL281 GL290 GL291 GL292
GL293 GL294 GL295 GL296 GL298 GL299
GL30.1 GL30.2 GL300 GL310 GL320 GL322
GL325 GL326 GL327 GL328 GL330 GL36.1
GL40.1 GL40.2 GL40.3 GL40.4 GL40.5 GL40.6
GL40.7 GL40.8 GL41.1 GL41.3 GL41.4 GL43.1
GL44.1 GL45.1 GL50.1 GL50.2 GL50.4 GL50.5
GL500 GL55.1 GL65.1 GL65.3 GL67.1 GL70.1
GL70.2 GL70.3 GL70.5 GL70.6 GL75.1 GL76.1
GL76.2 GL90.1 GL90.2 GL90.3 GL90.4 GL90.5
GL90.6 GL90.7 GL93.1 GL93.3 GL94.1 GL94.2
GL94.3 GL94.4 GL94.5 GL94.6 GL94.7 GL95.1
GL95.2 GL95.3 GL95.4 GL95.5 GL95.6 GL95.7
GL95.8 GL95.9 GL96.1 GL96.2 GL96.3 GL96.4
GL96.5 GL97.1 GL97.2 GL97.3 GL97.4 GL97.5
GL97.6 GL97.7 GL97.8 GL97.9 GL98.1 GL98.2
GL98.3 GL98.4 GL98.5 GL99.1 GL99.2 GL99.3
GL99.4 GL99.5 GL99.6 RW00.1 RW10.2 RW10.3
RW10.4 RW10.6 RW10.7 RW20.5 RW20.6 RW60.1
RW60.4 RW70.1 HR00.1 HR01.1 HR200 PR521
CU03.1 CU161 CU203 CU220 CU261 CU300
CU61.2 EX175 EX542 EX545 EXI2.1 EXI4.1
GL01.1 GL01.2 GL03.6 GL08.1 GL08.2 GL121
GL14.8 GL161 GL162 GL198 GL210 GL220
GL221 GL222 GL225 GL25.1 GL261 GL311
GL342 GL38.2 GL42.1 GL61.1 GL62.1 IFAC.1
IFCU.1 IFEB.1 IFFC.1 IFGT.1 IFOS.1 IFUC.1
MX135 LP130 LP140 LP198 MA05.3 MA05.6
MA205 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA54.1
MA54.7 MA540 MAI1.1 PA182 PO01.1 PO136
PO15.1 PO15.2 PO15.4 PO190 PO300 PO520
POCP.1 POI3.1 POI7.1 POIF.1 POIH.1 POII.1
POIJ.1 POIM.1 PR05.1 PR05.3 PR128 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR140 PR189 PR195 PR196 PR197 PR198
PR26.1 PR29.1 PR32.1 PR32.2 PR33.1 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR37.1 PR38.1
PR45.1 PR47.1 PR514 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 PR85.1 PR89.1
UK102 UK330 UK47.1 UK560 MM280 RQ01.1
RQ50.1 SL40.1 SL40.4 SNGL.1 TA147 TA195
TA196 IN120 TX00.1 TX04.1 TX100 TX101
TX202 TX222 TX226 TX301 TX40.1


UPDATED BY
GL110 GL10.1 GL124 GL125 GL20.1 ACVW.1
AP161 GL147 RW100 GLAV.1 GLCV.1 GLVW.1
SLVW.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAD-COMPANY
Element: Company
Numeric 4
The company number as defined in GL00.1 (Company).
GL10.1 GL110
GL124 GL125
GL20.1
GAD-ACCT-UNIT
Element: Acct Unit
Alpha 15
The valid Lawson General Ledger accounting in GLNAMES.
GL124 GL125
GL20.1
GAD-ADDR-CONTACT
Element: Addr Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
GL10.1 GL124
GL125 GL20.1
GAD-PHONE-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
GL10.1 GL124
GL125 GL20.1
GAD-PHONE-NUMBER
Element: Phone
Alpha 15
Contains the telephone number, including area code.
GL10.1 GL124
GL125 GL20.1
GAD-PHONE-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
GL10.1 GL124
GL125 GL20.1
GAD-FAX-COUNTRY
Element: Phone Country
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
GL10.1 GL124
GL125 GL20.1
GAD-FAX-NUMBER
Element: Phone
Alpha 15
Phone number.
GL10.1 GL124
GL125 GL20.1
GAD-FAX-EXT
Element: Phone Ext
Alpha 5
This field contains the telephone extension number.
GL10.1 GL124
GL125 GL20.1
GAD-TELEX-NUMBER
Element: Phone
Alpha 15
Phone number.
GL10.1 GL124
GL20.1
GAD-OPT-FIELD1
Element: Opt Field1
Alpha 15 (Lower Case)
This field lets you enter any additional information you would like to appear on the address.
GL10.1 GL124
GL125 GL20.1
GAD-OPT-FIELD2
Element: Opt Field1
Alpha 15 (Lower Case)
This field lets you enter any additional information you would like to appear on the address.
GL10.1 GL124
GL125 GL20.1
GAD-OPT-FIELD3
Element: User Fld2
Alpha 30 (Lower Case)
GL10.1 GL124
GL125 GL20.1
GAD-ADDR-CODE
Element: Addr Code
Alpha 20
This is a code representing the address for the institution or the institution location. The address is stored in the ADDRDATA file.
GL10.1 GL124
GL125 GL20.1


GLADDRESS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GADSET1 COMPANY
ACCT-UNIT
...
AC03.1 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC03.7 AC10.1
AC17.3 AC17.4
AC210 ACVW.1
AM01.1 AM01.2
AM01.3 AM05.1
AM06.1 AM06.2
AM06.3 AM06.5
AM06.6 AM09.1
AM115 AM117
AM118 AM12.1
AM120 AM125
AM135 AM145
GADSET3 ADDR-CODE
COMPANY
ACCT-UNIT
KeyChange


GLADDRESS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Addrdata ADDRDATA Not Required
GAD-ADDR-CODE->GDD-ADDR-CODE (GDDSET1)
Glnames GLNAMES Required
When GAD-ACCT-UNIT !=Spaces
GAD-COMPANY->GLN-COMPANY
GAD-ACCT-UNIT->GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
GAD-COMPANY->GLS-COMPANY


File created: Wed Jun 08 20:49:43 2016

Home
Contact Us



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