project QadFinancials > class BBusinessRelation > business logic query AddressPrim

Description

This query returns primary addressinfo by logic key.


Parameters


icAddressCitycharacter
icAddressStreet1character
icAddressStreet2character
icAddressZipcharacter
icAddressTypeCodecharacter
iiAddressIDinteger
iiBusinessRelationIDinteger
icBusinessRelationCodecharacter
iiAddressTypeIDintegerAddressTypeID
icAddressStreet3character


query condition


  each Address where
Address.AddressCity = icAddressCity AND
Address.AddressStreet1 = icAddressStreet1 AND
Address.AddressStreet2 = icAddressStreet2 AND
Address.AddressZip = icAddressZip AND
Address.BusinessRelation_ID = iiBusinessRelationID AND
Address.AddressType_ID = iiAddressTypeID AND
Address.Address_ID = iiAddressID AND
Address.AddressStreet3 = icAddressStreet3

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

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

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


query resultset tqAddressPrim


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.
tiAddressType_IDintegerAddress.AddressType_IDAddress Type
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.
tiBusinessRelation_IDintegerAddress.BusinessRelation_IDLink to BusinessRelation
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_IDintegerAddress.Country_IDCountry Format
tcCountryCodecharacterCountry.CountryCodeCountry Code
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Country)


Internal usage


QadFinancials
method BBankImportLine.AdditionalUpdates
method BBusinessRelation.ValidateComponentPre
method BDebtorEndUser.Calculate
method BDebtorEndUser.ValidateComponent
method BDebtorShipTo.Calculate
method BPaymentSelection.ExportBEAbroad
method BProject.ApiLoadProject
read related business field(s) on tCInvoice.ShipToAddress_ID
read related business field(s) on tDInvoice.ShipFromAddress_ID
read related business field(s) on tProject.SiteAddress_ID
read related business field(s) on tProject.InvoiceAddress_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tCInvoice.ShipToAddress_ID
validate related business field(s) on tDInvoice.ShipFromAddress_ID
validate related business field(s) on tProject.SiteAddress_ID
validate related business field(s) on tProject.InvoiceAddress_ID