|
|
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 AC15.1 AC15.4 AC160 AC170
AC176 AC195 AC196 AC20.1 AC20.2 AC20.3
AC20.4 AC210 AC256 AC30.2 AC30.3 AC32.1
AC40.1 AC41.1 AC42.1 AC45.1 AC45.2 AC50.1
AC500 AC52.1 AC520 AC530 AC54.1 AC540
AC76.1 AC87.1 AC950 AC952 ACVW.1 AM01.1
AM01.2 AM01.3 AM05.1 AM06.1 AM06.2 AM09.1
AM115 AM118 AM12.1 AM120 AM125 AM135
AM145 AM15.1 AM15.2 AM15.3 AM15.4 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 AM212 AM220
AM221 AM222 AM223 AM224 AM225 AM230
AM235 AM240 AM245 AM250 AM255 AM260
AM265 AM270 AM275 AM277 AM280 AM285
AM290 AM292 AM295 AM30.1 AM30.2 AM30.3
AM300 AM310 AM35.1 AM40.1 AM40.2 AM40.3
AM45.1 AM500 AM580 AM60.1 AM70.1 AM75.1
AM80.1 AM85.1 AM90.1 AM95.1 AM951 AM952
AM953 AM956 AM96.1 AM97.1 AM98.1 AM99.1
AP00.4 AP01.1 AP05.1 AP05.2 AP05.7 AP05.8
AP125 AP126 AP150 AP151 AP155 AP156
AP157 AP166 AP170 AP175 AP180 AP181
AP185 AP190 AP191 AP193 AP195 AP20.1
AP20.2 AP20.5 AP20.6 AP20.7 AP200 AP201
AP225 AP226 AP23.1 AP25.1 AP25.2 AP255
AP26.1 AP260 AP265 AP275 AP28.1 AP28.2
AP30.2 AP30.4 AP32.2 AP520 AP55.1 AP55.2
AP56.1 AP81.1 AP90.5 AP90.6 AP90.7 AP91.4
AP95.2 AP95.3 AP981 AR01.1 AR115 AR124
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 AR502 AR504 AR560
AR570 AR575 AR580 AR75.1 AR82.1 AR973
BL00.1 BL122 BL123 BL199 BL92.1 BN150
BN190 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 CB733 CB80.1 CB90.2 CB90.5
CB980 CXA2.1 CXA3.1 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.7 CA10.8
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 GL240 GL241
GL243 GL245 GL250 GL267 GL270 GL275
GL281 GL290 GL291 GL292 GL293 GL294
GL295 GL296 GL30.1 GL30.2 GL300 GL320
GL324 GL325 GL326 GL327 GL328 GL330
GL36.1 GL40.1 GL40.2 GL40.3 GL40.4 GL40.5
GL40.6 GL40.7 GL40.8 GL40.9 GL41.1 GL41.3
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.6 GL70.7 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 CU20.3 CU20.4 CU203 CU220
CU300 GL01.1 GL01.2 GL03.6 GL08.1 GL08.2
GL121 GL161 GL162 GL198 GL210 GL220
GL221 GL222 GL25.1 GL261 GL311 GL312
GL313 GL342 GL38.2 GL42.1 GL61.1 GL62.1
GL87.1 GL88.1 GLCV.1 GLVW.1 IFCR.1 IFGT.1
IFTR.1 IN120 IN20.1 MA00.1 MA40.1 MA40.2
MA41.1 MA41.2 MA41.4 MA41.5 MA41.6 MA43.1
MA43.2 MA43.3 MA43.4 MA52.1 MA520 MA530
MA540 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 OE113 OE114 OE129 OE130
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE510 OE810 OE830
OE920 OE950 PBIP.1 PO100 PO121 PO135
PO180 PO199 PO20.1 PO21.1 PO21.2 PO21.3
PO21.5 PO21.6 PO22.1 PO22.2 PO22.3 PO25.1
PO25.2 PO25.4 PO26.1 PO28.6 PO30.1 PO31.1
PO32.1 PO33.1 PO34.1 PO35.1 PO530 PO821
PO990 POA2.1 POA3.1 PR05.1 PR05.3 PR128
PR131 PR132 PR134 PR136 PR137 PR140
PR150 PR195 PR199 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 PR514 PR530 PR80.1 PR82.1
PR85.1 PRSA.1 UK102 UK330 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1 RQ20.3
RQ20.4 RQ235 RQ35.1 RQ500 RQ990 SL40.4
TA195 UK120 TX00.1 TX04.1 TX225 TX40.1
WH130 WH132 WH190 WH20.2 WH20.7 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140 WO293 WOA1.1 WOA2.1 WOA3.1
UPDATED BY
GL110 GL10.1 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 GL20.1
(Company).
GAD-ACCT-UNIT Alpha 15 GL20.1
Accounting Unit The valid Lawson General Ledger
accounting in GLNAMES.
GAD-NAME Alpha 30 (Lower Case) GL10.1 GL20.1
Address Name Contains the company description.
GAD-ADDR1 Alpha 30 (Lower Case) GL10.1 GL20.1
Address 1 This field contains the first line of
address information.
GAD-ADDR2 Alpha 30 (Lower Case) GL10.1 GL20.1
Address 2 This field contains the second line of
address information.
GAD-ADDR3 Alpha 30 (Lower Case) GL10.1 GL20.1
Address 3 This field contains the third line of
address information.
GAD-ADDR4 Alpha 30 (Lower Case) GL10.1 GL20.1
Address 4 This field contains the fourth line of
address information.
GAD-ADDR5 Alpha 18 (Lower Case) GL10.1 GL20.1
City Or Address 5 This field contains the fifth line of
address information. In the United
States, define the city.
GAD-STATE-PROV Alpha 2 GL10.1 GL20.1
State or Providance The state or province.
GAD-POSTAL-CODE Alpha 10 (Lower Case) GL10.1 GL20.1
Zip Code This field contains the postal code.
GAD-COUNTY Alpha 25 GL20.1
County The county for the company address.
GAD-COUNTRY Alpha 30 (Lower Case) GL10.1 GL20.1
Country This field contains the country of the
address, or it can be used for
additional information such as an
attention name.
GAD-ADDR-CONTACT Alpha 30 (Lower Case) GL10.1 GL20.1
Contact or E-mail This is the name of the main contact.
GAD-PHONE-COUNTRY Alpha 6 GL10.1 GL20.1
Telephone Country This field contains the prefix of the
Code telephone number. For example, the
country or city code.
GAD-PHONE-NUMBER Alpha 15 GL10.1 GL20.1
Telephone Number Contains the telephone number,
including area code.
GAD-PHONE-EXT Alpha 5 GL10.1 GL20.1
Telephone Extension This field contains the telephone
extension number.
GAD-FAX-COUNTRY Alpha 6 GL10.1 GL20.1
Fax Country Code This field contains the prefix of the
fax number. For example, the country or
city code.
GAD-FAX-NUMBER Alpha 15 GL10.1 GL20.1
Fax Number This field contains the fax number.
GAD-FAX-EXT Alpha 5 GL10.1 GL20.1
Fax Number Extension This field contains the fax number
extension.
GAD-TELEX-NUMBER Alpha 15 GL10.1 GL20.1
Telex Number This is the telex number.
GAD-OPT-FIELD1 Alpha 15 (Lower Case) GL10.1 GL20.1
User Field This field lets you enter any
additional information you would like to
appear on the address.
GAD-OPT-FIELD2 Alpha 15 (Lower Case) GL10.1 GL20.1
User Field This field lets you enter any additional
information you would like to appear on
the address.
GAD-OPT-FIELD3 Alpha 30 (Lower Case) GL10.1 GL20.1
User Field This field lets you enter any additional
information you would like to appear on
the address.
GAD-ADDR-TYPE Alpha 1 GL10.1
Address Type This field identifies the type or
address you are defining.
GAD-VAT-REG-CTRY Alpha 2 GL10.1
VAT Registration The country component of the VAT
Country Registration Number. This field,
together with the Registration Number
for the company on the tax transaction.
GAD-VAT-REG-NBR Alpha 12 GL10.1
VAT Registration The number component of the VAT
Number Registration Number. This field together
with the Registration Country field make
up the VAT Registration Number.
GAD-VAT-NBR Derived
VAT Number The concatenation of the VAT-REG-CTRY
and VAT-REG-NBR fields, used as VAT
reporting ID.
GAD-BRANCH-ID Alpha 3 GL10.1
Branch ID The company's branch ID, if required
for Intrastate reporting.
GAD-COUNTRY-CODE Alpha 2 GL10.1 GL20.1
Country Code The country code. Required for VAT and
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
ADDR-TYPE AC03.5 AC03.6
AC03.8 AC10.1
AC15.1 AC15.4
AC160 AC170
AC176 AC195
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC210
AC256 AC30.2
AC30.3 AC32.1
AC40.1 AC41.1
AC42.1 AC45.1
AC45.2 AC50.1
...
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
|