business logic query AddressByDebtorAddressType

Description

This query returns the address info for the Detor of addresstype.

Parameters

iiCompanyId	integer	Company id
iiDebtorId	integer
icAddressSearchName	character
icAddressName	character
icAddressTypeCode	character

query condition

each Address where

Address.AddressName = icAddressName AND
Address.AddressSearchName = icAddressSearchName

first AddressType (inner-join) where

AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = icAddressTypeCode

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = Address.BusinessRelation_ID AND

each Debtor (inner-join) where

Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND
Debtor.Debtor_ID = iiDebtorId

query resultset tqAddressByDebtorAddressType

field name	data type	db field	description
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.
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.
tiAddressType_ID	integer	Address.AddressType_ID	Address Type
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
tiBusinessRelation_ID	integer	Address.BusinessRelation_ID	Link to BusinessRelation
tiBusinessRelation_ID2	integer	BusinessRelation.BusinessRelation_ID	Record ID
tiDebtor_ID	integer	Debtor.Debtor_ID	Record ID

Internal usage

QadFinancials

method BBankImportLine.AdditionalUpdates