business logic query AddressByCountryID

Description

This query that returns the elementary information on the address and the linked business-realtion based on the country-id of the address.

iiCountryID

integer

each Address where

Address.Country_ID = iiCountryID

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Address.BusinessRelation_ID AND

field name	data type	db field	description
tiBusinessRelation_ID	integer	Address.BusinessRelation_ID	Link to BusinessRelation
tiAddress_ID	integer	Address.Address_ID	Record ID
tiCountry_ID	integer	Address.Country_ID	Country Format
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.
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.

QadFinancials