project QadFinancials > class BBusinessRelation > business logic query AddressForInvoiceDefault

Description

This query returns address info and business relation name and addresstypecode.


Parameters


iiBusinessRelationIdinteger
icAddressTypeCodecharacter


query condition


  each Address where
Address.BusinessRelation_ID = iiBusinessRelationId

      first AddressType (inner-join) where
AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = icAddressTypeCode

      first Country (inner-join) where
Country.Country_ID = Address.Country_ID AND


query resultset tqAddressForInvoiceDefault


field namedata typedb fielddescription
tiAddress_IDintegerAddress.Address_IDRecord ID
tcAddressTypeCodecharacterAddressType.AddressTypeCodeAddress Type
tiBusinessRelation_IDintegerAddress.BusinessRelation_IDLink to BusinessRelation
tcCountryCodecharacterCountry.CountryCodeCountry Code
tlCountryIsEUCountrylogicalCountry.CountryIsEUCountryEU Member


Internal usage


QadFinancials
method BCInvoice.DefaultValuesSupplier
method BCInvoice.RestoreUIProcessDataForCInvoice
method BDInvoice.DefaultValuesDebtor