project QadFinancials > class BCashBoxReport > business logic query BusinessRelationByBRID


Parameters


icAddressTypecharacter
iiBusinessRelationIDinteger


query condition


  each BusinessRelation where
BusinessRelation.BusinessRelation_ID = iiBusinessRelationID

      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 = icAddressType


query resultset tqBusinessRelationByBRID


field namedata typedb fielddescription
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressStreet2characterAddress.AddressStreet2Address.Line two of address details.
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.
tcBusinessRelationName1characterBusinessRelation.BusinessRelationName1Name: 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.
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(BusinessRelation),rowid(Address),rowid(AddressType)


Internal usage


QadFinancials
method BCashBoxReport.CashPaid
method BCashBoxReport.CashReceived