GLADDRESS FILE
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.8 AC10.1 AC12.2 AC131 AC160 AC17.3
AC17.4 AC170 AC176 AC18.2 AC18.3 AC190
AC195 AC196 AC198 AC210 AC256 AC32.1
AC34.1 AC35.1 AC36.1 AC40.1 AC40.2 AC40.4
AC40.5 AC41.1 AC41.2 AC41.4 AC41.5 AC41.7
AC42.1 AC42.4 AC45.1 AC45.2 AC45.4 AC45.5
AC490 AC494 AC50.1 AC500 AC52.1 AC520
AC530 AC54.1 AC540 AC541 AC542 AC59.1
AC62.1 AC70.1 AC70.2 AC70.4 AC76.1 AC94.4
ACVW.1 AM01.1 AM01.2 AM01.3 AM05.1 AM06.1
AM06.2 AM06.3 AM06.5 AM09.1 AM115 AM118
AM12.1 AM120 AM125 AM135 AM145 AM15.1
AM15.2 AM15.3 AM15.4 AM152 AM154 AM16.1
AM170 AM18.1 AM18.2 AM180 AM185 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 AM220 AM221
AM222 AM223 AM224 AM225 AM230 AM235
AM240 AM241 AM245 AM25.1 AM250 AM251
AM252 AM255 AM260 AM265 AM266 AM270
AM275 AM277 AM278 AM280 AM281 AM282
AM285 AM290 AM292 AM295 AM30.1 AM30.2
AM30.3 AM300 AM310 AM320 AM35.1 AM40.1
AM40.2 AM40.3 AM41.1 AM45.1 AM500 AM51.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 AM93.1 AM95.1 AM95.4
AM95.5 AM95.6 AM96.1 AM97.1 AM98.1 AM99.1
AP00.4 AP01.1 AP05.1 AP05.2 AP05.7 AP05.8
AP115 AP130 AP150 AP151 AP155 AP156
AP161 AP166 AP170 AP175 AP176 AP180
AP181 AP185 AP190 AP191 AP193 AP195
AP200 AP201 AP220 AP255 AP260 AP265
AP275 AP28.1 AP28.2 AP30.2 AP30.4 AP305
AP32.2 AP520 AP55.1 AP55.2 AP56.1 AP81.1
AP90.5 AP91.4 AP95.2 AP95.3 API1.1 API2.1
AR01.1 AR115 AR124 AR129 AR13.1 AR13.2
AR130 AR131 AR135 AR137 AR180 AR190
AR194 AR196 AR199 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR250 AR251 AR252 AR253
AR255 AR256 AR271 AR28.1 AR29.1 AR29.2
AR29.3 AR290 AR30.1 AR30.2 AR30.3 AR30.4
AR30.6 AR30.8 AR31.5 AR31.6 AR35.1 AR35.2
AR37.1 AR37.2 AR37.3 AR37.4 AR37.5 AR37.6
AR37.7 AR42.1 AR42.2 AR42.6 AR42.7 AR43.1
AR44.3 AR48.3 AR502 AR504 AR560 AR570
AR575 AR580 AR75.1 AR82.1 BL00.1 BL123
BL199 BN00.1 BN00.2 BN15.1 BN150 BN190
BN20.1 BN80.1 BN81.1 BN81.2 BR121 BR41.1
BRIP.1 CB00.3 CB01.2 CB03.1 CB03.2 CB05.1
CB06.1 CB06.2 CB10.1 CB10.3 CB15.1 CB15.2
CB175 CB180 CB185 CB190 CB191 CB195
CB20.1 CB210 CB215 CB220 CB221 CB260
CB30.1 CB500 CB80.1 CB90.2 CB90.5 DT150
DT155 DT160 DT165 DT166 DT170 DT180
DT181 DT185 DT190 DT30.1 DT30.2 DT40.1
DT45.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT85.1 DT85.2 DT90.1 DT92.1 EE135
EE175 EE20.1 EE20.2 EE20.3 EE20.4 EE220
EE230 EE275 EE35.1 EE35.2 EE520 CA00.1
CA00.2 CA05.1 CA10.1 CA10.2 CA10.4 CA10.5
CA10.6 CA10.7 CA110 CA15.1 CA15.2 CA190
CA195 CA199 CA210 CA215 CA240 CA290
FB10.1 FB100 FB101 FB120 FB121 FB122
FB141 FB195 FB20.1 FB20.2 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB210 FB220 FB225
FB230 FB231 FB25.1 FB295 FB30.1 FB31.1
FB65.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL120 GL122 GL135 GL141 GL145
GL146 GL165 GL167 GL170 GL179 GL190
GL191 GL195 GL196 GL199 GL230 GL235
GL238 GL240 GL241 GL243 GL245 GL250
GL267 GL270 GL275 GL281 GL290 GL291
GL292 GL293 GL294 GL295 GL296 GL30.1
GL30.2 GL300 GL310 GL320 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 GL90.1 GL90.2 GL90.3
GL90.4 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 RW100
RW20.5 RW20.6 RW60.1 RW60.4 RW70.1 HR00.1
HR01.1 HR200 DR100 IC125 IC130 IC134
IC135 IC141 IC142 IC150 IC151 IC152
IC175 IC199 IC21.1 IC21.2 IC22.1 IC22.2
IC224 IC227 IC228 IC233 IC234 IC240
IC280 IC283 IC500 IC522 IC523 IC525
IC526 IC527 IC83.1 PC521 CU03.1 CU161
CU20.3 CU20.4 CU203 CU220 CU261 CU300
CU61.2 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 GL312 GL313 GL342 GL38.2 GL42.1
GL61.1 GL62.1 GLAV.1 GLCV.1 GLVW.1 IFCU.1
IFGT.1 IFOS.1 IFTR.1 MX135 MA01.1 MA05.3
MA05.6 MA126 MA205 MA231 MA310 MA63.1
MA65.1 MA68.1 PO01.1 PO135 PO136 PO199
PO26.1 POA2.4 POI7.1 POIH.1 POIJ.1 PR05.1
PR05.3 PR128 PR131 PR132 PR134 PR136
PR137 PR195 PR197 PR198 PR26.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 PR36.1
PR37.1 PR38.1 PR45.1 PR47.1 PR514 PR530
PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ01.1
RQ11.1 RQ12.1 RQ13.1 RQ235 SLVW.1 TA195
UK120 IN120 IN20.1 TX00.1 TX04.1 TX100
TX40.1 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
UPDATED BY
GL110 GL10.1 GL124 GL20.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAD-COMPANY Numeric 4 GL10.1 GL110
Company The company number as defined in GL00.1 GL124 GL20.1
(Company).
GAD-ACCT-UNIT Alpha 15 GL124 GL20.1
Accounting Unit The valid Lawson General Ledger
accounting in GLNAMES.
GAD-NAME Alpha 30 (Lower Case) GL10.1 GL124
Name Displays the company description. GL20.1
GAD-ADDR1 Alpha 30 (Lower Case) GL10.1 GL124
Address 1 This field contains the first line of GL20.1
address information.
GAD-ADDR2 Alpha 30 (Lower Case) GL10.1 GL124
Address 2 This field contains the second line of GL20.1
address information.
GAD-ADDR3 Alpha 30 (Lower Case) GL10.1 GL124
Address 3 This field contains the third line of GL20.1
address information.
GAD-ADDR4 Alpha 30 (Lower Case) GL10.1 GL124
Address 4 This field contains the fourth line of GL20.1
address information.
GAD-ADDR5 Alpha 18 (Lower Case) GL10.1 GL124
City or Address 5 This field contains the fifth line of GL20.1
address information. In the United
States, define the city.
GAD-STATE-PROV Alpha 2 GL10.1 GL124
State or Province The state or province. GL20.1
GAD-POSTAL-CODE Alpha 10 (Lower Case) GL10.1 GL124
Postal Code This field contains the postal code. GL20.1
GAD-COUNTY Alpha 25 (Lower Case) GL10.1 GL124
County The county for the company address. GL20.1
GAD-COUNTRY Alpha 30 (Lower Case) GL10.1 GL124
Country or Other This field contains the country of the GL20.1
address, or it can be used for
additional information such as an
attention name.
GAD-ADDR-CONTACT Alpha 30 (Lower Case) GL10.1 GL124
Contact This is the name of the main contact. GL20.1
GAD-PHONE-COUNTRY Alpha 6 GL10.1 GL124
Telephone Country This field contains the prefix of the GL20.1
Code telephone number. For example, the
country or city code.
GAD-PHONE-NUMBER Alpha 15 GL10.1 GL124
Telephone Number Contains the telephone number, GL20.1
including area code.
GAD-PHONE-EXT Alpha 5 GL10.1 GL124
Telephone Extension This field contains the telephone GL20.1
extension number.
GAD-FAX-COUNTRY Alpha 6 GL10.1 GL124
Fax Country This field contains the prefix of the GL20.1
fax number. For example, the country or
city code.
GAD-FAX-NUMBER Alpha 15 GL10.1 GL124
Fax Number This field contains the fax number. GL20.1
GAD-FAX-EXT Alpha 5 GL10.1 GL124
Fax Extension This field contains the fax number GL20.1
extension.
GAD-TELEX-NUMBER Alpha 15 GL10.1 GL124
Telex Number This is the telex number. GL20.1
GAD-OPT-FIELD1 Alpha 15 (Lower Case) GL10.1 GL124
Optional Field 1 This field lets you enter any GL20.1
additional information you would like to
appear on the address.
GAD-OPT-FIELD2 Alpha 15 (Lower Case) GL10.1 GL124
Optional Field 2 This field lets you enter any additional GL20.1
information you would like to appear on
the address.
GAD-OPT-FIELD3 Alpha 30 (Lower Case) GL10.1 GL124
Optional Field 3 This field lets you enter any additional GL20.1
information you would like to appear on
the address.
GAD-COUNTRY-CODE Alpha 2 GL10.1 GL124
Country Code The country code. Required for VAT and GL20.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
GLADDRESS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GADSET1 COMPANY This path accesses the accounting unit AC03.1 AC03.2
ACCT-UNIT via company. AC03.3 AC03.4
AC03.5 AC03.6
AC03.8 AC10.1
AC12.2 AC131
AC160 AC17.3
AC17.4 AC170
AC176 AC18.2
AC18.3 AC190
AC195 AC196
AC198 AC210
AC256 AC32.1
AC34.1 AC35.1
AC36.1 AC40.1
AC40.2 AC40.4
...
GLADDRESS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
