query AddressForIntegration

query condition

Address.BusinessRelation_ID = iiBusinessRelation_ID AND
Address.Address_ID = iiAddress_ID AND
Address.AddressLogicKeyString = icAddressLogicKeyString AND
Address.AddressStreet1 = (if icAddressStreet1 = '-999999' then '' else icAddressStreet1) AND
Address.AddressStreet2 = (if icAddressStreet2 = '-999999' then '' else icAddressStreet2) AND
Address.AddressStreet3 = (if icAddressStreet3 = '-999999' then '' else icAddressStreet3) AND
Address.AddressZip = (if icAddressZip = '-999999' then '' else icAddressZip) AND
Address.AddressCity = (if icAddressCity = '-999999' then '' else icAddressCity)

AddressType.AddressType_ID = Address.AddressType_ID AND
AddressType.AddressTypeCode = icAddressTypeCode

query resultset tqAddressForIntegration

field name	data type	db field	description
tiAddress_ID	integer	Address.Address_ID	Record ID
tcAddressCity	character	Address.AddressCity	City. The city for this address. This field can be used to decide the tax zone of the address.
tcAddressLogicKeyString	character	Address.AddressLogicKeyString	Logic Key String. Alternative unique key for address table for integration purpose when making update existing record.
	api annotation:		PartialUpdate = yes - defaults to 1.
tcAddressStreet1	character	Address.AddressStreet1	Address: Line one of address details. This field can be blank.
tcAddressStreet2	character	Address.AddressStreet2	Address.Line two of address details. This field can be blank.
tcAddressStreet3	character	Address.AddressStreet3	Address.Line three of address details. This field can be blank.
tcAddressTypeCode	character	AddressType.AddressTypeCode	Address Type
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.
tiBusinessRelation_ID	integer	Address.BusinessRelation_ID	Link to BusinessRelation

field name

data type

db field

description

tiAddress_ID

integer

Address.Address_ID

Record ID

tcAddressCity

character

Address.AddressCity

City. The city for this address. This field can be used to decide the tax zone of the address.

tcAddressLogicKeyString

character

Address.AddressLogicKeyString

Logic Key String. Alternative unique key for address table for integration purpose when making update existing record.

api annotation:

PartialUpdate = yes - defaults to 1.

tcAddressStreet1

character

Address.AddressStreet1

Address: Line one of address details.
This field can be blank.

tcAddressStreet2

character

Address.AddressStreet2

Address.Line two of address details.
This field can be blank.

tcAddressStreet3

character

Address.AddressStreet3

Address.Line three of address details.
This field can be blank.

tcAddressTypeCode

character

AddressType.AddressTypeCode

Address Type

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.

tiBusinessRelation_ID

integer

Address.BusinessRelation_ID

Link to BusinessRelation

project QadFinancials > class BBusinessRelation > business logic query AddressForIntegration

Parameters

query condition

query resultset tqAddressForIntegration

Internal usage

iiBusinessRelation_ID	integer
iiAddress_ID	integer
icAddressLogicKeyString	character
icAddressTypeCode	character
icAddressStreet1	character
icAddressStreet2	character
icAddressStreet3	character
icAddressZip	character
icAddressCity	character