I am involved in a project using Progress V9.x and will need some help.
Let me start by saying thank you for reading this.
Over view:
Progress V9.x running on IBM SCO system. The applaction is a large accounting system used in the Home Owners Association management world. The progress script code dates back to 1990 and up to 2003. I have placed the progress *.qc file contents at the end of this email.
Objective:
Integrate mySQL data into the progress screen data. Example: The screen shows the record of a user. First Name, Last Name, etc. I need to add a email field from mySQL data base.
How it is done now.
1. Progress exports all user data from the tables to tab delimited flat files.
2. We run an AWK script to create a key field on some of the table data.
3. We import the flat files into a remote mySQL data base.
4. The user adds their email to the data and updates there phone #.
5. We export the modified records to a tab delimed file.
6. Progress imports flat file. (THIS IS NOT BUILT YET)
How we think/would like it to be Done:
1. Progress exports all the data as it is done now BUT adds to the scripts the key field we build with AWK, and adds the mySQL import statements that are needed to import the data into a mySQL DB.
2. mySQL DB would be local to Progress DB.
3. The user then would be remote for the mySQL.
4. Display the new email or phone # from the mySQL DB within the Progress Screen scripts.
4a. The progress DB and the accounting scripts seem very unstable and that is why we are trying to stay away from writing to the progress DB.
4b. If writing to the Progress DB can be done in a way that if all go's worng we can fix it that would work.
5. The mySQL DB would be the interface between the user and the Progress DB.
I would appreate any input that you would have for this project.
***********************************************************************************
access.qc
/*
# PROGRESS RESULTS system administrator configuration file
config= sysadmin
version= 1.3E
goodbye= "return"
language= "eng"
product= "PROGRESS RESULTS"
signon= "prores/u-logo.p"
database1= "access" "PROGRESS" 729766511427
fastload= "res00100.p"
#
message= "Loading module settings"
module-query= "*"
module-report= "*"
module-label= "*"
module-data= "*"
module-user= "*"
module-admin= "*"
#
message= "Loading color settings"
color-co80= "BLACK/CYAN" "WHITE/RED" "GRAY/RED" "RED/GRAY" "BLUE/GRAY" "GRAY/BLUE"
#
message= "Loading printer setup"
printer1= "TERMINAL" "" "*" "page" 80 "" "" "" "" ""
printer2= "FILE" "" "*" "file" 80 "" "" "" "" ""
printer3= "PRINTER" "PRINTER" "*" "to" 80 "" "" "" "" ""
printer4= "Envelope printer" "lp -s -c -dp1" "*" "thru" 80 "27,38,108,56,49,97,51,104,49,79,,,,,,,,,,,,,," "" "" "" ""
printer5= "HP22200dn" "lp -s -c -dhp2200dn" "*" "thru" 80 "27,38,107,50,83,,,,,,,,,,,,,,,,,,," "" "" "" ""
printer6= "HP2200dn Landscape" "lp -s -c -dhp2200dn" "*" "thru" 100 "27,38,107,50,83,27,38,108,49,79,,,,,,,,,,,,,," "" "" "" ""
#
message= "Loading auto-select field list for mailing labels"
label-name= "name,*name*,contact,*contact*"
label-addr1= "*street,*addr,*address,*address*1"
label-addr2= "*po*box*,*address*2"
label-addr3= "*address*3"
label-city= "city,*city*"
label-state= "st,state,*state*"
label-zip= "zip,*zip*"
label-zip+4= "zip*4"
label-csz= "*csz*,*city*st*z*"
label-country= "*country*"
#
message= "Loading permissions list for query functions"
query-next= "*"
query-prev= "*"
query-first= "*"
query-last= "*"
query-add= "!*"
query-update= "!*"
query-copy= "!*"
query-delete= "!*"
query-view= "*"
query-browse= "*"
query-join= "*"
query-query= "*"
query-where= "*"
query-total= "*"
query-order= "*"
query-module= "*"
query-info= "*"
query-user= "*"
query-help= "*"
query-exit= "*"
#
message= "Loading user option information"
user-program= ""
user-export= "" ""
user-query= "u-browse.i"
#
message= "Loading system report defaults"
left-margin= 1
page-size= 66
column-spacing= 1
line-spacing= 1
top-margin= 1
before-body= 0
after-body= 0
first-only= "" "" ""
last-only= "" "" ""
top-left= "" "" ""
top-center= "" "" ""
top-right= "" "" ""
bottom-left= "" "" ""
bottom-center= "" "" ""
bottom-right= "" "" ""
#
message= "Loading list of viewable files"
#
message= "Loading list of relations"
join1= "access.ap-1099" "access.ap-vend" "OF access.ap-1099"
join2= "access.ap-1099" "access.gl-ent" "OF access.ap-1099"
join3= "access.ap-chk" "access.ap-chkv" "OF access.ap-chk"
join4= "access.ap-chk" "access.ap-chkvd" "OF access.ap-chk"
join5= "access.ap-chk" "access.ap-vend" "OF access.ap-chk"
join6= "access.ap-chk" "access.gl-bank" "OF access.ap-chk"
join7= "access.ap-chkv" "access.ap-chk" "OF access.ap-chkv"
join8= "access.ap-chkv" "access.ap-chkvd" "OF access.ap-chkv"
join9= "access.ap-chkv" "access.ap-vch" "WHERE access.ap-vch.voucher = access.ap-chkv.voucher"
join10= "access.ap-chkv" "access.gl-bank" "OF access.ap-chkv"
join11= "access.ap-chkvd" "access.ap-chk" "OF access.ap-chkvd"
join12= "access.ap-chkvd" "access.ap-chkv" "OF access.ap-chkvd"
join13= "access.ap-chkvd" "access.ap-vch" "OF access.ap-chkvd"
join14= "access.ap-chkvd" "access.ap-vchd" "OF access.ap-chkvd"
join15= "access.ap-chkvd" "access.gl-acct" "OF access.ap-chkvd"
join16= "access.ap-chkvd" "access.gl-bank" "OF access.ap-chkvd"
join17= "access.ap-chkvd" "access.gl-ent" "OF access.ap-chkvd"
join18= "access.ap-cra" "access.ap-crad" "OF access.ap-cra"
join19= "access.ap-cra" "access.ap-cred" "OF access.ap-cra"
join20= "access.ap-cra" "access.ap-vch" "OF access.ap-cra"
join21= "access.ap-crad" "access.ap-cra" "OF access.ap-crad"
join22= "access.ap-crad" "access.ap-cred" "OF access.ap-crad"
join23= "access.ap-crad" "access.ap-vch" "OF access.ap-crad"
join24= "access.ap-crad" "access.ap-vchd" "OF access.ap-crad"
join25= "access.ap-cred" "access.ap-cra" "OF access.ap-cred"
join26= "access.ap-cred" "access.ap-crad" "OF access.ap-cred"
join27= "access.ap-cred" "access.ap-credd" "OF access.ap-cred"
join28= "access.ap-cred" "access.ap-vend" "OF access.ap-cred"
join29= "access.ap-cred" "access.gl-acct" "OF access.ap-cred"
join30= "access.ap-cred" "access.gl-ent" "OF access.ap-cred"
join31= "access.ap-credd" "access.ap-cred" "OF access.ap-credd"
join32= "access.ap-credd" "access.gl-acct" "OF access.ap-credd"
join33= "access.ap-credd" "access.gl-ent" "OF access.ap-credd"
join34= "access.ap-rvch" "access.ap-rvchd" "OF access.ap-rvch"
join35= "access.ap-rvch" "access.ap-terms" "OF access.ap-rvch"
join36= "access.ap-rvch" "access.ap-vend" "OF access.ap-rvch"
join37= "access.ap-rvch" "access.gl-acct" "OF access.ap-rvch"
join38= "access.ap-rvch" "access.gl-ent" "OF access.ap-rvch"
join39= "access.ap-rvchd" "access.ap-rvch" "OF access.ap-rvchd"
join40= "access.ap-rvchd" "access.gl-acct" "OF access.ap-rvchd"
join41= "access.ap-rvchd" "access.gl-ent" "OF access.ap-rvchd"
join42= "access.ap-type" "access.ap-vend" "OF access.ap-type"
join43= "access.ap-vch" "access.ap-chk" "OF access.ap-vch"
join44= "access.ap-vch" "access.ap-chkv" "WHERE .where ap-chkv.voucher = ap-vch.voucher"
join45= "access.ap-vch" "access.ap-chkvd" "OF access.ap-vch"
join46= "access.ap-vch" "access.ap-cra" "OF access.ap-vch"
join47= "access.ap-vch" "access.ap-crad" "OF access.ap-vch"
join48= "access.ap-vch" "access.ap-terms" "OF access.ap-vch"
join49= "access.ap-vch" "access.ap-vchd" "OF access.ap-vch"
join50= "access.ap-vch" "access.ap-vend" "OF access.ap-vch"
join51= "access.ap-vch" "access.gl-acct" "OF access.ap-vch"
join52= "access.ap-vch" "access.gl-bank" "OF access.ap-vch"
join53= "access.ap-vch" "access.gl-ent" "OF access.ap-vch"
join54= "access.ap-vchd" "access.ap-chkvd" "OF access.ap-vchd"
join55= "access.ap-vchd" "access.ap-crad" "OF access.ap-vchd"
join56= "access.ap-vchd" "access.ap-vch" "OF access.ap-vchd"
join57= "access.ap-vchd" "access.gl-acct" "OF access.ap-vchd"
join58= "access.ap-vchd" "access.gl-ent" "OF access.ap-vchd"
join59= "access.ap-vend" "access.ap-chk" "OF access.ap-vend"
join60= "access.ap-vend" "access.ap-cred" "OF access.ap-vend"
join61= "access.ap-vend" "access.ap-rvch" "OF access.ap-vend"
join62= "access.ap-vend" "access.ap-terms" "OF access.ap-vend"
join63= "access.ap-vend" "access.ap-type" "OF access.ap-vend"
join64= "access.ap-vend" "access.ap-vch" "OF access.ap-vend"
join65= "access.cm-adjcd" "access.cm-chgcd" "OF access.cm-adjcd"
join66= "access.cm-batch" "access.cm-cash" "OF access.cm-batch"
join67= "access.cm-batch" "access.cm-chg" "OF access.cm-batch"
join68= "access.cm-batch" "access.cm-cred" "OF access.cm-batch"
join69= "access.cm-batch" "access.cm-vac" "OF access.cm-batch"
join70= "access.cm-batch" "access.gl-bank" "OF access.cm-batch"
join71= "access.cm-bldg" "access.cm-bldgd" "OF access.cm-bldg"
join72= "access.cm-bldg" "access.cm-bldgi" "OF access.cm-bldg"
join73= "access.cm-bldg" "access.cm-bldgt" "OF access.cm-bldg"
join74= "access.cm-bldg" "access.cm-note" "OF access.cm-bldg"
join75= "access.cm-bldg" "access.cm-noted" "OF access.cm-bldg"
join76= "access.cm-bldg" "access.cm-notep" "OF access.cm-bldg"
join77= "access.cm-bldg" "access.cm-opt" "OF access.cm-bldg"
join78= "access.cm-bldg" "access.cm-ten" "OF access.cm-bldg"
join79= "access.cm-bldg" "access.cm-unit" "OF access.cm-bldg"
join80= "access.cm-bldg" "access.gl-ent" "OF access.cm-bldg"
join81= "access.cm-bldg" "access.la-comm" "OF access.cm-bldg"
join82= "access.cm-bldg" "access.la-commd" "OF access.cm-bldg"
join83= "access.cm-bldg" "access.la-cpi" "OF access.cm-bldg"
join84= "access.cm-bldg" "access.la-cpic" "OF access.cm-bldg"
join85= "access.cm-bldg" "access.la-esc" "OF access.cm-bldg"
join86= "access.cm-bldg" "access.la-escc" "OF access.cm-bldg"
join87= "access.cm-bldg" "access.la-exp" "OF access.cm-bldg"
join88= "access.cm-bldg" "access.la-perc" "OF access.cm-bldg"
join89= "access.cm-bldg" "access.la-percd" "OF access.cm-bldg"
join90= "access.cm-bldg" "access.la-sale" "OF access.cm-bldg"
join91= "access.cm-bldg" "access.la-salea" "OF access.cm-bldg"
join92= "access.cm-bldg" "access.la-spr" "OF access.cm-bldg"
join93= "access.cm-bldg" "access.la-sprd" "OF access.cm-bldg"
join94= "access.cm-bldgd" "access.cm-bldg" "OF access.cm-bldgd"
join95= "access.cm-bldgi" "access.cm-bldg" "OF access.cm-bldgi"
join96= "access.cm-bldgt" "access.cm-bldg" "OF access.cm-bldgt"
join97= "access.cm-cash" "access.cm-batch" "OF access.cm-cash"
join98= "access.cm-cash" "access.cm-bldg" "OF access.cm-cash"
join99= "access.cm-cash" "access.cm-cashd" "OF access.cm-cash"
join100= "access.cm-cash" "access.cm-dep" "OF access.cm-cash"
join101= "access.cm-cash" "access.cm-depcd" "OF access.cm-cash"
join102= "access.cm-cash" "access.cm-prep" "OF access.cm-cash"
join103= "access.cm-cash" "access.cm-ten" "OF access.cm-cash"
join104= "access.cm-cash" "access.cm-unit" "OF access.cm-cash"
join105= "access.cm-cash" "access.gl-acct" "OF access.cm-cash"
join106= "access.cm-cashd" "access.cm-cash" "OF access.cm-cashd"
join107= "access.cm-cashd" "access.cm-chg" "OF access.cm-cashd"
join108= "access.cm-chg" "access.cm-adjcd" "OF access.cm-chg"
join109= "access.cm-chg" "access.cm-batch" "OF access.cm-chg"
join110= "access.cm-chg" "access.cm-bldg" "OF access.cm-chg"
join111= "access.cm-chg" "access.cm-cashd" "OF access.cm-chg"
join112= "access.cm-chg" "access.cm-chgcd" "OF access.cm-chg"
join113= "access.cm-chg" "access.cm-credd" "OF access.cm-chg"
join114= "access.cm-chg" "access.cm-ten" "OF access.cm-chg"
join115= "access.cm-chg" "access.cm-unit" "OF access.cm-chg"
join116= "access.cm-chgcd" "access.cm-adjcd" "OF access.cm-chgcd"
join117= "access.cm-cred" "access.cm-adjcd" "OF access.cm-cred"
join118= "access.cm-cred" "access.cm-batch" "OF access.cm-cred"
join119= "access.cm-cred" "access.cm-bldg" "OF access.cm-cred"
join120= "access.cm-cred" "access.cm-chgcd" "OF access.cm-cred"
join121= "access.cm-cred" "access.cm-credd" "OF access.cm-cred"
join122= "access.cm-cred" "access.cm-prepd" "OF access.cm-cred"
join123= "access.cm-cred" "access.cm-ten" "OF access.cm-cred"
join124= "access.cm-cred" "access.cm-unit" "OF access.cm-cred"
join125= "access.cm-credd" "access.cm-chg" "OF access.cm-credd"
join126= "access.cm-credd" "access.cm-cred" "OF access.cm-credd"
join127= "access.cm-credh" "access.cm-bldg" "OF access.cm-credh"
join128= "access.cm-credh" "access.cm-ten" "OF access.cm-credh"
join129= "access.cm-credh" "access.cm-unit" "OF access.cm-credh"
join130= "access.cm-dep" "access.cm-bldg" "OF access.cm-dep"
join131= "access.cm-dep" "access.cm-cash" "OF access.cm-dep"
join132= "access.cm-dep" "access.cm-depcd" "OF access.cm-dep"
join133= "access.cm-dep" "access.cm-depd" "OF access.cm-dep"
join134= "access.cm-dep" "access.cm-ten" "OF access.cm-dep"
join135= "access.cm-dep" "access.cm-unit" "OF access.cm-dep"
join136= "access.cm-depd" "access.cm-batch" "OF access.cm-depd"
join137= "access.cm-depd" "access.cm-dep" "OF access.cm-depd"
join138= "access.cm-depd" "access.gl-acct" "OF access.cm-depd"
join139= "access.cm-note" "access.cm-bldg" "OF access.cm-note"
join140= "access.cm-note" "access.cm-ten" "OF access.cm-note"
join141= "access.cm-note" "access.cm-tend" "OF access.cm-note"
join142= "access.cm-note" "access.cm-unit" "OF access.cm-note"
join143= "access.cm-notep" "access.cm-bldg" "OF access.cm-notep"
join144= "access.cm-notep" "access.cm-ten" "OF access.cm-notep"
join145= "access.cm-notep" "access.cm-unit" "OF access.cm-notep"
join146= "access.cm-opt" "access.cm-bldg" "OF access.cm-opt"
join147= "access.cm-prep" "access.cm-adjcd" "OF access.cm-prep"
join148= "access.cm-prep" "access.cm-bldg" "OF access.cm-prep"
join149= "access.cm-prep" "access.cm-cash" "OF access.cm-prep"
join150= "access.cm-prep" "access.cm-chgcd" "OF access.cm-prep"
join151= "access.cm-prep" "access.cm-prepd" "OF access.cm-prep"
join152= "access.cm-prep" "access.cm-ten" "OF access.cm-prep"
join153= "access.cm-prep" "access.cm-unit" "OF access.cm-prep"
join154= "access.cm-prepd" "access.cm-batch" "OF access.cm-prepd"
join155= "access.cm-prepd" "access.cm-cred" "OF access.cm-prepd"
join156= "access.cm-prepd" "access.cm-prep" "OF access.cm-prepd"
join157= "access.cm-rechg" "access.cm-adjcd" "OF access.cm-rechg"
join158= "access.cm-rechg" "access.cm-bldg" "OF access.cm-rechg"
join159= "access.cm-rechg" "access.cm-chgcd" "OF access.cm-rechg"
join160= "access.cm-rechg" "access.cm-stepd" "OF access.cm-rechg"
join161= "access.cm-rechg" "access.cm-ten" "OF access.cm-rechg"
join162= "access.cm-rechg" "access.cm-unit" "OF access.cm-rechg"
join163= "access.cm-rechg" "access.la-commd" "OF access.cm-rechg"
join164= "access.cm-stepd" "access.cm-chgcd" "OF access.cm-stepd"
join165= "access.cm-stepd" "access.cm-rechg" "OF access.cm-stepd"
join166= "access.cm-ten" "access.cm-bldg" "OF access.cm-ten"
join167= "access.cm-ten" "access.cm-cash" "OF access.cm-ten"
join168= "access.cm-ten" "access.cm-chg" "OF access.cm-ten"
join169= "access.cm-ten" "access.cm-cred" "OF access.cm-ten"
join170= "access.cm-ten" "access.cm-credh" "OF access.cm-ten"
join171= "access.cm-ten" "access.cm-dep" "OF access.cm-ten"
join172= "access.cm-ten" "access.cm-note" "OF access.cm-ten"
join173= "access.cm-ten" "access.cm-noted" "OF access.cm-ten"
join174= "access.cm-ten" "access.cm-notep" "OF access.cm-ten"
join175= "access.cm-ten" "access.cm-opt" "OF access.cm-ten"
join176= "access.cm-ten" "access.cm-prep" "OF access.cm-ten"
join177= "access.cm-ten" "access.cm-rechg" "OF access.cm-ten"
join178= "access.cm-ten" "access.cm-stepd" "OF access.cm-ten"
join179= "access.cm-ten" "access.cm-tenc" "OF access.cm-ten"
join180= "access.cm-ten" "access.cm-tend" "OF access.cm-ten"
join181= "access.cm-ten" "access.cm-tent" "OF access.cm-ten"
join182= "access.cm-ten" "access.cm-unit" "OF access.cm-ten"
join183= "access.cm-ten" "access.cm-unitm" "OF access.cm-ten"
join184= "access.cm-ten" "access.la-comm" "OF access.cm-ten"
join185= "access.cm-ten" "access.la-commd" "OF access.cm-ten"
join186= "access.cm-ten" "access.la-cpi" "OF access.cm-ten"
join187= "access.cm-ten" "access.la-cpic" "OF access.cm-ten"
join188= "access.cm-ten" "access.la-esc" "OF access.cm-ten"
join189= "access.cm-ten" "access.la-escc" "OF access.cm-ten"
join190= "access.cm-ten" "access.la-perc" "OF access.cm-ten"
join191= "access.cm-ten" "access.la-percd" "OF access.cm-ten"
join192= "access.cm-ten" "access.la-sale" "OF access.cm-ten"
join193= "access.cm-ten" "access.la-salea" "OF access.cm-ten"
join194= "access.cm-ten" "access.la-spr" "OF access.cm-ten"
join195= "access.cm-ten" "access.la-sprd" "OF access.cm-ten"
join196= "access.cm-tenc" "access.cm-bldg" "OF access.cm-tenc"
join197= "access.cm-tenc" "access.cm-ten" "OF access.cm-tenc"
join198= "access.cm-tenc" "access.cm-unit" "OF access.cm-tenc"
join199= "access.cm-tend" "access.cm-bldg" "OF access.cm-tend"
join200= "access.cm-tend" "access.cm-ten" "OF access.cm-tend"
join201= "access.cm-tent" "access.cm-ten" "OF access.cm-tent"
join202= "access.cm-tent" "access.cm-tklr" "OF access.cm-tent"
join203= "access.cm-tklr" "access.cm-bldgt" "OF access.cm-tklr"
join204= "access.cm-tklr" "access.cm-tent" "OF access.cm-tklr"
join205= "access.cm-tklr" "access.cm-unitt" "OF access.cm-tklr"
join206= "access.cm-unit" "access.cm-bldg" "OF access.cm-unit"
join207= "access.cm-unit" "access.cm-ten" "OF access.cm-unit"
join208= "access.cm-unit" "access.cm-unitd" "OF access.cm-unit"
join209= "access.cm-unit" "access.cm-unitm" "OF access.cm-unit"
join210= "access.cm-unit" "access.cm-unitt" "OF access.cm-unit"
join211= "access.cm-unitd" "access.cm-chgcd" "OF access.cm-unitd"
join212= "access.cm-unitd" "access.cm-unit" "OF access.cm-unitd"
join213= "access.cm-unitm" "access.cm-bldg" "OF access.cm-unitm"
join214= "access.cm-unitm" "access.cm-mntcd" "OF access.cm-unitm"
join215= "access.cm-unitm" "access.cm-ten" "OF access.cm-unitm"
join216= "access.cm-unitm" "access.cm-unit" "OF access.cm-unitm"
join217= "access.cm-unitt" "access.cm-tklr" "OF access.cm-unitt"
join218= "access.cm-unitt" "access.cm-unit" "OF access.cm-unitt"
join219= "access.cm-vac" "access.cm-adjcd" "OF access.cm-vac"
join220= "access.cm-vac" "access.cm-batch" "OF access.cm-vac"
join221= "access.cm-vac" "access.cm-bldg" "OF access.cm-vac"
join222= "access.cm-vac" "access.cm-chgcd" "OF access.cm-vac"
join223= "access.cm-vac" "access.cm-unit" "OF access.cm-vac"
join224= "access.cw-chg" "access.cw-wo" "OF access.cw-chg"
join225= "access.cw-mnt" "access.cw-schd" "OF access.cw-mnt"
join226= "access.cw-mnt" "access.cw-vac" "OF access.cw-mnt"
join227= "access.cw-mnt" "access.cw-wo" "OF access.cw-mnt"
join228= "access.cw-pers" "access.cw-wo" "OF access.cw-pers"
join229= "access.cw-sat" "access.cw-wo" "OF access.cw-sat"
join230= "access.cw-schd" "access.cw-schdd" "OF access.cw-schd"
join231= "access.cw-vac" "access.cw-vacd" "OF access.cw-vac"
join232= "access.cw-wo" "access.cw-woi" "OF access.cw-wo"
join233= "access.em-inv" "access.em-meter" "OF access.em-inv"
join234= "access.em-inv" "access.em-utype" "OF access.em-inv"
join235= "access.em-meter" "access.em-utype" "OF access.em-meter"
join236= "access.gl-acct" "access.ap-chkvd" "OF access.gl-acct"
join237= "access.gl-acct" "access.ap-cred" "OF access.gl-acct"
join238= "access.gl-acct" "access.ap-credd" "OF access.gl-acct"
join239= "access.gl-acct" "access.ap-rvch" "OF access.gl-acct"
join240= "access.gl-acct" "access.ap-rvchd" "OF access.gl-acct"
join241= "access.gl-acct" "access.ap-vch" "OF access.gl-acct"
join242= "access.gl-acct" "access.ap-vchd" "OF access.gl-acct"
join243= "access.gl-acct" "access.cm-adjcd" "OF access.gl-acct"
join244= "access.gl-acct" "access.cm-cash" "OF access.gl-acct"
join245= "access.gl-acct" "access.cm-depd" "OF access.gl-acct"
join246= "access.gl-acct" "access.gl-altd" "OF access.gl-acct"
join247= "access.gl-acct" "access.gl-bank" "OF access.gl-acct"
join248= "access.gl-acct" "access.gl-begbal" "OF access.gl-acct"
join249= "access.gl-acct" "access.gl-bgt" "OF access.gl-acct"
join250= "access.gl-acct" "access.gl-bgtd" "OF access.gl-acct"
join251= "access.gl-acct" "access.gl-close" "OF access.gl-acct"
join252= "access.gl-acct" "access.gl-fmtd" "OF access.gl-acct"
join253= "access.gl-acct" "access.gl-jrnld" "OF access.gl-acct"
join254= "access.gl-acct" "access.gl-recd" "OF access.gl-acct"
join255= "access.gl-acct" "access.gl-subacc" "OF access.gl-acct"
join256= "access.gl-acct" "access.gl-summ" "OF access.gl-acct"
join257= "access.gl-acct" "access.po-pod" "OF access.gl-acct"
join258= "access.gl-bank" "access.ap-chk" "OF access.gl-bank"
join259= "access.gl-bank" "access.ap-chkv" "OF access.gl-bank"
join260= "access.gl-bank" "access.ap-chkvd" "OF access.gl-bank"
join261= "access.gl-bank" "access.ap-vch" "OF access.gl-bank"
join262= "access.gl-bank" "access.cm-batch" "OF access.gl-bank"
join263= "access.gl-bank" "access.gl-acct" "OF access.gl-bank"
join264= "access.gl-bank" "access.gl-ent" "OF access.gl-bank"
join265= "access.gl-begbal" "access.gl-acct" "OF access.gl-begbal"
join266= "access.gl-begbal" "access.gl-ent" "OF access.gl-begbal"
join267= "access.gl-bgt" "access.gl-acct" "OF access.gl-bgt"
join268= "access.gl-bgt" "access.gl-bgtcd" "OF access.gl-bgt"
join269= "access.gl-bgt" "access.gl-bgtd" "OF access.gl-bgt"
join270= "access.gl-bgt" "access.gl-ent" "OF access.gl-bgt"
join271= "access.gl-bgtcd" "access.gl-bgt" "OF access.gl-bgtcd"
join272= "access.gl-bgtcd" "access.gl-bgtd" "OF access.gl-bgtcd"
join273= "access.gl-bgtd" "access.gl-acct" "OF access.gl-bgtd"
join274= "access.gl-bgtd" "access.gl-bgt" "OF access.gl-bgtd"
join275= "access.gl-bgtd" "access.gl-bgtcd" "OF access.gl-bgtd"
join276= "access.gl-bgtd" "access.gl-ent" "OF access.gl-bgtd"
join277= "access.gl-close" "access.gl-acct" "OF access.gl-close"
join278= "access.gl-close" "access.gl-begbal" "OF access.gl-close"
join279= "access.gl-close" "access.gl-ent" "OF access.gl-close"
join280= "access.gl-close" "access.gl-summ" "OF access.gl-close"
join281= "access.gl-ent" "access.ap-chkvd" "OF access.gl-ent"
join282= "access.gl-ent" "access.ap-cred" "OF access.gl-ent"
join283= "access.gl-ent" "access.ap-credd" "OF access.gl-ent"
join284= "access.gl-ent" "access.ap-rvch" "OF access.gl-ent"
join285= "access.gl-ent" "access.ap-rvchd" "OF access.gl-ent"
join286= "access.gl-ent" "access.ap-vch" "OF access.gl-ent"
join287= "access.gl-ent" "access.ap-vchd" "OF access.gl-ent"
join288= "access.gl-ent" "access.cm-bldg" "OF access.gl-ent"
join289= "access.gl-ent" "access.gl-bank" "OF access.gl-ent"
join290= "access.gl-ent" "access.gl-begbal" "OF access.gl-ent"
join291= "access.gl-ent" "access.gl-bgt" "OF access.gl-ent"
join292= "access.gl-ent" "access.gl-bgtd" "OF access.gl-ent"
join293= "access.gl-ent" "access.gl-close" "OF access.gl-ent"
join294= "access.gl-ent" "access.gl-entg" "OF access.gl-ent"
join295= "access.gl-ent" "access.gl-entt" "OF access.gl-ent"
join296= "access.gl-ent" "access.gl-entu" "OF access.gl-ent"
join297= "access.gl-ent" "access.gl-jrnld" "OF access.gl-ent"
join298= "access.gl-ent" "access.gl-recd" "OF access.gl-ent"
join299= "access.gl-ent" "access.gl-rptd" "OF access.gl-ent"
join300= "access.gl-ent" "access.gl-stmtd" "OF access.gl-ent"
join301= "access.gl-ent" "access.gl-summ" "OF access.gl-ent"
join302= "access.gl-ent" "access.po-ent" "OF access.gl-ent"
join303= "access.gl-ent" "access.po-pod" "OF access.gl-ent"
join304= "access.gl-fmt" "access.gl-fmtd" "OF access.gl-fmt"
join305= "access.gl-fmt" "access.gl-stmt" "OF access.gl-fmt"
join306= "access.gl-fmtd" "access.gl-acct" "OF access.gl-fmtd"
join307= "access.gl-fmtd" "access.gl-fmt" "OF access.gl-fmtd"
join308= "access.gl-jrnl" "access.cm-batch" "OF access.gl-jrnl"
join309= "access.gl-jrnl" "access.gl-jrnld" "OF access.gl-jrnl"
join310= "access.gl-jrnld" "access.ap-rvch" "OF access.gl-jrnld"
join311= "access.gl-jrnld" "access.ap-vch" "OF access.gl-jrnld"
join312= "access.gl-jrnld" "access.gl-acct" "OF access.gl-jrnld"
join313= "access.gl-jrnld" "access.gl-ent" "OF access.gl-jrnld"
join314= "access.gl-jrnld" "access.gl-jrnl" "OF access.gl-jrnld"
join315= "access.gl-over" "access.gl-overd" "OF access.gl-over"
join316= "access.gl-overd" "access.gl-over" "OF access.gl-overd"
join317= "access.gl-recd" "access.gl-acct" "OF access.gl-recd"
join318= "access.gl-recd" "access.gl-ent" "OF access.gl-recd"
join319= "access.gl-rptd" "access.gl-ent" "OF access.gl-rptd"
join320= "access.gl-stmt" "access.gl-fmt" "OF access.gl-stmt"
join321= "access.gl-subacc" "access.gl-acct" "OF access.gl-subacc"
join322= "access.gl-summ" "access.gl-acct" "OF access.gl-summ"
join323= "access.gl-summ" "access.gl-close" "OF access.gl-summ"
join324= "access.gl-summ" "access.gl-ent" "OF access.gl-summ"
join325= "access.la-cat" "access.cm-chgcd" "OF access.la-cat"
join326= "access.la-catd" "access.cm-chgcd" "OF access.la-catd"
join327= "access.la-comm" "access.cm-bldg" "OF access.la-comm"
join328= "access.la-comm" "access.cm-ten" "OF access.la-comm"
join329= "access.la-comm" "access.cm-unit" "OF access.la-comm"
join330= "access.la-commd" "access.cm-bldg" "OF access.la-commd"
join331= "access.la-commd" "access.cm-chgcd" "OF access.la-commd"
join332= "access.la-commd" "access.cm-rechg" "OF access.la-commd"
join333= "access.la-commd" "access.cm-ten" "OF access.la-commd"
join334= "access.la-commd" "access.cm-unit" "OF access.la-commd"
join335= "access.la-cpi" "access.cm-bldg" "OF access.la-cpi"
join336= "access.la-cpi" "access.cm-ten" "OF access.la-cpi"
join337= "access.la-cpi" "access.cm-unit" "OF access.la-cpi"
join338= "access.la-cpic" "access.cm-bldg" "OF access.la-cpic"
join339= "access.la-cpic" "access.cm-ten" "OF access.la-cpic"
join340= "access.la-cpic" "access.cm-unit" "OF access.la-cpic"
join341= "access.la-cpit" "access.cm-chgcd" "OF access.la-cpit"
join342= "access.la-esc" "access.cm-bldg" "OF access.la-esc"
join343= "access.la-esc" "access.cm-ten" "OF access.la-esc"
join344= "access.la-esc" "access.cm-unit" "OF access.la-esc"
join345= "access.la-escc" "access.cm-bldg" "OF access.la-escc"
join346= "access.la-escc" "access.cm-ten" "OF access.la-escc"
join347= "access.la-escc" "access.cm-unit" "OF access.la-escc"
join348= "access.la-esct" "access.cm-chgcd" "OF access.la-esct"
join349= "access.la-exp" "access.cm-bldg" "OF access.la-exp"
join350= "access.la-perc" "access.cm-bldg" "OF access.la-perc"
join351= "access.la-perc" "access.cm-ten" "OF access.la-perc"
join352= "access.la-perc" "access.cm-unit" "OF access.la-perc"
join353= "access.la-percd" "access.cm-bldg" "OF access.la-percd"
join354= "access.la-percd" "access.cm-ten" "OF access.la-percd"
join355= "access.la-percd" "access.cm-unit" "OF access.la-percd"
join356= "access.la-sale" "access.cm-bldg" "OF access.la-sale"
join357= "access.la-sale" "access.cm-ten" "OF access.la-sale"
join358= "access.la-sale" "access.cm-unit" "OF access.la-sale"
join359= "access.la-salea" "access.cm-bldg" "OF access.la-salea"
join360= "access.la-salea" "access.cm-ten" "OF access.la-salea"
join361= "access.la-salea" "access.cm-unit" "OF access.la-salea"
join362= "access.la-spr" "access.cm-bldg" "OF access.la-spr"
join363= "access.la-spr" "access.cm-ten" "OF access.la-spr"
join364= "access.la-spr" "access.cm-unit" "OF access.la-spr"
join365= "access.la-sprd" "access.cm-bldg" "OF access.la-sprd"
join366= "access.la-sprd" "access.cm-ten" "OF access.la-sprd"
join367= "access.la-sprd" "access.cm-unit" "OF access.la-sprd"
join368= "access.od-invest" "access.ap-vend" "OF access.od-invest"
join369= "access.po-ent" "access.gl-ent" "OF access.po-ent"
join370= "access.po-po" "access.ap-terms" "OF access.po-po"
join371= "access.po-po" "access.ap-vend" "OF access.po-po"
join372= "access.po-pod" "access.gl-acct" "OF access.po-pod"
join373= "access.po-pod" "access.gl-ent" "OF access.po-pod"
join374= "access.rm-adjcd" "access.gl-acct" "OF access.rm-adjcd"
join375= "access.rm-adjcd" "access.gl-subacc" "OF access.rm-adjcd"
join376= "access.rm-adjcd" "access.rm-chgcd" "OF access.rm-adjcd"
join377= "access.rm-batch" "access.gl-bank" "OF access.rm-batch"
join378= "access.rm-batch" "access.rm-chg" "OF access.rm-batch"
join379= "access.rm-batch" "access.rm-cred" "OF access.rm-batch"
join380= "access.rm-batch" "access.rm-rcpt" "OF access.rm-batch"
join381= "access.rm-batch" "access.rm-vac" "OF access.rm-batch"
join382= "access.rm-bldg" "access.gl-bank" "OF access.rm-bldg"
join383= "access.rm-bldg" "access.gl-ent" "OF access.rm-bldg"
join384= "access.rm-bldg" "access.rm-bldgd" "OF access.rm-bldg"
join385= "access.rm-bldg" "access.rm-bldgi" "OF access.rm-bldg"
join386= "access.rm-bldg" "access.rm-bldgt" "OF access.rm-bldg"
join387= "access.rm-bldg" "access.rm-res" "OF access.rm-bldg"
join388= "access.rm-bldg" "access.rm-unit" "OF access.rm-bldg"
join389= "access.rm-bldg" "access.rw-wo" "OF access.rm-bldg"
join390= "access.rm-bldgd" "access.rm-bldg" "OF access.rm-bldgd"
join391= "access.rm-bldgi" "access.rm-bldg" "OF access.rm-bldgi"
join392= "access.rm-bldgt" "access.rm-bldg" "OF access.rm-bldgt"
join393= "access.rm-chg" "access.rm-adjcd" "OF access.rm-chg"
join394= "access.rm-chg" "access.rm-batch" "OF access.rm-chg"
join395= "access.rm-chg" "access.rm-bldg" "OF access.rm-chg"
join396= "access.rm-chg" "access.rm-chgcd" "OF access.rm-chg"
join397= "access.rm-chg" "access.rm-credd" "OF access.rm-chg"
join398= "access.rm-chg" "access.rm-rcptd" "OF access.rm-chg"
join399= "access.rm-chg" "access.rm-res" "OF access.rm-chg"
join400= "access.rm-chg" "access.rm-unit" "OF access.rm-chg"
join401= "access.rm-chgcd" "access.rm-adjcd" "OF access.rm-chgcd"
join402= "access.rm-cred" "access.rm-adjcd" "OF access.rm-cred"
join403= "access.rm-cred" "access.rm-batch" "OF access.rm-cred"
join404= "access.rm-cred" "access.rm-bldg" "OF access.rm-cred"
join405= "access.rm-cred" "access.rm-chgcd" "OF access.rm-cred"
join406= "access.rm-cred" "access.rm-credd" "OF access.rm-cred"
join407= "access.rm-cred" "access.rm-res" "OF access.rm-cred"
join408= "access.rm-cred" "access.rm-unit" "OF access.rm-cred"
join409= "access.rm-credd" "access.rm-chg" "OF access.rm-credd"
join410= "access.rm-credd" "access.rm-cred" "OF access.rm-credd"
join411= "access.rm-credh" "access.rm-bldg" "OF access.rm-credh"
join412= "access.rm-credh" "access.rm-res" "OF access.rm-credh"
join413= "access.rm-credh" "access.rm-unit" "OF access.rm-credh"
join414= "access.rm-dchis" "access.rm-adjcd" "OF access.rm-dchis"
join415= "access.rm-dchis" "access.rm-bldg" "OF access.rm-dchis"
join416= "access.rm-dchis" "access.rm-chgcd" "OF access.rm-dchis"
join417= "access.rm-dchis" "access.rm-res" "OF access.rm-dchis"
join418= "access.rm-dchis" "access.rm-unit" "OF access.rm-dchis"
join419= "access.rm-dcinc" "access.rm-adjcd" "OF access.rm-dcinc"
join420= "access.rm-dcinc" "access.rm-bldg" "OF access.rm-dcinc"
join421= "access.rm-dcinc" "access.rm-chgcd" "OF access.rm-dcinc"
join422= "access.rm-dcinc" "access.rm-res" "OF access.rm-dcinc"
join423= "access.rm-dcinc" "access.rm-unit" "OF access.rm-dcinc"
join424= "access.rm-dciwr" "access.rm-adjcd" "OF access.rm-dciwr"
join425= "access.rm-dciwr" "access.rm-bldg" "OF access.rm-dciwr"
join426= "access.rm-dciwr" "access.rm-chgcd" "OF access.rm-dciwr"
join427= "access.rm-dciwr" "access.rm-res" "OF access.rm-dciwr"
join428= "access.rm-dciwr" "access.rm-unit" "OF access.rm-dciwr"
join429= "access.rm-dep" "access.rm-bldg" "OF access.rm-dep"
join430= "access.rm-dep" "access.rm-depcd" "OF access.rm-dep"
join431= "access.rm-dep" "access.rm-depd" "OF access.rm-dep"
join432= "access.rm-dep" "access.rm-rcptd" "OF access.rm-dep"
join433= "access.rm-dep" "access.rm-res" "OF access.rm-dep"
join434= "access.rm-dep" "access.rm-unit" "OF access.rm-dep"
join435= "access.rm-depd" "access.gl-acct" "OF access.rm-depd"
join436= "access.rm-depd" "access.gl-subacc" "OF access.rm-depd"
join437= "access.rm-depd" "access.rm-dep" "OF access.rm-depd"
join438= "access.rm-grp" "access.rm-adjcd" "OF access.rm-grp"
join439= "access.rm-grp" "access.rm-bldg" "OF access.rm-grp"
join440= "access.rm-grp" "access.rm-chgcd" "OF access.rm-grp"
join441= "access.rm-grp" "access.rm-res" "OF access.rm-grp"
join442= "access.rm-grp" "access.rm-unit" "OF access.rm-grp"
join443= "access.rm-inv" "access.rm-bldg" "OF access.rm-inv"
join444= "access.rm-inv" "access.rm-invh" "OF access.rm-inv"
join445= "access.rm-inv" "access.rm-unit" "OF access.rm-inv"
join446= "access.rm-invh" "access.rm-inv" "OF access.rm-invh"
join447= "access.rm-latef" "access.rm-adjcd" "OF access.rm-latef"
join448= "access.rm-latef" "access.rm-bldg" "OF access.rm-latef"
join449= "access.rm-latef" "access.rm-chgcd" "OF access.rm-latef"
join450= "access.rm-latef" "access.rm-res" "OF access.rm-latef"
join451= "access.rm-latef" "access.rm-unit" "OF access.rm-latef"
join452= "access.rm-lateh" "access.rm-adjcd" "OF access.rm-lateh"
join453= "access.rm-lateh" "access.rm-bldg" "OF access.rm-lateh"
join454= "access.rm-lateh" "access.rm-chgcd" "OF access.rm-lateh"
join455= "access.rm-lateh" "access.rm-res" "OF access.rm-lateh"
join456= "access.rm-lateh" "access.rm-unit" "OF access.rm-lateh"
join457= "access.rm-lockd" "access.rm-batch" "OF access.rm-lockd"
join458= "access.rm-lockd" "access.rm-lockh" "OF access.rm-lockd"
join459= "access.rm-lockh" "access.rm-lockd" "OF access.rm-lockh"
join460= "access.rm-mgmt" "access.rm-bldg" "OF access.rm-mgmt"
join461= "access.rm-mgmt" "access.rm-mgmtd" "OF access.rm-mgmt"
join462= "access.rm-mgmt" "access.rm-res" "OF access.rm-mgmt"
join463= "access.rm-mgmt" "access.rm-unit" "OF access.rm-mgmt"
join464= "access.rm-mgmtd" "access.rm-chgcd" "OF access.rm-mgmtd"
join465= "access.rm-mgmtd" "access.rm-mgmt" "OF access.rm-mgmtd"
join466= "access.rm-mort" "access.rm-bldg" "OF access.rm-mort"
join467= "access.rm-mort" "access.rm-res" "OF access.rm-mort"
join468= "access.rm-mort" "access.rm-unit" "OF access.rm-mort"
join469= "access.rm-mortd" "access.rm-mort" "OF access.rm-mortd"
join470= "access.rm-mortp" "access.rm-bldg" "OF access.rm-mortp"
join471= "access.rm-mortp" "access.rm-mort" "OF access.rm-mortp"
join472= "access.rm-mortp" "access.rm-res" "OF access.rm-mortp"
join473= "access.rm-mortp" "access.rm-unit" "OF access.rm-mortp"
join474= "access.rm-prep" "access.rm-adjcd" "OF access.rm-prep"
join475= "access.rm-prep" "access.rm-bldg" "OF access.rm-prep"
join476= "access.rm-prep" "access.rm-chgcd" "OF access.rm-prep"
join477= "access.rm-prep" "access.rm-prepd" "OF access.rm-prep"
join478= "access.rm-prep" "access.rm-rcpt" "OF access.rm-prep"
join479= "access.rm-prep" "access.rm-res" "OF access.rm-prep"
join480= "access.rm-prep" "access.rm-unit" "OF access.rm-prep"
join481= "access.rm-prepd" "access.rm-cred" "OF access.rm-prepd"
join482= "access.rm-prepd" "access.rm-prep" "OF access.rm-prepd"
join483= "access.rm-rcpt" "access.rm-batch" "OF access.rm-rcpt"
join484= "access.rm-rcpt" "access.rm-bldg" "OF access.rm-rcpt"
join485= "access.rm-rcpt" "access.rm-rcptd" "OF access.rm-rcpt"
join486= "access.rm-rcpt" "access.rm-res" "OF access.rm-rcpt"
join487= "access.rm-rcpt" "access.rm-unit" "OF access.rm-rcpt"
join488= "access.rm-rcptd" "access.gl-acct" "OF access.rm-rcptd"
join489= "access.rm-rcptd" "access.gl-subacc" "OF access.rm-rcptd"
join490= "access.rm-rcptd" "access.rm-chg" "OF access.rm-rcptd"
join491= "access.rm-rcptd" "access.rm-dep" "OF access.rm-rcptd"
join492= "access.rm-rcptd" "access.rm-depcd" "OF access.rm-rcptd"
join493= "access.rm-rcptd" "access.rm-rcpt" "OF access.rm-rcptd"
join494= "access.rm-rechg" "access.rm-adjcd" "OF access.rm-rechg"
join495= "access.rm-rechg" "access.rm-bldg" "OF access.rm-rechg"
join496= "access.rm-rechg" "access.rm-chgcd" "OF access.rm-rechg"
join497= "access.rm-rechg" "access.rm-res" "OF access.rm-rechg"
join498= "access.rm-res" "access.rm-bldg" "OF access.rm-res"
join499= "access.rm-res" "access.rm-credh" "OF access.rm-res"
join500= "access.rm-res" "access.rm-dep" "OF access.rm-res"
join501= "access.rm-res" "access.rm-lateh" "OF access.rm-res"
join502= "access.rm-res" "access.rm-mort" "OF access.rm-res"
join503= "access.rm-res" "access.rm-mortp" "OF access.rm-res"
join504= "access.rm-res" "access.rm-rechg" "OF access.rm-res"
join505= "access.rm-res" "access.rm-resa" "OF access.rm-res"
join506= "access.rm-res" "access.rm-resc" "OF access.rm-res"
join507= "access.rm-res" "access.rm-resd" "OF access.rm-res"
join508= "access.rm-res" "access.rm-resdl" "OF access.rm-res"
join509= "access.rm-res" "access.rm-resr" "OF access.rm-res"
join510= "access.rm-res" "access.rm-rest" "OF access.rm-res"
join511= "access.rm-res" "access.rm-unit" "OF access.rm-res"
join512= "access.rm-res" "access.rr-ntv" "OF access.rm-res"
join513= "access.rm-res" "access.rw-wo" "OF access.rm-res"
join514= "access.rm-resa" "access.rm-bldg" "OF access.rm-resa"
join515= "access.rm-resa" "access.rm-res" "OF access.rm-resa"
join516= "access.rm-resa" "access.rm-unit" "OF access.rm-resa"
join517= "access.rm-resc" "access.rm-bldg" "OF access.rm-resc"
join518= "access.rm-resc" "access.rm-res" "OF access.rm-resc"
join519= "access.rm-resc" "access.rm-unit" "OF access.rm-resc"
join520= "access.rm-resd" "access.rm-bldg" "OF access.rm-resd"
join521= "access.rm-resd" "access.rm-res" "OF access.rm-resd"
join522= "access.rm-resd" "access.rm-unit" "OF access.rm-resd"
join523= "access.rm-resdl" "access.rm-bldg" "OF access.rm-resdl"
join524= "access.rm-resdl" "access.rm-res" "OF access.rm-resdl"
join525= "access.rm-resdl" "access.rm-unit" "OF access.rm-resdl"
join526= "access.rm-resr" "access.rm-bldg" "OF access.rm-resr"
join527= "access.rm-resr" "access.rm-res" "OF access.rm-resr"
join528= "access.rm-resr" "access.rm-unit" "OF access.rm-resr"
join529= "access.rm-rest" "access.rm-bldg" "OF access.rm-rest"
join530= "access.rm-rest" "access.rm-res" "OF access.rm-rest"
join531= "access.rm-rest" "access.rm-tklr" "OF access.rm-rest"
join532= "access.rm-rest" "access.rm-unit" "OF access.rm-rest"
join533= "access.rm-tklr" "access.rm-bldgt" "OF access.rm-tklr"
join534= "access.rm-tklr" "access.rm-rest" "OF access.rm-tklr"
join535= "access.rm-tklr" "access.rm-unitt" "OF access.rm-tklr"
join536= "access.rm-unit" "access.rm-bldg" "OF access.rm-unit"
join537= "access.rm-unit" "access.rm-res" "OF access.rm-unit"
join538= "access.rm-unit" "access.rm-unitd" "OF access.rm-unit"
join539= "access.rm-unit" "access.rm-unitf" "OF access.rm-unit"
join540= "access.rm-unit" "access.rm-unitm" "OF access.rm-unit"
join541= "access.rm-unit" "access.rm-unito" "OF access.rm-unit"
join542= "access.rm-unit" "access.rm-unitt" "OF access.rm-unit"
join543= "access.rm-unit" "access.rw-wo" "OF access.rm-unit"
join544= "access.rm-unitd" "access.rm-bldg" "OF access.rm-unitd"
join545= "access.rm-unitd" "access.rm-chgcd" "OF access.rm-unitd"
join546= "access.rm-unitd" "access.rm-unit" "OF access.rm-unitd"
join547= "access.rm-unitm" "access.rm-bldg" "OF access.rm-unitm"
join548= "access.rm-unitm" "access.rm-res" "OF access.rm-unitm"
join549= "access.rm-unitm" "access.rm-unit" "OF access.rm-unitm"
join550= "access.rm-unito" "access.rm-bldg" "OF access.rm-unito"
join551= "access.rm-unito" "access.rm-unit" "OF access.rm-unito"
join552= "access.rm-unitt" "access.rm-bldg" "OF access.rm-unitt"
join553= "access.rm-unitt" "access.rm-tklr" "OF access.rm-unitt"
join554= "access.rm-unitt" "access.rm-unit" "OF access.rm-unitt"
join555= "access.rm-vac" "access.rm-adjcd" "OF access.rm-vac"
join556= "access.rm-vac" "access.rm-batch" "OF access.rm-vac"
join557= "access.rm-vac" "access.rm-bldg" "OF access.rm-vac"
join558= "access.rm-vac" "access.rm-chgcd" "OF access.rm-vac"
join559= "access.rm-vac" "access.rm-unit" "OF access.rm-vac"
join560= "access.rr-app" "access.rr-info" "OF access.rr-app"
join561= "access.rw-chg" "access.rw-wo" "OF access.rw-chg"
join562= "access.rw-mnt" "access.rw-schd" "OF access.rw-mnt"
join563= "access.rw-mnt" "access.rw-vac" "OF access.rw-mnt"
join564= "access.rw-mnt" "access.rw-wo" "OF access.rw-mnt"
join565= "access.rw-pers" "access.rw-wo" "OF access.rw-pers"
join566= "access.rw-sat" "access.rw-wo" "OF access.rw-sat"
join567= "access.rw-schd" "access.rw-schdd" "OF access.rw-schd"
join568= "access.rw-vac" "access.rw-vacd" "OF access.rw-vac"
join569= "access.rw-wo" "access.rw-woi" "OF access.rw-wo"
*/
C. Denny Brookwell
Nextnet Hosting, Inc.
Let me start by saying thank you for reading this.
Over view:
Progress V9.x running on IBM SCO system. The applaction is a large accounting system used in the Home Owners Association management world. The progress script code dates back to 1990 and up to 2003. I have placed the progress *.qc file contents at the end of this email.
Objective:
Integrate mySQL data into the progress screen data. Example: The screen shows the record of a user. First Name, Last Name, etc. I need to add a email field from mySQL data base.
How it is done now.
1. Progress exports all user data from the tables to tab delimited flat files.
2. We run an AWK script to create a key field on some of the table data.
3. We import the flat files into a remote mySQL data base.
4. The user adds their email to the data and updates there phone #.
5. We export the modified records to a tab delimed file.
6. Progress imports flat file. (THIS IS NOT BUILT YET)
How we think/would like it to be Done:
1. Progress exports all the data as it is done now BUT adds to the scripts the key field we build with AWK, and adds the mySQL import statements that are needed to import the data into a mySQL DB.
2. mySQL DB would be local to Progress DB.
3. The user then would be remote for the mySQL.
4. Display the new email or phone # from the mySQL DB within the Progress Screen scripts.
4a. The progress DB and the accounting scripts seem very unstable and that is why we are trying to stay away from writing to the progress DB.
4b. If writing to the Progress DB can be done in a way that if all go's worng we can fix it that would work.
5. The mySQL DB would be the interface between the user and the Progress DB.
I would appreate any input that you would have for this project.
***********************************************************************************
access.qc
/*
# PROGRESS RESULTS system administrator configuration file
config= sysadmin
version= 1.3E
goodbye= "return"
language= "eng"
product= "PROGRESS RESULTS"
signon= "prores/u-logo.p"
database1= "access" "PROGRESS" 729766511427
fastload= "res00100.p"
#
message= "Loading module settings"
module-query= "*"
module-report= "*"
module-label= "*"
module-data= "*"
module-user= "*"
module-admin= "*"
#
message= "Loading color settings"
color-co80= "BLACK/CYAN" "WHITE/RED" "GRAY/RED" "RED/GRAY" "BLUE/GRAY" "GRAY/BLUE"
#
message= "Loading printer setup"
printer1= "TERMINAL" "" "*" "page" 80 "" "" "" "" ""
printer2= "FILE" "" "*" "file" 80 "" "" "" "" ""
printer3= "PRINTER" "PRINTER" "*" "to" 80 "" "" "" "" ""
printer4= "Envelope printer" "lp -s -c -dp1" "*" "thru" 80 "27,38,108,56,49,97,51,104,49,79,,,,,,,,,,,,,," "" "" "" ""
printer5= "HP22200dn" "lp -s -c -dhp2200dn" "*" "thru" 80 "27,38,107,50,83,,,,,,,,,,,,,,,,,,," "" "" "" ""
printer6= "HP2200dn Landscape" "lp -s -c -dhp2200dn" "*" "thru" 100 "27,38,107,50,83,27,38,108,49,79,,,,,,,,,,,,,," "" "" "" ""
#
message= "Loading auto-select field list for mailing labels"
label-name= "name,*name*,contact,*contact*"
label-addr1= "*street,*addr,*address,*address*1"
label-addr2= "*po*box*,*address*2"
label-addr3= "*address*3"
label-city= "city,*city*"
label-state= "st,state,*state*"
label-zip= "zip,*zip*"
label-zip+4= "zip*4"
label-csz= "*csz*,*city*st*z*"
label-country= "*country*"
#
message= "Loading permissions list for query functions"
query-next= "*"
query-prev= "*"
query-first= "*"
query-last= "*"
query-add= "!*"
query-update= "!*"
query-copy= "!*"
query-delete= "!*"
query-view= "*"
query-browse= "*"
query-join= "*"
query-query= "*"
query-where= "*"
query-total= "*"
query-order= "*"
query-module= "*"
query-info= "*"
query-user= "*"
query-help= "*"
query-exit= "*"
#
message= "Loading user option information"
user-program= ""
user-export= "" ""
user-query= "u-browse.i"
#
message= "Loading system report defaults"
left-margin= 1
page-size= 66
column-spacing= 1
line-spacing= 1
top-margin= 1
before-body= 0
after-body= 0
first-only= "" "" ""
last-only= "" "" ""
top-left= "" "" ""
top-center= "" "" ""
top-right= "" "" ""
bottom-left= "" "" ""
bottom-center= "" "" ""
bottom-right= "" "" ""
#
message= "Loading list of viewable files"
#
message= "Loading list of relations"
join1= "access.ap-1099" "access.ap-vend" "OF access.ap-1099"
join2= "access.ap-1099" "access.gl-ent" "OF access.ap-1099"
join3= "access.ap-chk" "access.ap-chkv" "OF access.ap-chk"
join4= "access.ap-chk" "access.ap-chkvd" "OF access.ap-chk"
join5= "access.ap-chk" "access.ap-vend" "OF access.ap-chk"
join6= "access.ap-chk" "access.gl-bank" "OF access.ap-chk"
join7= "access.ap-chkv" "access.ap-chk" "OF access.ap-chkv"
join8= "access.ap-chkv" "access.ap-chkvd" "OF access.ap-chkv"
join9= "access.ap-chkv" "access.ap-vch" "WHERE access.ap-vch.voucher = access.ap-chkv.voucher"
join10= "access.ap-chkv" "access.gl-bank" "OF access.ap-chkv"
join11= "access.ap-chkvd" "access.ap-chk" "OF access.ap-chkvd"
join12= "access.ap-chkvd" "access.ap-chkv" "OF access.ap-chkvd"
join13= "access.ap-chkvd" "access.ap-vch" "OF access.ap-chkvd"
join14= "access.ap-chkvd" "access.ap-vchd" "OF access.ap-chkvd"
join15= "access.ap-chkvd" "access.gl-acct" "OF access.ap-chkvd"
join16= "access.ap-chkvd" "access.gl-bank" "OF access.ap-chkvd"
join17= "access.ap-chkvd" "access.gl-ent" "OF access.ap-chkvd"
join18= "access.ap-cra" "access.ap-crad" "OF access.ap-cra"
join19= "access.ap-cra" "access.ap-cred" "OF access.ap-cra"
join20= "access.ap-cra" "access.ap-vch" "OF access.ap-cra"
join21= "access.ap-crad" "access.ap-cra" "OF access.ap-crad"
join22= "access.ap-crad" "access.ap-cred" "OF access.ap-crad"
join23= "access.ap-crad" "access.ap-vch" "OF access.ap-crad"
join24= "access.ap-crad" "access.ap-vchd" "OF access.ap-crad"
join25= "access.ap-cred" "access.ap-cra" "OF access.ap-cred"
join26= "access.ap-cred" "access.ap-crad" "OF access.ap-cred"
join27= "access.ap-cred" "access.ap-credd" "OF access.ap-cred"
join28= "access.ap-cred" "access.ap-vend" "OF access.ap-cred"
join29= "access.ap-cred" "access.gl-acct" "OF access.ap-cred"
join30= "access.ap-cred" "access.gl-ent" "OF access.ap-cred"
join31= "access.ap-credd" "access.ap-cred" "OF access.ap-credd"
join32= "access.ap-credd" "access.gl-acct" "OF access.ap-credd"
join33= "access.ap-credd" "access.gl-ent" "OF access.ap-credd"
join34= "access.ap-rvch" "access.ap-rvchd" "OF access.ap-rvch"
join35= "access.ap-rvch" "access.ap-terms" "OF access.ap-rvch"
join36= "access.ap-rvch" "access.ap-vend" "OF access.ap-rvch"
join37= "access.ap-rvch" "access.gl-acct" "OF access.ap-rvch"
join38= "access.ap-rvch" "access.gl-ent" "OF access.ap-rvch"
join39= "access.ap-rvchd" "access.ap-rvch" "OF access.ap-rvchd"
join40= "access.ap-rvchd" "access.gl-acct" "OF access.ap-rvchd"
join41= "access.ap-rvchd" "access.gl-ent" "OF access.ap-rvchd"
join42= "access.ap-type" "access.ap-vend" "OF access.ap-type"
join43= "access.ap-vch" "access.ap-chk" "OF access.ap-vch"
join44= "access.ap-vch" "access.ap-chkv" "WHERE .where ap-chkv.voucher = ap-vch.voucher"
join45= "access.ap-vch" "access.ap-chkvd" "OF access.ap-vch"
join46= "access.ap-vch" "access.ap-cra" "OF access.ap-vch"
join47= "access.ap-vch" "access.ap-crad" "OF access.ap-vch"
join48= "access.ap-vch" "access.ap-terms" "OF access.ap-vch"
join49= "access.ap-vch" "access.ap-vchd" "OF access.ap-vch"
join50= "access.ap-vch" "access.ap-vend" "OF access.ap-vch"
join51= "access.ap-vch" "access.gl-acct" "OF access.ap-vch"
join52= "access.ap-vch" "access.gl-bank" "OF access.ap-vch"
join53= "access.ap-vch" "access.gl-ent" "OF access.ap-vch"
join54= "access.ap-vchd" "access.ap-chkvd" "OF access.ap-vchd"
join55= "access.ap-vchd" "access.ap-crad" "OF access.ap-vchd"
join56= "access.ap-vchd" "access.ap-vch" "OF access.ap-vchd"
join57= "access.ap-vchd" "access.gl-acct" "OF access.ap-vchd"
join58= "access.ap-vchd" "access.gl-ent" "OF access.ap-vchd"
join59= "access.ap-vend" "access.ap-chk" "OF access.ap-vend"
join60= "access.ap-vend" "access.ap-cred" "OF access.ap-vend"
join61= "access.ap-vend" "access.ap-rvch" "OF access.ap-vend"
join62= "access.ap-vend" "access.ap-terms" "OF access.ap-vend"
join63= "access.ap-vend" "access.ap-type" "OF access.ap-vend"
join64= "access.ap-vend" "access.ap-vch" "OF access.ap-vend"
join65= "access.cm-adjcd" "access.cm-chgcd" "OF access.cm-adjcd"
join66= "access.cm-batch" "access.cm-cash" "OF access.cm-batch"
join67= "access.cm-batch" "access.cm-chg" "OF access.cm-batch"
join68= "access.cm-batch" "access.cm-cred" "OF access.cm-batch"
join69= "access.cm-batch" "access.cm-vac" "OF access.cm-batch"
join70= "access.cm-batch" "access.gl-bank" "OF access.cm-batch"
join71= "access.cm-bldg" "access.cm-bldgd" "OF access.cm-bldg"
join72= "access.cm-bldg" "access.cm-bldgi" "OF access.cm-bldg"
join73= "access.cm-bldg" "access.cm-bldgt" "OF access.cm-bldg"
join74= "access.cm-bldg" "access.cm-note" "OF access.cm-bldg"
join75= "access.cm-bldg" "access.cm-noted" "OF access.cm-bldg"
join76= "access.cm-bldg" "access.cm-notep" "OF access.cm-bldg"
join77= "access.cm-bldg" "access.cm-opt" "OF access.cm-bldg"
join78= "access.cm-bldg" "access.cm-ten" "OF access.cm-bldg"
join79= "access.cm-bldg" "access.cm-unit" "OF access.cm-bldg"
join80= "access.cm-bldg" "access.gl-ent" "OF access.cm-bldg"
join81= "access.cm-bldg" "access.la-comm" "OF access.cm-bldg"
join82= "access.cm-bldg" "access.la-commd" "OF access.cm-bldg"
join83= "access.cm-bldg" "access.la-cpi" "OF access.cm-bldg"
join84= "access.cm-bldg" "access.la-cpic" "OF access.cm-bldg"
join85= "access.cm-bldg" "access.la-esc" "OF access.cm-bldg"
join86= "access.cm-bldg" "access.la-escc" "OF access.cm-bldg"
join87= "access.cm-bldg" "access.la-exp" "OF access.cm-bldg"
join88= "access.cm-bldg" "access.la-perc" "OF access.cm-bldg"
join89= "access.cm-bldg" "access.la-percd" "OF access.cm-bldg"
join90= "access.cm-bldg" "access.la-sale" "OF access.cm-bldg"
join91= "access.cm-bldg" "access.la-salea" "OF access.cm-bldg"
join92= "access.cm-bldg" "access.la-spr" "OF access.cm-bldg"
join93= "access.cm-bldg" "access.la-sprd" "OF access.cm-bldg"
join94= "access.cm-bldgd" "access.cm-bldg" "OF access.cm-bldgd"
join95= "access.cm-bldgi" "access.cm-bldg" "OF access.cm-bldgi"
join96= "access.cm-bldgt" "access.cm-bldg" "OF access.cm-bldgt"
join97= "access.cm-cash" "access.cm-batch" "OF access.cm-cash"
join98= "access.cm-cash" "access.cm-bldg" "OF access.cm-cash"
join99= "access.cm-cash" "access.cm-cashd" "OF access.cm-cash"
join100= "access.cm-cash" "access.cm-dep" "OF access.cm-cash"
join101= "access.cm-cash" "access.cm-depcd" "OF access.cm-cash"
join102= "access.cm-cash" "access.cm-prep" "OF access.cm-cash"
join103= "access.cm-cash" "access.cm-ten" "OF access.cm-cash"
join104= "access.cm-cash" "access.cm-unit" "OF access.cm-cash"
join105= "access.cm-cash" "access.gl-acct" "OF access.cm-cash"
join106= "access.cm-cashd" "access.cm-cash" "OF access.cm-cashd"
join107= "access.cm-cashd" "access.cm-chg" "OF access.cm-cashd"
join108= "access.cm-chg" "access.cm-adjcd" "OF access.cm-chg"
join109= "access.cm-chg" "access.cm-batch" "OF access.cm-chg"
join110= "access.cm-chg" "access.cm-bldg" "OF access.cm-chg"
join111= "access.cm-chg" "access.cm-cashd" "OF access.cm-chg"
join112= "access.cm-chg" "access.cm-chgcd" "OF access.cm-chg"
join113= "access.cm-chg" "access.cm-credd" "OF access.cm-chg"
join114= "access.cm-chg" "access.cm-ten" "OF access.cm-chg"
join115= "access.cm-chg" "access.cm-unit" "OF access.cm-chg"
join116= "access.cm-chgcd" "access.cm-adjcd" "OF access.cm-chgcd"
join117= "access.cm-cred" "access.cm-adjcd" "OF access.cm-cred"
join118= "access.cm-cred" "access.cm-batch" "OF access.cm-cred"
join119= "access.cm-cred" "access.cm-bldg" "OF access.cm-cred"
join120= "access.cm-cred" "access.cm-chgcd" "OF access.cm-cred"
join121= "access.cm-cred" "access.cm-credd" "OF access.cm-cred"
join122= "access.cm-cred" "access.cm-prepd" "OF access.cm-cred"
join123= "access.cm-cred" "access.cm-ten" "OF access.cm-cred"
join124= "access.cm-cred" "access.cm-unit" "OF access.cm-cred"
join125= "access.cm-credd" "access.cm-chg" "OF access.cm-credd"
join126= "access.cm-credd" "access.cm-cred" "OF access.cm-credd"
join127= "access.cm-credh" "access.cm-bldg" "OF access.cm-credh"
join128= "access.cm-credh" "access.cm-ten" "OF access.cm-credh"
join129= "access.cm-credh" "access.cm-unit" "OF access.cm-credh"
join130= "access.cm-dep" "access.cm-bldg" "OF access.cm-dep"
join131= "access.cm-dep" "access.cm-cash" "OF access.cm-dep"
join132= "access.cm-dep" "access.cm-depcd" "OF access.cm-dep"
join133= "access.cm-dep" "access.cm-depd" "OF access.cm-dep"
join134= "access.cm-dep" "access.cm-ten" "OF access.cm-dep"
join135= "access.cm-dep" "access.cm-unit" "OF access.cm-dep"
join136= "access.cm-depd" "access.cm-batch" "OF access.cm-depd"
join137= "access.cm-depd" "access.cm-dep" "OF access.cm-depd"
join138= "access.cm-depd" "access.gl-acct" "OF access.cm-depd"
join139= "access.cm-note" "access.cm-bldg" "OF access.cm-note"
join140= "access.cm-note" "access.cm-ten" "OF access.cm-note"
join141= "access.cm-note" "access.cm-tend" "OF access.cm-note"
join142= "access.cm-note" "access.cm-unit" "OF access.cm-note"
join143= "access.cm-notep" "access.cm-bldg" "OF access.cm-notep"
join144= "access.cm-notep" "access.cm-ten" "OF access.cm-notep"
join145= "access.cm-notep" "access.cm-unit" "OF access.cm-notep"
join146= "access.cm-opt" "access.cm-bldg" "OF access.cm-opt"
join147= "access.cm-prep" "access.cm-adjcd" "OF access.cm-prep"
join148= "access.cm-prep" "access.cm-bldg" "OF access.cm-prep"
join149= "access.cm-prep" "access.cm-cash" "OF access.cm-prep"
join150= "access.cm-prep" "access.cm-chgcd" "OF access.cm-prep"
join151= "access.cm-prep" "access.cm-prepd" "OF access.cm-prep"
join152= "access.cm-prep" "access.cm-ten" "OF access.cm-prep"
join153= "access.cm-prep" "access.cm-unit" "OF access.cm-prep"
join154= "access.cm-prepd" "access.cm-batch" "OF access.cm-prepd"
join155= "access.cm-prepd" "access.cm-cred" "OF access.cm-prepd"
join156= "access.cm-prepd" "access.cm-prep" "OF access.cm-prepd"
join157= "access.cm-rechg" "access.cm-adjcd" "OF access.cm-rechg"
join158= "access.cm-rechg" "access.cm-bldg" "OF access.cm-rechg"
join159= "access.cm-rechg" "access.cm-chgcd" "OF access.cm-rechg"
join160= "access.cm-rechg" "access.cm-stepd" "OF access.cm-rechg"
join161= "access.cm-rechg" "access.cm-ten" "OF access.cm-rechg"
join162= "access.cm-rechg" "access.cm-unit" "OF access.cm-rechg"
join163= "access.cm-rechg" "access.la-commd" "OF access.cm-rechg"
join164= "access.cm-stepd" "access.cm-chgcd" "OF access.cm-stepd"
join165= "access.cm-stepd" "access.cm-rechg" "OF access.cm-stepd"
join166= "access.cm-ten" "access.cm-bldg" "OF access.cm-ten"
join167= "access.cm-ten" "access.cm-cash" "OF access.cm-ten"
join168= "access.cm-ten" "access.cm-chg" "OF access.cm-ten"
join169= "access.cm-ten" "access.cm-cred" "OF access.cm-ten"
join170= "access.cm-ten" "access.cm-credh" "OF access.cm-ten"
join171= "access.cm-ten" "access.cm-dep" "OF access.cm-ten"
join172= "access.cm-ten" "access.cm-note" "OF access.cm-ten"
join173= "access.cm-ten" "access.cm-noted" "OF access.cm-ten"
join174= "access.cm-ten" "access.cm-notep" "OF access.cm-ten"
join175= "access.cm-ten" "access.cm-opt" "OF access.cm-ten"
join176= "access.cm-ten" "access.cm-prep" "OF access.cm-ten"
join177= "access.cm-ten" "access.cm-rechg" "OF access.cm-ten"
join178= "access.cm-ten" "access.cm-stepd" "OF access.cm-ten"
join179= "access.cm-ten" "access.cm-tenc" "OF access.cm-ten"
join180= "access.cm-ten" "access.cm-tend" "OF access.cm-ten"
join181= "access.cm-ten" "access.cm-tent" "OF access.cm-ten"
join182= "access.cm-ten" "access.cm-unit" "OF access.cm-ten"
join183= "access.cm-ten" "access.cm-unitm" "OF access.cm-ten"
join184= "access.cm-ten" "access.la-comm" "OF access.cm-ten"
join185= "access.cm-ten" "access.la-commd" "OF access.cm-ten"
join186= "access.cm-ten" "access.la-cpi" "OF access.cm-ten"
join187= "access.cm-ten" "access.la-cpic" "OF access.cm-ten"
join188= "access.cm-ten" "access.la-esc" "OF access.cm-ten"
join189= "access.cm-ten" "access.la-escc" "OF access.cm-ten"
join190= "access.cm-ten" "access.la-perc" "OF access.cm-ten"
join191= "access.cm-ten" "access.la-percd" "OF access.cm-ten"
join192= "access.cm-ten" "access.la-sale" "OF access.cm-ten"
join193= "access.cm-ten" "access.la-salea" "OF access.cm-ten"
join194= "access.cm-ten" "access.la-spr" "OF access.cm-ten"
join195= "access.cm-ten" "access.la-sprd" "OF access.cm-ten"
join196= "access.cm-tenc" "access.cm-bldg" "OF access.cm-tenc"
join197= "access.cm-tenc" "access.cm-ten" "OF access.cm-tenc"
join198= "access.cm-tenc" "access.cm-unit" "OF access.cm-tenc"
join199= "access.cm-tend" "access.cm-bldg" "OF access.cm-tend"
join200= "access.cm-tend" "access.cm-ten" "OF access.cm-tend"
join201= "access.cm-tent" "access.cm-ten" "OF access.cm-tent"
join202= "access.cm-tent" "access.cm-tklr" "OF access.cm-tent"
join203= "access.cm-tklr" "access.cm-bldgt" "OF access.cm-tklr"
join204= "access.cm-tklr" "access.cm-tent" "OF access.cm-tklr"
join205= "access.cm-tklr" "access.cm-unitt" "OF access.cm-tklr"
join206= "access.cm-unit" "access.cm-bldg" "OF access.cm-unit"
join207= "access.cm-unit" "access.cm-ten" "OF access.cm-unit"
join208= "access.cm-unit" "access.cm-unitd" "OF access.cm-unit"
join209= "access.cm-unit" "access.cm-unitm" "OF access.cm-unit"
join210= "access.cm-unit" "access.cm-unitt" "OF access.cm-unit"
join211= "access.cm-unitd" "access.cm-chgcd" "OF access.cm-unitd"
join212= "access.cm-unitd" "access.cm-unit" "OF access.cm-unitd"
join213= "access.cm-unitm" "access.cm-bldg" "OF access.cm-unitm"
join214= "access.cm-unitm" "access.cm-mntcd" "OF access.cm-unitm"
join215= "access.cm-unitm" "access.cm-ten" "OF access.cm-unitm"
join216= "access.cm-unitm" "access.cm-unit" "OF access.cm-unitm"
join217= "access.cm-unitt" "access.cm-tklr" "OF access.cm-unitt"
join218= "access.cm-unitt" "access.cm-unit" "OF access.cm-unitt"
join219= "access.cm-vac" "access.cm-adjcd" "OF access.cm-vac"
join220= "access.cm-vac" "access.cm-batch" "OF access.cm-vac"
join221= "access.cm-vac" "access.cm-bldg" "OF access.cm-vac"
join222= "access.cm-vac" "access.cm-chgcd" "OF access.cm-vac"
join223= "access.cm-vac" "access.cm-unit" "OF access.cm-vac"
join224= "access.cw-chg" "access.cw-wo" "OF access.cw-chg"
join225= "access.cw-mnt" "access.cw-schd" "OF access.cw-mnt"
join226= "access.cw-mnt" "access.cw-vac" "OF access.cw-mnt"
join227= "access.cw-mnt" "access.cw-wo" "OF access.cw-mnt"
join228= "access.cw-pers" "access.cw-wo" "OF access.cw-pers"
join229= "access.cw-sat" "access.cw-wo" "OF access.cw-sat"
join230= "access.cw-schd" "access.cw-schdd" "OF access.cw-schd"
join231= "access.cw-vac" "access.cw-vacd" "OF access.cw-vac"
join232= "access.cw-wo" "access.cw-woi" "OF access.cw-wo"
join233= "access.em-inv" "access.em-meter" "OF access.em-inv"
join234= "access.em-inv" "access.em-utype" "OF access.em-inv"
join235= "access.em-meter" "access.em-utype" "OF access.em-meter"
join236= "access.gl-acct" "access.ap-chkvd" "OF access.gl-acct"
join237= "access.gl-acct" "access.ap-cred" "OF access.gl-acct"
join238= "access.gl-acct" "access.ap-credd" "OF access.gl-acct"
join239= "access.gl-acct" "access.ap-rvch" "OF access.gl-acct"
join240= "access.gl-acct" "access.ap-rvchd" "OF access.gl-acct"
join241= "access.gl-acct" "access.ap-vch" "OF access.gl-acct"
join242= "access.gl-acct" "access.ap-vchd" "OF access.gl-acct"
join243= "access.gl-acct" "access.cm-adjcd" "OF access.gl-acct"
join244= "access.gl-acct" "access.cm-cash" "OF access.gl-acct"
join245= "access.gl-acct" "access.cm-depd" "OF access.gl-acct"
join246= "access.gl-acct" "access.gl-altd" "OF access.gl-acct"
join247= "access.gl-acct" "access.gl-bank" "OF access.gl-acct"
join248= "access.gl-acct" "access.gl-begbal" "OF access.gl-acct"
join249= "access.gl-acct" "access.gl-bgt" "OF access.gl-acct"
join250= "access.gl-acct" "access.gl-bgtd" "OF access.gl-acct"
join251= "access.gl-acct" "access.gl-close" "OF access.gl-acct"
join252= "access.gl-acct" "access.gl-fmtd" "OF access.gl-acct"
join253= "access.gl-acct" "access.gl-jrnld" "OF access.gl-acct"
join254= "access.gl-acct" "access.gl-recd" "OF access.gl-acct"
join255= "access.gl-acct" "access.gl-subacc" "OF access.gl-acct"
join256= "access.gl-acct" "access.gl-summ" "OF access.gl-acct"
join257= "access.gl-acct" "access.po-pod" "OF access.gl-acct"
join258= "access.gl-bank" "access.ap-chk" "OF access.gl-bank"
join259= "access.gl-bank" "access.ap-chkv" "OF access.gl-bank"
join260= "access.gl-bank" "access.ap-chkvd" "OF access.gl-bank"
join261= "access.gl-bank" "access.ap-vch" "OF access.gl-bank"
join262= "access.gl-bank" "access.cm-batch" "OF access.gl-bank"
join263= "access.gl-bank" "access.gl-acct" "OF access.gl-bank"
join264= "access.gl-bank" "access.gl-ent" "OF access.gl-bank"
join265= "access.gl-begbal" "access.gl-acct" "OF access.gl-begbal"
join266= "access.gl-begbal" "access.gl-ent" "OF access.gl-begbal"
join267= "access.gl-bgt" "access.gl-acct" "OF access.gl-bgt"
join268= "access.gl-bgt" "access.gl-bgtcd" "OF access.gl-bgt"
join269= "access.gl-bgt" "access.gl-bgtd" "OF access.gl-bgt"
join270= "access.gl-bgt" "access.gl-ent" "OF access.gl-bgt"
join271= "access.gl-bgtcd" "access.gl-bgt" "OF access.gl-bgtcd"
join272= "access.gl-bgtcd" "access.gl-bgtd" "OF access.gl-bgtcd"
join273= "access.gl-bgtd" "access.gl-acct" "OF access.gl-bgtd"
join274= "access.gl-bgtd" "access.gl-bgt" "OF access.gl-bgtd"
join275= "access.gl-bgtd" "access.gl-bgtcd" "OF access.gl-bgtd"
join276= "access.gl-bgtd" "access.gl-ent" "OF access.gl-bgtd"
join277= "access.gl-close" "access.gl-acct" "OF access.gl-close"
join278= "access.gl-close" "access.gl-begbal" "OF access.gl-close"
join279= "access.gl-close" "access.gl-ent" "OF access.gl-close"
join280= "access.gl-close" "access.gl-summ" "OF access.gl-close"
join281= "access.gl-ent" "access.ap-chkvd" "OF access.gl-ent"
join282= "access.gl-ent" "access.ap-cred" "OF access.gl-ent"
join283= "access.gl-ent" "access.ap-credd" "OF access.gl-ent"
join284= "access.gl-ent" "access.ap-rvch" "OF access.gl-ent"
join285= "access.gl-ent" "access.ap-rvchd" "OF access.gl-ent"
join286= "access.gl-ent" "access.ap-vch" "OF access.gl-ent"
join287= "access.gl-ent" "access.ap-vchd" "OF access.gl-ent"
join288= "access.gl-ent" "access.cm-bldg" "OF access.gl-ent"
join289= "access.gl-ent" "access.gl-bank" "OF access.gl-ent"
join290= "access.gl-ent" "access.gl-begbal" "OF access.gl-ent"
join291= "access.gl-ent" "access.gl-bgt" "OF access.gl-ent"
join292= "access.gl-ent" "access.gl-bgtd" "OF access.gl-ent"
join293= "access.gl-ent" "access.gl-close" "OF access.gl-ent"
join294= "access.gl-ent" "access.gl-entg" "OF access.gl-ent"
join295= "access.gl-ent" "access.gl-entt" "OF access.gl-ent"
join296= "access.gl-ent" "access.gl-entu" "OF access.gl-ent"
join297= "access.gl-ent" "access.gl-jrnld" "OF access.gl-ent"
join298= "access.gl-ent" "access.gl-recd" "OF access.gl-ent"
join299= "access.gl-ent" "access.gl-rptd" "OF access.gl-ent"
join300= "access.gl-ent" "access.gl-stmtd" "OF access.gl-ent"
join301= "access.gl-ent" "access.gl-summ" "OF access.gl-ent"
join302= "access.gl-ent" "access.po-ent" "OF access.gl-ent"
join303= "access.gl-ent" "access.po-pod" "OF access.gl-ent"
join304= "access.gl-fmt" "access.gl-fmtd" "OF access.gl-fmt"
join305= "access.gl-fmt" "access.gl-stmt" "OF access.gl-fmt"
join306= "access.gl-fmtd" "access.gl-acct" "OF access.gl-fmtd"
join307= "access.gl-fmtd" "access.gl-fmt" "OF access.gl-fmtd"
join308= "access.gl-jrnl" "access.cm-batch" "OF access.gl-jrnl"
join309= "access.gl-jrnl" "access.gl-jrnld" "OF access.gl-jrnl"
join310= "access.gl-jrnld" "access.ap-rvch" "OF access.gl-jrnld"
join311= "access.gl-jrnld" "access.ap-vch" "OF access.gl-jrnld"
join312= "access.gl-jrnld" "access.gl-acct" "OF access.gl-jrnld"
join313= "access.gl-jrnld" "access.gl-ent" "OF access.gl-jrnld"
join314= "access.gl-jrnld" "access.gl-jrnl" "OF access.gl-jrnld"
join315= "access.gl-over" "access.gl-overd" "OF access.gl-over"
join316= "access.gl-overd" "access.gl-over" "OF access.gl-overd"
join317= "access.gl-recd" "access.gl-acct" "OF access.gl-recd"
join318= "access.gl-recd" "access.gl-ent" "OF access.gl-recd"
join319= "access.gl-rptd" "access.gl-ent" "OF access.gl-rptd"
join320= "access.gl-stmt" "access.gl-fmt" "OF access.gl-stmt"
join321= "access.gl-subacc" "access.gl-acct" "OF access.gl-subacc"
join322= "access.gl-summ" "access.gl-acct" "OF access.gl-summ"
join323= "access.gl-summ" "access.gl-close" "OF access.gl-summ"
join324= "access.gl-summ" "access.gl-ent" "OF access.gl-summ"
join325= "access.la-cat" "access.cm-chgcd" "OF access.la-cat"
join326= "access.la-catd" "access.cm-chgcd" "OF access.la-catd"
join327= "access.la-comm" "access.cm-bldg" "OF access.la-comm"
join328= "access.la-comm" "access.cm-ten" "OF access.la-comm"
join329= "access.la-comm" "access.cm-unit" "OF access.la-comm"
join330= "access.la-commd" "access.cm-bldg" "OF access.la-commd"
join331= "access.la-commd" "access.cm-chgcd" "OF access.la-commd"
join332= "access.la-commd" "access.cm-rechg" "OF access.la-commd"
join333= "access.la-commd" "access.cm-ten" "OF access.la-commd"
join334= "access.la-commd" "access.cm-unit" "OF access.la-commd"
join335= "access.la-cpi" "access.cm-bldg" "OF access.la-cpi"
join336= "access.la-cpi" "access.cm-ten" "OF access.la-cpi"
join337= "access.la-cpi" "access.cm-unit" "OF access.la-cpi"
join338= "access.la-cpic" "access.cm-bldg" "OF access.la-cpic"
join339= "access.la-cpic" "access.cm-ten" "OF access.la-cpic"
join340= "access.la-cpic" "access.cm-unit" "OF access.la-cpic"
join341= "access.la-cpit" "access.cm-chgcd" "OF access.la-cpit"
join342= "access.la-esc" "access.cm-bldg" "OF access.la-esc"
join343= "access.la-esc" "access.cm-ten" "OF access.la-esc"
join344= "access.la-esc" "access.cm-unit" "OF access.la-esc"
join345= "access.la-escc" "access.cm-bldg" "OF access.la-escc"
join346= "access.la-escc" "access.cm-ten" "OF access.la-escc"
join347= "access.la-escc" "access.cm-unit" "OF access.la-escc"
join348= "access.la-esct" "access.cm-chgcd" "OF access.la-esct"
join349= "access.la-exp" "access.cm-bldg" "OF access.la-exp"
join350= "access.la-perc" "access.cm-bldg" "OF access.la-perc"
join351= "access.la-perc" "access.cm-ten" "OF access.la-perc"
join352= "access.la-perc" "access.cm-unit" "OF access.la-perc"
join353= "access.la-percd" "access.cm-bldg" "OF access.la-percd"
join354= "access.la-percd" "access.cm-ten" "OF access.la-percd"
join355= "access.la-percd" "access.cm-unit" "OF access.la-percd"
join356= "access.la-sale" "access.cm-bldg" "OF access.la-sale"
join357= "access.la-sale" "access.cm-ten" "OF access.la-sale"
join358= "access.la-sale" "access.cm-unit" "OF access.la-sale"
join359= "access.la-salea" "access.cm-bldg" "OF access.la-salea"
join360= "access.la-salea" "access.cm-ten" "OF access.la-salea"
join361= "access.la-salea" "access.cm-unit" "OF access.la-salea"
join362= "access.la-spr" "access.cm-bldg" "OF access.la-spr"
join363= "access.la-spr" "access.cm-ten" "OF access.la-spr"
join364= "access.la-spr" "access.cm-unit" "OF access.la-spr"
join365= "access.la-sprd" "access.cm-bldg" "OF access.la-sprd"
join366= "access.la-sprd" "access.cm-ten" "OF access.la-sprd"
join367= "access.la-sprd" "access.cm-unit" "OF access.la-sprd"
join368= "access.od-invest" "access.ap-vend" "OF access.od-invest"
join369= "access.po-ent" "access.gl-ent" "OF access.po-ent"
join370= "access.po-po" "access.ap-terms" "OF access.po-po"
join371= "access.po-po" "access.ap-vend" "OF access.po-po"
join372= "access.po-pod" "access.gl-acct" "OF access.po-pod"
join373= "access.po-pod" "access.gl-ent" "OF access.po-pod"
join374= "access.rm-adjcd" "access.gl-acct" "OF access.rm-adjcd"
join375= "access.rm-adjcd" "access.gl-subacc" "OF access.rm-adjcd"
join376= "access.rm-adjcd" "access.rm-chgcd" "OF access.rm-adjcd"
join377= "access.rm-batch" "access.gl-bank" "OF access.rm-batch"
join378= "access.rm-batch" "access.rm-chg" "OF access.rm-batch"
join379= "access.rm-batch" "access.rm-cred" "OF access.rm-batch"
join380= "access.rm-batch" "access.rm-rcpt" "OF access.rm-batch"
join381= "access.rm-batch" "access.rm-vac" "OF access.rm-batch"
join382= "access.rm-bldg" "access.gl-bank" "OF access.rm-bldg"
join383= "access.rm-bldg" "access.gl-ent" "OF access.rm-bldg"
join384= "access.rm-bldg" "access.rm-bldgd" "OF access.rm-bldg"
join385= "access.rm-bldg" "access.rm-bldgi" "OF access.rm-bldg"
join386= "access.rm-bldg" "access.rm-bldgt" "OF access.rm-bldg"
join387= "access.rm-bldg" "access.rm-res" "OF access.rm-bldg"
join388= "access.rm-bldg" "access.rm-unit" "OF access.rm-bldg"
join389= "access.rm-bldg" "access.rw-wo" "OF access.rm-bldg"
join390= "access.rm-bldgd" "access.rm-bldg" "OF access.rm-bldgd"
join391= "access.rm-bldgi" "access.rm-bldg" "OF access.rm-bldgi"
join392= "access.rm-bldgt" "access.rm-bldg" "OF access.rm-bldgt"
join393= "access.rm-chg" "access.rm-adjcd" "OF access.rm-chg"
join394= "access.rm-chg" "access.rm-batch" "OF access.rm-chg"
join395= "access.rm-chg" "access.rm-bldg" "OF access.rm-chg"
join396= "access.rm-chg" "access.rm-chgcd" "OF access.rm-chg"
join397= "access.rm-chg" "access.rm-credd" "OF access.rm-chg"
join398= "access.rm-chg" "access.rm-rcptd" "OF access.rm-chg"
join399= "access.rm-chg" "access.rm-res" "OF access.rm-chg"
join400= "access.rm-chg" "access.rm-unit" "OF access.rm-chg"
join401= "access.rm-chgcd" "access.rm-adjcd" "OF access.rm-chgcd"
join402= "access.rm-cred" "access.rm-adjcd" "OF access.rm-cred"
join403= "access.rm-cred" "access.rm-batch" "OF access.rm-cred"
join404= "access.rm-cred" "access.rm-bldg" "OF access.rm-cred"
join405= "access.rm-cred" "access.rm-chgcd" "OF access.rm-cred"
join406= "access.rm-cred" "access.rm-credd" "OF access.rm-cred"
join407= "access.rm-cred" "access.rm-res" "OF access.rm-cred"
join408= "access.rm-cred" "access.rm-unit" "OF access.rm-cred"
join409= "access.rm-credd" "access.rm-chg" "OF access.rm-credd"
join410= "access.rm-credd" "access.rm-cred" "OF access.rm-credd"
join411= "access.rm-credh" "access.rm-bldg" "OF access.rm-credh"
join412= "access.rm-credh" "access.rm-res" "OF access.rm-credh"
join413= "access.rm-credh" "access.rm-unit" "OF access.rm-credh"
join414= "access.rm-dchis" "access.rm-adjcd" "OF access.rm-dchis"
join415= "access.rm-dchis" "access.rm-bldg" "OF access.rm-dchis"
join416= "access.rm-dchis" "access.rm-chgcd" "OF access.rm-dchis"
join417= "access.rm-dchis" "access.rm-res" "OF access.rm-dchis"
join418= "access.rm-dchis" "access.rm-unit" "OF access.rm-dchis"
join419= "access.rm-dcinc" "access.rm-adjcd" "OF access.rm-dcinc"
join420= "access.rm-dcinc" "access.rm-bldg" "OF access.rm-dcinc"
join421= "access.rm-dcinc" "access.rm-chgcd" "OF access.rm-dcinc"
join422= "access.rm-dcinc" "access.rm-res" "OF access.rm-dcinc"
join423= "access.rm-dcinc" "access.rm-unit" "OF access.rm-dcinc"
join424= "access.rm-dciwr" "access.rm-adjcd" "OF access.rm-dciwr"
join425= "access.rm-dciwr" "access.rm-bldg" "OF access.rm-dciwr"
join426= "access.rm-dciwr" "access.rm-chgcd" "OF access.rm-dciwr"
join427= "access.rm-dciwr" "access.rm-res" "OF access.rm-dciwr"
join428= "access.rm-dciwr" "access.rm-unit" "OF access.rm-dciwr"
join429= "access.rm-dep" "access.rm-bldg" "OF access.rm-dep"
join430= "access.rm-dep" "access.rm-depcd" "OF access.rm-dep"
join431= "access.rm-dep" "access.rm-depd" "OF access.rm-dep"
join432= "access.rm-dep" "access.rm-rcptd" "OF access.rm-dep"
join433= "access.rm-dep" "access.rm-res" "OF access.rm-dep"
join434= "access.rm-dep" "access.rm-unit" "OF access.rm-dep"
join435= "access.rm-depd" "access.gl-acct" "OF access.rm-depd"
join436= "access.rm-depd" "access.gl-subacc" "OF access.rm-depd"
join437= "access.rm-depd" "access.rm-dep" "OF access.rm-depd"
join438= "access.rm-grp" "access.rm-adjcd" "OF access.rm-grp"
join439= "access.rm-grp" "access.rm-bldg" "OF access.rm-grp"
join440= "access.rm-grp" "access.rm-chgcd" "OF access.rm-grp"
join441= "access.rm-grp" "access.rm-res" "OF access.rm-grp"
join442= "access.rm-grp" "access.rm-unit" "OF access.rm-grp"
join443= "access.rm-inv" "access.rm-bldg" "OF access.rm-inv"
join444= "access.rm-inv" "access.rm-invh" "OF access.rm-inv"
join445= "access.rm-inv" "access.rm-unit" "OF access.rm-inv"
join446= "access.rm-invh" "access.rm-inv" "OF access.rm-invh"
join447= "access.rm-latef" "access.rm-adjcd" "OF access.rm-latef"
join448= "access.rm-latef" "access.rm-bldg" "OF access.rm-latef"
join449= "access.rm-latef" "access.rm-chgcd" "OF access.rm-latef"
join450= "access.rm-latef" "access.rm-res" "OF access.rm-latef"
join451= "access.rm-latef" "access.rm-unit" "OF access.rm-latef"
join452= "access.rm-lateh" "access.rm-adjcd" "OF access.rm-lateh"
join453= "access.rm-lateh" "access.rm-bldg" "OF access.rm-lateh"
join454= "access.rm-lateh" "access.rm-chgcd" "OF access.rm-lateh"
join455= "access.rm-lateh" "access.rm-res" "OF access.rm-lateh"
join456= "access.rm-lateh" "access.rm-unit" "OF access.rm-lateh"
join457= "access.rm-lockd" "access.rm-batch" "OF access.rm-lockd"
join458= "access.rm-lockd" "access.rm-lockh" "OF access.rm-lockd"
join459= "access.rm-lockh" "access.rm-lockd" "OF access.rm-lockh"
join460= "access.rm-mgmt" "access.rm-bldg" "OF access.rm-mgmt"
join461= "access.rm-mgmt" "access.rm-mgmtd" "OF access.rm-mgmt"
join462= "access.rm-mgmt" "access.rm-res" "OF access.rm-mgmt"
join463= "access.rm-mgmt" "access.rm-unit" "OF access.rm-mgmt"
join464= "access.rm-mgmtd" "access.rm-chgcd" "OF access.rm-mgmtd"
join465= "access.rm-mgmtd" "access.rm-mgmt" "OF access.rm-mgmtd"
join466= "access.rm-mort" "access.rm-bldg" "OF access.rm-mort"
join467= "access.rm-mort" "access.rm-res" "OF access.rm-mort"
join468= "access.rm-mort" "access.rm-unit" "OF access.rm-mort"
join469= "access.rm-mortd" "access.rm-mort" "OF access.rm-mortd"
join470= "access.rm-mortp" "access.rm-bldg" "OF access.rm-mortp"
join471= "access.rm-mortp" "access.rm-mort" "OF access.rm-mortp"
join472= "access.rm-mortp" "access.rm-res" "OF access.rm-mortp"
join473= "access.rm-mortp" "access.rm-unit" "OF access.rm-mortp"
join474= "access.rm-prep" "access.rm-adjcd" "OF access.rm-prep"
join475= "access.rm-prep" "access.rm-bldg" "OF access.rm-prep"
join476= "access.rm-prep" "access.rm-chgcd" "OF access.rm-prep"
join477= "access.rm-prep" "access.rm-prepd" "OF access.rm-prep"
join478= "access.rm-prep" "access.rm-rcpt" "OF access.rm-prep"
join479= "access.rm-prep" "access.rm-res" "OF access.rm-prep"
join480= "access.rm-prep" "access.rm-unit" "OF access.rm-prep"
join481= "access.rm-prepd" "access.rm-cred" "OF access.rm-prepd"
join482= "access.rm-prepd" "access.rm-prep" "OF access.rm-prepd"
join483= "access.rm-rcpt" "access.rm-batch" "OF access.rm-rcpt"
join484= "access.rm-rcpt" "access.rm-bldg" "OF access.rm-rcpt"
join485= "access.rm-rcpt" "access.rm-rcptd" "OF access.rm-rcpt"
join486= "access.rm-rcpt" "access.rm-res" "OF access.rm-rcpt"
join487= "access.rm-rcpt" "access.rm-unit" "OF access.rm-rcpt"
join488= "access.rm-rcptd" "access.gl-acct" "OF access.rm-rcptd"
join489= "access.rm-rcptd" "access.gl-subacc" "OF access.rm-rcptd"
join490= "access.rm-rcptd" "access.rm-chg" "OF access.rm-rcptd"
join491= "access.rm-rcptd" "access.rm-dep" "OF access.rm-rcptd"
join492= "access.rm-rcptd" "access.rm-depcd" "OF access.rm-rcptd"
join493= "access.rm-rcptd" "access.rm-rcpt" "OF access.rm-rcptd"
join494= "access.rm-rechg" "access.rm-adjcd" "OF access.rm-rechg"
join495= "access.rm-rechg" "access.rm-bldg" "OF access.rm-rechg"
join496= "access.rm-rechg" "access.rm-chgcd" "OF access.rm-rechg"
join497= "access.rm-rechg" "access.rm-res" "OF access.rm-rechg"
join498= "access.rm-res" "access.rm-bldg" "OF access.rm-res"
join499= "access.rm-res" "access.rm-credh" "OF access.rm-res"
join500= "access.rm-res" "access.rm-dep" "OF access.rm-res"
join501= "access.rm-res" "access.rm-lateh" "OF access.rm-res"
join502= "access.rm-res" "access.rm-mort" "OF access.rm-res"
join503= "access.rm-res" "access.rm-mortp" "OF access.rm-res"
join504= "access.rm-res" "access.rm-rechg" "OF access.rm-res"
join505= "access.rm-res" "access.rm-resa" "OF access.rm-res"
join506= "access.rm-res" "access.rm-resc" "OF access.rm-res"
join507= "access.rm-res" "access.rm-resd" "OF access.rm-res"
join508= "access.rm-res" "access.rm-resdl" "OF access.rm-res"
join509= "access.rm-res" "access.rm-resr" "OF access.rm-res"
join510= "access.rm-res" "access.rm-rest" "OF access.rm-res"
join511= "access.rm-res" "access.rm-unit" "OF access.rm-res"
join512= "access.rm-res" "access.rr-ntv" "OF access.rm-res"
join513= "access.rm-res" "access.rw-wo" "OF access.rm-res"
join514= "access.rm-resa" "access.rm-bldg" "OF access.rm-resa"
join515= "access.rm-resa" "access.rm-res" "OF access.rm-resa"
join516= "access.rm-resa" "access.rm-unit" "OF access.rm-resa"
join517= "access.rm-resc" "access.rm-bldg" "OF access.rm-resc"
join518= "access.rm-resc" "access.rm-res" "OF access.rm-resc"
join519= "access.rm-resc" "access.rm-unit" "OF access.rm-resc"
join520= "access.rm-resd" "access.rm-bldg" "OF access.rm-resd"
join521= "access.rm-resd" "access.rm-res" "OF access.rm-resd"
join522= "access.rm-resd" "access.rm-unit" "OF access.rm-resd"
join523= "access.rm-resdl" "access.rm-bldg" "OF access.rm-resdl"
join524= "access.rm-resdl" "access.rm-res" "OF access.rm-resdl"
join525= "access.rm-resdl" "access.rm-unit" "OF access.rm-resdl"
join526= "access.rm-resr" "access.rm-bldg" "OF access.rm-resr"
join527= "access.rm-resr" "access.rm-res" "OF access.rm-resr"
join528= "access.rm-resr" "access.rm-unit" "OF access.rm-resr"
join529= "access.rm-rest" "access.rm-bldg" "OF access.rm-rest"
join530= "access.rm-rest" "access.rm-res" "OF access.rm-rest"
join531= "access.rm-rest" "access.rm-tklr" "OF access.rm-rest"
join532= "access.rm-rest" "access.rm-unit" "OF access.rm-rest"
join533= "access.rm-tklr" "access.rm-bldgt" "OF access.rm-tklr"
join534= "access.rm-tklr" "access.rm-rest" "OF access.rm-tklr"
join535= "access.rm-tklr" "access.rm-unitt" "OF access.rm-tklr"
join536= "access.rm-unit" "access.rm-bldg" "OF access.rm-unit"
join537= "access.rm-unit" "access.rm-res" "OF access.rm-unit"
join538= "access.rm-unit" "access.rm-unitd" "OF access.rm-unit"
join539= "access.rm-unit" "access.rm-unitf" "OF access.rm-unit"
join540= "access.rm-unit" "access.rm-unitm" "OF access.rm-unit"
join541= "access.rm-unit" "access.rm-unito" "OF access.rm-unit"
join542= "access.rm-unit" "access.rm-unitt" "OF access.rm-unit"
join543= "access.rm-unit" "access.rw-wo" "OF access.rm-unit"
join544= "access.rm-unitd" "access.rm-bldg" "OF access.rm-unitd"
join545= "access.rm-unitd" "access.rm-chgcd" "OF access.rm-unitd"
join546= "access.rm-unitd" "access.rm-unit" "OF access.rm-unitd"
join547= "access.rm-unitm" "access.rm-bldg" "OF access.rm-unitm"
join548= "access.rm-unitm" "access.rm-res" "OF access.rm-unitm"
join549= "access.rm-unitm" "access.rm-unit" "OF access.rm-unitm"
join550= "access.rm-unito" "access.rm-bldg" "OF access.rm-unito"
join551= "access.rm-unito" "access.rm-unit" "OF access.rm-unito"
join552= "access.rm-unitt" "access.rm-bldg" "OF access.rm-unitt"
join553= "access.rm-unitt" "access.rm-tklr" "OF access.rm-unitt"
join554= "access.rm-unitt" "access.rm-unit" "OF access.rm-unitt"
join555= "access.rm-vac" "access.rm-adjcd" "OF access.rm-vac"
join556= "access.rm-vac" "access.rm-batch" "OF access.rm-vac"
join557= "access.rm-vac" "access.rm-bldg" "OF access.rm-vac"
join558= "access.rm-vac" "access.rm-chgcd" "OF access.rm-vac"
join559= "access.rm-vac" "access.rm-unit" "OF access.rm-vac"
join560= "access.rr-app" "access.rr-info" "OF access.rr-app"
join561= "access.rw-chg" "access.rw-wo" "OF access.rw-chg"
join562= "access.rw-mnt" "access.rw-schd" "OF access.rw-mnt"
join563= "access.rw-mnt" "access.rw-vac" "OF access.rw-mnt"
join564= "access.rw-mnt" "access.rw-wo" "OF access.rw-mnt"
join565= "access.rw-pers" "access.rw-wo" "OF access.rw-pers"
join566= "access.rw-sat" "access.rw-wo" "OF access.rw-sat"
join567= "access.rw-schd" "access.rw-schdd" "OF access.rw-schd"
join568= "access.rw-vac" "access.rw-vacd" "OF access.rw-vac"
join569= "access.rw-wo" "access.rw-woi" "OF access.rw-wo"
*/
C. Denny Brookwell
Nextnet Hosting, Inc.