| iiBusinessRelation_ID | integer |
each Contact where
| field name | data type | db field | description |
|---|---|---|---|
| tiAddress_ID | integer | Contact.Address_ID | Link to Address |
| tiBusinessRelation_ID | integer | Contact.BusinessRelation_ID | Link to BusinessRelation |
| tiContact_ID | integer | Contact.Contact_ID | Record ID |
| tcContactEmail | character | Contact.ContactEmail | E-mail. The E-Mail address of the contact. This field can be blank. |
| tcContactFax | character | Contact.ContactFax | Fax. The fax or telex number to use when sending documents to the contact. This field can be blank. |
| tcContactFunction | character | Contact.ContactFunction | Function. The function of the contact to the address. This field can be blank. |
| tcContactGender | character | Contact.ContactGender | Gender. indicates whether the contact is male or femail. This field is mandatory |
| tcContactInitials | character | Contact.ContactInitials | Initials. The initials of the contact. This field can be blank. |
| tlContactIsPrimary | logical | Contact.ContactIsPrimary | Primary Contact. This field indicates if the contact is the primary contact of the address. Only one primary contact per address type is allowed. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| tlContactIsSecondary | logical | Contact.ContactIsSecondary | Secondary Contact. This field indicates if the contact is the primary contact of the address. Only one secondary contact per address type is allowed. |
| api annotation: | PartialUpdate = yes - defaults to false | ||
| tcContactMobilePhone | character | Contact.ContactMobilePhone | Mobile. The mobile phone number of the contact. This field can be blank. |
| tcContactName | character | Contact.ContactName | Name. The full name of the contact. This field is mandatory. |
| tcContactTelephone | character | Contact.ContactTelephone | Telephone. The telephone number of the contact. This field can be blank. |
| tcContactTitle | character | Contact.ContactTitle | Title. Title of the contact. This field can be blank. |
| ttLastModifiedDate | date | Contact.LastModifiedDate | Last Modified Date |
| tiLastModifiedTime | integer | Contact.LastModifiedTime | Last Modified Time |
| tcLastModifiedUser | character | Contact.LastModifiedUser | Last Modified User |
| tiLng_ID | integer | Contact.Lng_ID | Language Code |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Contact) |
QadFinancials