business logic query AddressForCreditor

Description

This query returns address info and business relation name by sevral address paramenters for creditor.

Parameters

icAddressCity	character
icAddressCountry	character
icAddressLine	character
icAddressSearchName	character
icAddressTypeCode	character
icAddressZip	character
icBusinessRelationName	character
iiCompanyId	integer	Company id
icAddressName	character
iiAddressID	integer

query condition

each Address where

Address.AddressName = icAddressName AND
Address.AddressSearchName = icAddressSearchName AND
Address.AddressCity = icAddressCity AND
Address.AddressZip = icAddressZip AND
Address.AddressStreet1 = icAddressLine AND
Address.Address_ID = iiAddressID

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
BusinessRelation.BusinessRelationName1 = icBusinessRelationName

each Creditor (inner-join) where

Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first Country (inner-join) where

Country.Country_ID = Address.Country_ID AND
Country.CountryCode = icAddressCountry

query resultset tqAddressForCreditor

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	BusinessRelation.BusinessRelation_ID	Record ID
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.
tlBusinessRelationIsActive	logical	BusinessRelation.BusinessRelationIsActive	Active: This field indicates if this is an active record.
	api annotation:		PartialUpdate = yes - defaults to true.
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.
tcCountryCode	character	Country.CountryCode	Country Code
tiCreditor_ID	integer	Creditor.Creditor_ID	Record ID
tcCreditorCode	character	Creditor.CreditorCode	Supplier Code
tlCreditorIsActive	logical	Creditor.CreditorIsActive	Active
tlCreditorIsTaxReport	logical	Creditor.CreditorIsTaxReport	Tax Report

Internal usage

QadFinancials

method BBankImportLine.GetCreditorByBankImpLine
method BBusinessRelation.ValidateComponentPostAddress
dataset BBankImportLine.tAddressForCreditor