business logic query GetCompanyAddress

Parameters

iiCompanyId	integer	Company id
icAddressTypeCode	character	Address Type
ilContactIsPrimary	logical	contact is primary ?
icCompanyCode	character

query condition

each Company where

Company.Company_Id = iiCompanyId AND
Company.CompanyCode = icCompanyCode

each CompanyProperty (inner-join) where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.Company_ID = Company.Company_ID AND

first BusinessRelation (inner-join) where

BusinessRelation.BusinessRelation_ID = CompanyProperty.BusinessRelation_ID AND

each Address (inner-join) where

Address.BusinessRelation_ID = BusinessRelation.BusinessRelation_ID AND

first AddressType (inner-join) where

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

each Contact (conditional-join) where

Contact.Address_ID = Address.Address_ID AND
Contact.ContactIsPrimary = ilContactIsPrimary

first State (conditional-join) where

State.State_ID = Address.State_ID AND

query resultset tqGetCompanyAddress

field name	data type	db field	description
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tiAddressFormat	integer	Address.AddressFormat	Format. This field determines where postal codes display on printed addresses.
	api annotation:		PartialUpdate = yes - defaults to the value for the same field defined for the country.
tcAddressStreet1	character	Address.AddressStreet1	Address: Line one of address details. This field can be blank.
tcAddressTaxIDState	character	Address.AddressTaxIDState	State Tax. This field is for reference and documentation purposes, the value of the field is either a state or provincial tax identification number or a VAT registration number.
tcAddressTelephone	character	Address.AddressTelephone	Telephone. The telephone number for calling this business relation address. This field can be blank.
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
tcAddressZip	character	Address.AddressZip	Zip. The postal code or US zip code associated with this address. This field is used to decide the tax zone for the address. This field can be blank.
tiCompany_ID	integer	Company.Company_ID	Record ID
tcCompanyCode	character	Company.CompanyCode	Entity Code
tcContactEmail	character	Contact.ContactEmail	E-mail. The E-Mail address of the contact. This field can be blank.
tcContactFunction	character	Contact.ContactFunction	Function. The function of the contact to the address. This field can be blank.
tlContactIsPrimary	logical	Contact.ContactIsPrimary	Primary Contact. This field indicates if the contact is the primary contact of the address. Only one primary contact per address type is allowed.
	api annotation:		PartialUpdate = yes - defaults to false
tcContactMobilePhone	character	Contact.ContactMobilePhone	Mobile. The mobile phone number of the contact. This field can be blank.
tcContactName	character	Contact.ContactName	Name. The full name of the contact. This field is mandatory.
tcContactTelephone	character	Contact.ContactTelephone	Telephone. The telephone number of the contact. This field can be blank.
tiState_ID	integer	Address.State_ID	Description
tcStateCode	character	State.StateCode	State

Internal usage

QadFinancials

method BDebtorReport.DebtorAccountState
method BDebtorReport.DebtorInvoicePrint
method BDebtorReport.DebtorReminders