• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 42 views
  • Users 0 members are here
Related

tr_citystate default indicator

Former Member
Former Member $organization

Hi,

We have two different cities with the same zip5 and default ind 'Y'.  If I change the default of one to "N", will that city-state no longer be assigned to new accounts with that zip5?  And will changing the default have any adverse impact on accounts with that city?

Thanks in advance for clarification.

Jeri

Parents
  • Former Member
    Former Member $organization
    I found out about the new zips from our ticket office then confirmed with USPS.  An automated way would be great and I would also be interested if anyone is doing that. 

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Friday, August 19, 2011 10:51 PM
    To: Jeri Henderson
    Subject: RE: [Tessitura Technical Forum] tr_citystate default indicator

    Curious about refreshing tr_citystate: do you get new zips from a vendor? I'd love to have a regular way to update that table with data from USPS or something like that.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 8/18/2011 2:14:40 PM

    You're welcome!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Reply
  • Former Member
    Former Member $organization
    I found out about the new zips from our ticket office then confirmed with USPS.  An automated way would be great and I would also be interested if anyone is doing that. 

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
    Sent: Friday, August 19, 2011 10:51 PM
    To: Jeri Henderson
    Subject: RE: [Tessitura Technical Forum] tr_citystate default indicator

    Curious about refreshing tr_citystate: do you get new zips from a vendor? I'd love to have a regular way to update that table with data from USPS or something like that.

    From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com>
    Sent: 8/18/2011 2:14:40 PM

    You're welcome!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Children
No Data