Can the address fields (particularly, the City field) be updated in Tess thru the backend by a query? And if so, what table(s) are involved. We have a website connected to Tess that is allowing free-form entry of Addresses and is dirtying the Cities data with misspellings, thus multiple iterations of the same city are appearing in the T-Stats summaries.
Hi Randall,
Good day.
it is t_address table.
SELECT address_no, customer_no, address_type, street1, street2, city, state, postal_code, country, start_dt, end_dt, months, primary_ind, inactive, alt_signor,mail_purposes, label, geo_area, create_loc, created_by, create_dt, last_updated_by, last_update_dt, delivery_point, ncoa_session, ncoa_actionFROM T_ADDRESS
It is almost free to update. Modifications can be seen in "Audit" under "Tranactions" tab.
try to correct the address is always a problem.
You can use some third party softwares, or someone else has to manually fix them.
or fix the website, make user select a city from dropdown list, in this case, you need a small table to keep the city names .
have fun.
Ben
Thanks Ben, I was fairly certain it could be done, but I don't have access to the backend as we operate in a consortium.