project QadFinancials > class BDebtorEndUser > dataset tDebtorEndUserContact

table tDebtorEndUserContact

Description

Holds all the contacts assoicated with the address on the DebtorEndUser table. The parentrowid should point to the debtorenduser.tc_rowid value.

field namedata typedescription
Contact_IDinteger
Lng_IDinteger
Address_IDinteger
BusinessRelation_IDinteger
ContactFunctioncharacterFunction. The function of the contact to the address.
This field can be blank.
ContactNamecharacterName. The full name of the contact.
This field is mandatory.
ContactInitialscharacterInitials. The initials of the contact.
This field can be blank.
ContactGendercharacterGender. indicates whether the contact is male or femail.
This field is mandatory
ContactTitlecharacterTitle. Title of the contact.
This field can be blank.
ContactTelephonecharacterTelephone. The telephone number of the contact.
This field can be blank.
ContactMobilePhonecharacterMobile. The mobile phone number of the contact.
This field can be blank.
ContactEmailcharacterE-mail. The E-Mail address of the contact.
This field can be blank.
ContactFaxcharacterFax. The fax or telex number to use when sending documents to the contact.
This field can be blank.
ContactIsPrimarylogicalPrimary 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
ContactIsSecondarylogicalSecondary 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
tcLngCodecharacterLanguage Code. A code identifying the language used by this contact.
CustomShort0character
CustomShort1character
CustomShort2character
CustomShort3character
CustomShort4character
CustomShort5character
CustomShort6character
CustomShort7character
CustomShort8character
CustomShort9character
CustomCombo0character
CustomCombo1character
CustomCombo2character
CustomCombo3character
CustomCombo4character
CustomCombo5character
CustomCombo6character
CustomCombo7character
CustomCombo8character
CustomCombo9character
CustomLong0character
CustomLong1character
CustomNotecharacter
CustomDate0date
CustomDate1date
CustomDate2date
CustomDate3date
CustomDate4date
CustomInteger0integer
CustomInteger1integer
CustomInteger2integer
CustomInteger3integer
CustomInteger4integer
CustomDecimal0decimal(4)
CustomDecimal1decimal(4)
CustomDecimal2decimal(4)
CustomDecimal3decimal(4)
CustomDecimal4decimal(4)
LastModifiedDatedate
LastModifiedTimeinteger
LastModifiedUsercharacter
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


unused