| iiBusinessRelationId | integer | |
| icAddressTypeCode | character |
each Address where
first AddressType (inner-join) where
first BusinessRelation (inner-join) where
first Country (inner-join) where
first County (conditional-join) where
first Lng (outer-join) where
first State (conditional-join) where
| field name | data type | db field | description |
|---|---|---|---|
| tiAddress_ID | integer | Address.Address_ID | Record ID |
| 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. |
| tiAddressFormat | integer | Address.AddressFormat | Format. This field determines where postal codes display on printed addresses. |
| api annotation: | PartialUpdate = yes - defaults to the value for the same field defined for the country. | ||
| tlAddressIsSendToPostal | logical | Address.AddressIsSendToPostal | Obsolete field |
| tlAddressIsTaxable | logical | Address.AddressIsTaxable | Taxable Address. This field indicates if business activities for this address are normally subject to tax. The taxable status of the address defaults to transactions where the address is used. |
| api annotation: | PartialUpdate = yes - defaults to false. | ||
| tlAddressIsTemporary | logical | Address.AddressIsTemporary | Temporary. If the type of this address is ship-to or dock, this field indicates if the address is temporary. This field is for reference and can be useful for sorting and filtering records. |
| api annotation: | PartialUpdate = yes - defaults to false. | ||
| 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. | ||
| tcAddressPostalAddress1 | character | Address.AddressPostalAddress1 | Obsolete field |
| tcAddressPostalAddress2 | character | Address.AddressPostalAddress2 | Obsolete field |
| tcAddressPostalCity | character | Address.AddressPostalCity | Obsolete field |
| tcAddressPostalZip | character | Address.AddressPostalZip | Obsolete field |
| tcAddressSearchName | character | Address.AddressSearchName | Search Name. An alternate name for finding this address. The searchname of a headoffice address is the same as the business relationship and can not be modified. |
| api annotation: | PartialUpdate = yes - defaults to the searchname of the businessRelation. | ||
| tcAddressState | character | Address.AddressState | Obsolete field |
| tcAddressStreet1 | character | Address.AddressStreet1 | Address: Line one of address details. This field can be blank. |
| tcAddressStreet2 | character | Address.AddressStreet2 | Address.Line two of address details. This field can be blank. |
| tcAddressStreet3 | character | Address.AddressStreet3 | Address.Line three 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. |
| tiAddressType_ID | integer | Address.AddressType_ID | Address Type |
| tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
| tcAddressWebSite | character | Address.AddressWebSite | Internet. This field indicates the Web site of this business relation. 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. |
| tiBusinessRelation_ID | integer | Address.BusinessRelation_ID | Link to BusinessRelation |
| tcBusinessRelationCode | character | BusinessRelation.BusinessRelationCode | Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create. |
| tcBusinessRelationName1 | character | BusinessRelation.BusinessRelationName1 | Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers. |
| api annotation: | PartialUpdate = yes - defaults to the BusinessRelationCode. | ||
| tcBusinessRelationName2 | character | BusinessRelation.BusinessRelationName2 | Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank. |
| tiCountry_ID | integer | Country.Country_ID | Record ID |
| tcCountryCode | character | Country.CountryCode | Country Code |
| tcCountryDescription | character | Country.CountryDescription | Description |
| tlCountryIsEUCountry | logical | Country.CountryIsEUCountry | EU Member |
| tiCounty_ID | integer | County.County_ID | Record ID |
| tcCountyCode | character | County.CountyCode | County Code |
| tcCountyDescription | character | County.CountyDescription | Description |
| tiLng_ID | integer | Address.Lng_ID | Language Code |
| tcLngCode | character | Lng.LngCode | Language Code |
| tiState_ID | integer | State.State_ID | Record ID |
| tcStateCode | character | State.StateCode | State |
| tcStateDescription | character | State.StateDescription | Description |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Country),rowid(County),rowid(Lng),rowid(State) |
QadFinancials