project QadFinancials > class BMfgAddress > business logic query AdMstrByAddress

Description

retrieves all ad_mstr records based on the domain and the address


Parameters


icDomaincharacterDomain Code
icCodecharacterparameter to select on the address code (ad_addr)


query condition


  each ad_mstr where
ad_mstr.ad_domain = icDomain AND
ad_mstr.ad_addr = icCode

      first Address (inner-join) where
Address.Address_ID = ad_mstr.ad_address_id AND

          first AddressType (inner-join) where
AddressType.AddressType_ID = Address.AddressType_ID AND

          first BusinessRelation (inner-join) where
BusinessRelation.BusinessRelation_ID = Address.BusinessRelation_ID AND

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


query resultset tqAdMstrByAddress


field namedata typedb fielddescription
tcad_addrcharacterad_mstr.ad_addrAddress
tiad_address_idintegerad_mstr.ad_address_idAddress ID
tcad_domaincharacterad_mstr.ad_domainDomain
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.
tcAddressCountycharacterAddress.AddressCountyObsolete field
tcAddressEMailcharacterAddress.AddressEMailE-Mail. This field indicates the e-mail address associated with this business relation.
This field can be blank.
tcAddressFaxcharacterAddress.AddressFaxFax. This field indicates the fax or telex number to use when sending documents to this address.
This field can be balnk.
tlAddressIsTaxInCitylogicalAddress.AddressIsTaxInCityTax in City. This field determines whether the address is in the city limits for taxation purposes. It is used only with the Sales and Use Tax Interface for US and Canadian tax processing.
api annotation:PartialUpdate = yes - defaults to true.
tcAddressNamecharacterAddress.AddressNameName. The full name of this particular address.
The name of a headoffice address is the same as the name of the business relationship and can not be modified.
api annotation:PartialUpdate = yes - defaults to the name of the businessRelation.
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.
tcAddressTelephonecharacterAddress.AddressTelephoneTelephone. The telephone number for calling this business relation address.
This field can be blank.
tcAddressTypeCodecharacterAddressType.AddressTypeCodeAddress Type
tcAddressWebSitecharacterAddress.AddressWebSiteInternet. This field indicates the Web site of this business relation.
This field can be blank.
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.
tiCountry_IDintegerCountry.Country_IDRecord ID
tcCountryCodecharacterCountry.CountryCodeCountry Code
tcCountryDescriptioncharacterCountry.CountryDescriptionDescription
tlCountryIsEUCountrylogicalCountry.CountryIsEUCountryEU Member
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 BCInvoice.AddCInvoicePO
method BCInvoice.DefaultValuesPO