project QadFinancials > class BDebtorReport > report query GetRemindersOverAddress


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
iiBusinessRelationIdi=
icBusinessRelationCodec=
icAddressTypec=
tAddress.AddressCityc=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressEMailc=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressFaxc=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressNamec=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressStreet1c=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTelephonec=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressZipc=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactEmailc=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactFaxc=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactNamec=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactTelephonec=,>=,>,<>,<=,<,begins,can-do,matches


Parameters (internal)


iiBusinessRelationIdinteger
icBusinessRelationCodecharacter
icAddressTypecharacter


query condition


  each Address where
Address.BusinessRelation_ID = iiBusinessRelationId

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

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

      each Contact (conditional-join) where
Contact.Address_ID = Address.Address_ID AND


query resultset tqGetRemindersOverAddress


field namedata typedb fielddescription
tcAddressCitycharacterAddress.AddressCityCity. The city for this address. This field can be used to decide the tax zone of the address.
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.
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.
tcAddressStreet1characterAddress.AddressStreet1Address: Line one of address details.
This field can be blank.
tcAddressTelephonecharacterAddress.AddressTelephoneTelephone. The telephone number for calling this business relation address.
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.
tcContactEmailcharacterContact.ContactEmailE-mail. The E-Mail address of the contact.
This field can be blank.
tcContactFaxcharacterContact.ContactFaxFax. The fax or telex number to use when sending documents to the contact.
This field can be blank.
tcContactNamecharacterContact.ContactNameName. The full name of the contact.
This field is mandatory.
tcContactTelephonecharacterContact.ContactTelephoneTelephone. The telephone number of the contact.
This field can be blank.
AddressCustomcharactercalculatedcustom fields
ContactCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Contact)


Internal usage


QadFinancials
method BDebtorReport.DebtorRemindersOverview