| field name | data type | description |
|---|---|---|
| Contact_ID | integer | |
| Lng_ID | integer | |
| Address_ID | integer | |
| BusinessRelation_ID | integer | |
| ContactFunction | character | Function. The function of the contact to the address. This field can be blank. |
| ContactName | character | Name. The full name of the contact. This field is mandatory. |
| ContactInitials | character | Initials. The initials of the contact. This field can be blank. |
| ContactGender | character | Gender. indicates whether the contact is male or femail. This field is mandatory |
| ContactTitle | character | Title. Title of the contact. This field can be blank. |
| ContactTelephone | character | Telephone. The telephone number of the contact. This field can be blank. |
| ContactMobilePhone | character | Mobile. The mobile phone number of the contact. This field can be blank. |
| ContactEmail | character | E-mail. The E-Mail address of the contact. This field can be blank. |
| ContactFax | character | Fax. The fax or telex number to use when sending documents to the contact. This field can be blank. |
| ContactIsPrimary | logical | 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 | |
| ContactIsSecondary | logical | 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 | |
| tcLngCode | character | Language Code. A code identifying the language used by this contact. |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |