Page 1 of 1
Other Contact Types
Posted: Tue Mar 12, 2024 11:23 am
by tkoenitzer
How do I access the Other's contact type's specific contact type via the database.
Other(Notary)
Other(Tax Collector)
Thanks,
Tim
Re: Other Contact Types
Posted: Tue Mar 12, 2024 11:35 am
by brandon.ritchie
The pfm.Contact table has a field "OtherType" which has this value for other contact types (ContactType=16).
SELECT OtherType, [Name] FROM pfm.Contact WHERE ContactType = 16
Re: Other Contact Types
Posted: Tue Mar 12, 2024 11:52 am
by Lisa Ennis
It is in the pfm.Contact table, the field is OtherType. It is the last field in the Select statement below.
Code: Select all
SELECT
C.RootId#,
C.Id#,
C.LastId#,
C.Code,
C.ContactType,
C.Name,
C.NameShort,
C.OtherType
FROM
pfm.[Contact] AS C
Hope this helps!