report query GetRemindersOverAddress

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
iiBusinessRelationId	i	=
icBusinessRelationCode	c	=
icAddressType	c	=
tAddress.AddressCity	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressEMail	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressFax	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressStreet1	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressTelephone	c	=,>=,>,<>,<=,<,begins,can-do,matches
tAddress.AddressZip	c	=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactEmail	c	=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactFax	c	=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tContact.ContactTelephone	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

iiBusinessRelationId	integer
icBusinessRelationCode	character
icAddressType	character

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 name	data type	db field	description
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressEMail	character	Address.AddressEMail	E-Mail. This field indicates the e-mail address associated with this business relation. This field can be blank.
tcAddressFax	character	Address.AddressFax	Fax. This field indicates the fax or telex number to use when sending documents to this address. This field can be balnk.
tcAddressName	character	Address.AddressName	Name. 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.
tcAddressStreet1	character	Address.AddressStreet1	Address: Line one of address details. This field can be blank.
tcAddressTelephone	character	Address.AddressTelephone	Telephone. The telephone number for calling this business relation address. This field can be blank.
tcAddressZip	character	Address.AddressZip	Zip. 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.
tcContactEmail	character	Contact.ContactEmail	E-mail. The E-Mail address of the contact. This field can be blank.
tcContactFax	character	Contact.ContactFax	Fax. The fax or telex number to use when sending documents to the contact. This field can be blank.
tcContactName	character	Contact.ContactName	Name. The full name of the contact. This field is mandatory.
tcContactTelephone	character	Contact.ContactTelephone	Telephone. The telephone number of the contact. This field can be blank.
AddressCustom	character	calculated	custom fields
ContactCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Address),rowid(AddressType),rowid(BusinessRelation),rowid(Contact)

Internal usage

QadFinancials

method BDebtorReport.DebtorRemindersOverview