NameDescriptionTypeAdditional information
RowNum

Row number in the result set

integer

None.

CustomerId

QFlow Customer Id

integer

None.

PersonalId

Vendor's Customer identifier

string

Max length: 30

PersonalIdTypeId

Vendor's Customer identifier Type (QFlow CustomerIdTypeId). Default none

integer

None.

PersonalIdTypeExtRef

string

None.

FirstName

First Name

string

Max length: 50

LastName

Last Name

string

Max length: 50

Email

Email address

string

Max length: 100

TelNumber1

Phone Number 1

string

Max length: 25

TelNumber2

Phone Number 2

string

Max length: 25

DOB

Date of Birth

date

None.

Sex

0=Unknown; 1=Male; 2=Female

byte

Range: inclusive between 0 and 2

Notes

Notes

string

Max length: 250

ExtRef

Custom External Reference

string

Max length: 200

IsActive

Is customer record enabled

boolean

None.

CustomProperties

If there are any custom properties defined, they will dynamically be added to the end of the list. They appear in alphabetical order. The CustomProperties field defined here is only a place marker and will be replaced by the names of each property at run time.

string

None.