ContactType

Created by: Lester Caine, Last modification: 14 Oct 2010 (00:21 BST)

The base of the contact type table should be recognisable from the commerce table that it evolved from. It is expected that this will be expanded with view information to go with a particular type of contact. Some of the types may also be cross-ref types, since an alarm maintainer will be cross referenced to the contacts who they maintain, or keyholders may be referenced to a number of properties.

CONTACT_TY      PE_ID TYPE_NAME
0 Personal
1 Business
2 Manufacturer
3 Distributor
4 Supplier
5 Record Company
6 Record Artist
7 Cartographer
8 PHX Client
9 LSCES Supplier
10 Paypal Client