JDBC Driver for Sage Intacct

Build 22.0.8462

Location

Retrieves Location report data.

Columns

Name Type ReadOnly Description
Locationid [KEY] String False

The Locationid field of the Location object.

Recordno Int64 False

The Recordno field of the Location object.

Name String False

The Name field of the Location object.

Parentid String False

The Parentid field of the Location object.

Supervisorname String False

The Supervisorname field of the Location object.

Supervisorid String False

The Supervisorid field of the Location object.

Contactinfo_contactname String False

The Contactinfo_contactname field of the Location object.

Contactinfo_printas String False

The Contactinfo_printas field of the Location object.

Contactinfo_phone1 String False

The Contactinfo_phone1 field of the Location object.

Contactinfo_phone2 String False

The Contactinfo_phone2 field of the Location object.

Contactinfo_email1 String False

The Contactinfo_email1 field of the Location object.

Contactinfo_email2 String False

The Contactinfo_email2 field of the Location object.

Contactinfo_fax String False

The Contactinfo_fax field of the Location object.

Contactinfo_mailaddress_address1 String False

The Contactinfo_mailaddress_address1 field of the Location object.

Contactinfo_mailaddress_address2 String False

The Contactinfo_mailaddress_address2 field of the Location object.

Contactinfo_mailaddress_city String False

The Contactinfo_mailaddress_city field of the Location object.

Contactinfo_mailaddress_state String False

The Contactinfo_mailaddress_state field of the Location object.

Contactinfo_mailaddress_zip String False

The Contactinfo_mailaddress_zip field of the Location object.

Contactinfo_mailaddress_country String False

The Contactinfo_mailaddress_country field of the Location object.

Contactinfo_mailaddress_countrycode String False

The Contactinfo_mailaddress_countrycode field of the Location object.

Startdate Datetime False

The Startdate field of the Location object.

Enddate Datetime False

The Enddate field of the Location object.

Shipto_contactname String False

The Shipto_contactname field of the Location object.

Shipto_phone1 String False

The Shipto_phone1 field of the Location object.

Shipto_phone2 String False

The Shipto_phone2 field of the Location object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the Location object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the Location object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the Location object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the Location object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the Location object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the Location object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the Location object.

Status String False

The Status field of the Location object.

Whencreated Datetime False

The Whencreated field of the Location object.

Whenmodified Datetime False

The Whenmodified field of the Location object.

Federalid String False

The Federalid field of the Location object.

Firstmonth String False

The Firstmonth field of the Location object.

Weekstart String False

The Weekstart field of the Location object.

Iepayable_account String False

The Iepayable_account field of the Location object.

Iepayable_number String False

The Iepayable_number field of the Location object.

Iereceivable_account String False

The Iereceivable_account field of the Location object.

Iereceivable_number String False

The Iereceivable_number field of the Location object.

Message_text String False

The Message_text field of the Location object.

Marketing_text String False

The Marketing_text field of the Location object.

Footnotetext String False

The Footnotetext field of the Location object.

Reportprintas String False

The Reportprintas field of the Location object.

Isroot String False

The Isroot field of the Location object.

Reserveamt String False

The Reserveamt field of the Location object.

Vendorname String False

The Vendorname field of the Location object.

Vendorid String False

The Vendorid field of the Location object.

Customerid String False

The Customerid field of the Location object.

Customername String False

The Customername field of the Location object.

Currency String False

The Currency field of the Location object.

Has_ie_relation Boolean False

The Has_ie_relation field of the Location object.

Custtitle String False

The Custtitle field of the Location object.

Businessdays String False

The Businessdays field of the Location object.

Weekends String False

The Weekends field of the Location object.

Firstmonthtax String False

The Firstmonthtax field of the Location object.

Contactkey Int64 False

The Contactkey field of the Location object.

Supervisorkey Int64 False

The Supervisorkey field of the Location object.

Parentkey Int64 False

The Parentkey field of the Location object.

Shiptokey Int64 False

The Shiptokey field of the Location object.

Vendentity String False

The Vendentity field of the Location object.

Custentity String False

The Custentity field of the Location object.

Taxid String False

The Taxid field of the Location object.

Createdby Int64 False

The Createdby field of the Location object.

Modifiedby Int64 False

The Modifiedby field of the Location object.

Record_url String False

The Record_url field of the Location object.

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