tcBusinessFieldName | tcDataType | tcOperator |
---|---|---|
iiBusinessRelationId | i | = |
icBusinessRelationCode | c | = |
icAddressType | c | = |
tAddress.AddressCity | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressEMail | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressFax | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressStreet1 | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressTelephone | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tAddress.AddressZip | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tContact.ContactEmail | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tContact.ContactFax | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tContact.ContactName | c | =,>=,>,<>,<=,<,begins,can-do,matches |
tContact.ContactTelephone | c | =,>=,>,<>,<=,<,begins,can-do,matches |
iiBusinessRelationId | integer | |
icBusinessRelationCode | character | |
icAddressType | character |
field name | data type | db field | description |
---|---|---|---|
tcAddressCity | character | Address.AddressCity | City. The city for this address. This field can be used to decide the tax zone of the address. |
tcAddressEMail | character | Address.AddressEMail | E-Mail. This field indicates the e-mail address associated with this business relation. This field can be blank. |
tcAddressFax | character | Address.AddressFax | Fax. This field indicates the fax or telex number to use when sending documents to this address. This field can be balnk. |
tcAddressName | character | Address.AddressName | Name. The full name of this particular address. The name of a headoffice address is the same as the name of the business relationship and can not be modified. |
api annotation: | PartialUpdate = yes - defaults to the name of the businessRelation. | ||
tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one of address details. This field can be blank. |
tcAddressTelephone | character | Address.AddressTelephone | Telephone. The telephone number for calling this business relation address. This field can be blank. |
tcAddressZip | character | Address.AddressZip | Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank. |
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. |
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. |
AddressCustom | character | calculated | custom fields |
ContactCustom | character | calculated | custom fields |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Contact) |