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