project QadFinancials > class BCompanyProperty > business logic query CompanyPropertyForSiteAddress

Description

CompanyPropertyForSiteAddress : show the address information for the site you pass through it


Parameters


iiCompanyIdintegerCompany id
icDomainCodecharacterdomain Code
icSitecharacterSite


query condition


  each CompanyProperty where
CompanyProperty.Company_Id = iiCompanyId AND

      each si_mstr (inner-join) where
si_mstr.si_entity = CompanyProperty.CompanyPropertyCode AND
si_mstr.si_domain = icDomainCode AND
si_mstr.si_site = icSite

          each ls_mstr (inner-join) where
ls_mstr.ls_domain = si_mstr.si_domain AND
ls_mstr.ls_addr = si_mstr.si_site AND
ls_mstr.ls_type = 'company' AND

              first ad_mstr (inner-join) where
ad_mstr.ad_addr = ls_mstr.ls_addr AND
ad_mstr.ad_domain = ls_mstr.ls_domain AND

                  first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelationCode = ad_mstr.ad_bus_relation 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

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


query sort order


CompanyProperty.CompanyPropertyCode (ascending)


query resultset tqCompanyPropertyForSiteAddress


field namedata typedb fielddescription
tiAddress_IDintegerAddress.Address_IDRecord ID
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressStatecharacterAddress.AddressStateObsolete field
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressStreet2characterAddress.AddressStreet2Address.Line two of address details.
This field can be blank.
tcAddressStreet3characterAddress.AddressStreet3Address.Line three of address details.
This field can be blank.
tcAddressTaxIDStatecharacterAddress.AddressTaxIDStateState 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.
tcAddressTypeCodecharacterAddressType.AddressTypeCodeAddress Type
tcAddressZipcharacterAddress.AddressZipZip. 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.
tcBusinessRelationCodecharacterBusinessRelation.BusinessRelationCodeBusiness 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.
tiCompanyProperty_IDintegerCompanyProperty.CompanyProperty_IDRecord ID
tcCompanyPropertyActCheckpcharacterCompanyProperty.CompanyPropertyActCheckpActivity Sheets Checkpoint
tcCompanyPropertyCodecharacterCompanyProperty.CompanyPropertyCodeEntity Code
tcCountryCodecharacterCountry.CountryCodeCountry Code
tlCountryIsEUCountrylogicalCountry.CountryIsEUCountryEU Member
tcsi_domaincharactersi_mstr.si_domainDomain
tcsi_sitecharactersi_mstr.si_siteSite
tcTxzTaxZonecharacterAddress.TxzTaxZoneTax Zone. This field indicates the tax zone for this address. This field is mandatory.
api annotation:PartialUpdate = yes - defaults to a value the system searches for based on the country, state or province, county, city, and postal code of the current address.


Internal usage


QadFinancials
method BDInvoice.DefaultValuesShipFromShipTo