business logic query CompanyPropertyByCompanyId

Parameters

iiCompanyId	integer	Company id
icAddressTypeCode	character

query condition

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId 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

first Country (inner-join) where

Country.Country_ID = Address.Country_ID AND

first County (outer-join) where

County.County_ID = Address.County_ID AND

first Lng (inner-join) where

Lng.Lng_ID = BusinessRelation.Lng_ID AND

query resultset tqCompanyPropertyByCompanyId

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.
tcAddressStreet2	character	Address.AddressStreet2	Address.Line two of address details. This field can be blank.
tcAddressStreet3	character	Address.AddressStreet3	Address.Line three of address details. 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.
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.
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.
tcBusinessRelationName2	character	BusinessRelation.BusinessRelationName2	Second Name. An extended name when the Name field is not large enough to contain all information. This fielsd can be blank.
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tiCountry_ID	integer	Country.Country_ID	Record ID
tcCountryDescription	character	Country.CountryDescription	Description
tiCounty_ID	integer	County.County_ID	Record ID
tcCountyDescription	character	County.CountyDescription	Description
tcLngCode	character	Lng.LngCode	Language Code

Internal usage

QadFinancials

method BCDocumentReport.CDocumentReportAll