JDBC Driver for Sage Intacct

Build 22.0.8462

Contact

Retrieves Contact report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] Int64 False

The Recordno field of the Contact object.

Contactname String False

The Contactname field of the Contact object.

Companyname String False

The Companyname field of the Contact object.

Prefix String False

The Prefix field of the Contact object.

Firstname String False

The Firstname field of the Contact object.

Lastname String False

The Lastname field of the Contact object.

Initial String False

The Initial field of the Contact object.

Printas String False

The Printas field of the Contact object.

Taxable Boolean False

The Taxable field of the Contact object.

Taxgroup String False

The Taxgroup field of the Contact object.

Phone1 String False

The Phone1 field of the Contact object.

Phone2 String False

The Phone2 field of the Contact object.

Cellphone String False

The Cellphone field of the Contact object.

Pager String False

The Pager field of the Contact object.

Fax String False

The Fax field of the Contact object.

Email1 String False

The Email1 field of the Contact object.

Email2 String False

The Email2 field of the Contact object.

Url1 String False

The Url1 field of the Contact object.

Url2 String False

The Url2 field of the Contact object.

Visible Boolean False

The Visible field of the Contact object.

Mailaddress_address1 String False

The Mailaddress_address1 field of the Contact object.

Mailaddress_address2 String False

The Mailaddress_address2 field of the Contact object.

Mailaddress_city String False

The Mailaddress_city field of the Contact object.

Mailaddress_state String False

The Mailaddress_state field of the Contact object.

Mailaddress_zip String False

The Mailaddress_zip field of the Contact object.

Mailaddress_country String False

The Mailaddress_country field of the Contact object.

Status String False

The Status field of the Contact object.

Mailaddress_countrycode String False

The Mailaddress_countrycode field of the Contact object.

Priceschedule String False

The Priceschedule field of the Contact object.

Discount Double False

The Discount field of the Contact object.

Pricelist String False

The Pricelist field of the Contact object.

Pricelistkey Int64 False

The Pricelistkey field of the Contact object.

Taxid String False

The Taxid field of the Contact object.

Taxgroupkey Int64 False

The Taxgroupkey field of the Contact object.

Priceschedulekey Int64 False

The Priceschedulekey field of the Contact object.

Whencreated Datetime False

The Whencreated field of the Contact object.

Whenmodified Datetime False

The Whenmodified field of the Contact object.

Createdby Int64 False

The Createdby field of the Contact object.

Modifiedby Int64 False

The Modifiedby field of the Contact object.

Megaentitykey Int64 False

The Megaentitykey field of the Contact object.

Megaentityid String False

The Megaentityid field of the Contact object.

Megaentityname String False

The Megaentityname field of the Contact object.

Record_url String False

The Record_url field of the Contact object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462