project QadFinancials > class BBusinessRelation > business logic query AddressForInvoiceDefault
Description
This query returns address info and business relation name and addresstypecode.
Parameters
iiBusinessRelationId | integer | |
icAddressTypeCode | character | |
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 name | data type | db field | description |
tiAddress_ID | integer | Address.Address_ID | Record ID |
tcAddressTypeCode | character | AddressType.AddressTypeCode | Address Type |
tiBusinessRelation_ID | integer | Address.BusinessRelation_ID | Link to BusinessRelation |
tcCountryCode | character | Country.CountryCode | Country Code |
tlCountryIsEUCountry | logical | Country.CountryIsEUCountry | EU Member |
Internal usage
QadFinancials