JDBC Driver for Sage Intacct

Build 22.0.8462

ARInvoice

Retrieves ARInvoice report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the ARInvoice object.

Recordtype String False

The Recordtype field of the ARInvoice object.

Recordid String False

The Recordid field of the ARInvoice object.

State String False

The State field of the ARInvoice object.

Rawstate String False

The Rawstate field of the ARInvoice object.

Entity String False

The Entity field of the ARInvoice object.

Custentity String False

The Custentity field of the ARInvoice object.

Customerid String False

The Customerid field of the ARInvoice object.

Customername String False

The Customername field of the ARInvoice object.

Trx_entitydue Double False

The Trx_entitydue field of the ARInvoice object.

Custmessageid String False

The Custmessageid field of the ARInvoice object.

Delivery_options String False

The Delivery_options field of the ARInvoice object.

Docnumber String False

The Docnumber field of the ARInvoice object.

Description String False

The Description field of the ARInvoice object.

Description2 String False

The Description2 field of the ARInvoice object.

Termname String False

The Termname field of the ARInvoice object.

Termkey Int64 False

The Termkey field of the ARInvoice object.

Whencreated Datetime False

The Whencreated field of the ARInvoice object.

Whenposted Datetime False

The Whenposted field of the ARInvoice object.

Whendiscount Datetime False

The Whendiscount field of the ARInvoice object.

Whendue Datetime False

The Whendue field of the ARInvoice object.

Whenpaid Datetime False

The Whenpaid field of the ARInvoice object.

Basecurr String False

The Basecurr field of the ARInvoice object.

Currency String False

The Currency field of the ARInvoice object.

Exch_rate_date Datetime False

The Exch_rate_date field of the ARInvoice object.

Exch_rate_type_id Int64 False

The Exch_rate_type_id field of the ARInvoice object.

Exchange_rate Double False

The Exchange_rate field of the ARInvoice object.

Totalentered Double False

The Totalentered field of the ARInvoice object.

Totalselected Double False

The Totalselected field of the ARInvoice object.

Totalpaid Double False

The Totalpaid field of the ARInvoice object.

Totaldue Double False

The Totaldue field of the ARInvoice object.

Trx_totalentered Double False

The Trx_totalentered field of the ARInvoice object.

Trx_totalselected Double False

The Trx_totalselected field of the ARInvoice object.

Trx_totalpaid Double False

The Trx_totalpaid field of the ARInvoice object.

Trx_totaldue Double False

The Trx_totaldue field of the ARInvoice object.

Billtopaytocontactname String False

The Billtopaytocontactname field of the ARInvoice object.

Shiptoreturntocontactname String False

The Shiptoreturntocontactname field of the ARInvoice object.

Billtopaytokey Int64 False

The Billtopaytokey field of the ARInvoice object.

Shiptoreturntokey Int64 False

The Shiptoreturntokey field of the ARInvoice object.

Contact_contactname String False

The Contact_contactname field of the ARInvoice object.

Contact_prefix String False

The Contact_prefix field of the ARInvoice object.

Contact_firstname String False

The Contact_firstname field of the ARInvoice object.

Contact_initial String False

The Contact_initial field of the ARInvoice object.

Contact_lastname String False

The Contact_lastname field of the ARInvoice object.

Contact_companyname String False

The Contact_companyname field of the ARInvoice object.

Contact_printas String False

The Contact_printas field of the ARInvoice object.

Contact_phone1 String False

The Contact_phone1 field of the ARInvoice object.

Contact_phone2 String False

The Contact_phone2 field of the ARInvoice object.

Contact_cellphone String False

The Contact_cellphone field of the ARInvoice object.

Contact_pager String False

The Contact_pager field of the ARInvoice object.

Contact_fax String False

The Contact_fax field of the ARInvoice object.

Contact_email1 String False

The Contact_email1 field of the ARInvoice object.

Contact_email2 String False

The Contact_email2 field of the ARInvoice object.

Contact_url1 String False

The Contact_url1 field of the ARInvoice object.

Contact_url2 String False

The Contact_url2 field of the ARInvoice object.

Contact_visible Boolean False

The Contact_visible field of the ARInvoice object.

Contact_mailaddress_address1 String False

The Contact_mailaddress_address1 field of the ARInvoice object.

Contact_mailaddress_address2 String False

The Contact_mailaddress_address2 field of the ARInvoice object.

Contact_mailaddress_city String False

The Contact_mailaddress_city field of the ARInvoice object.

Contact_mailaddress_state String False

The Contact_mailaddress_state field of the ARInvoice object.

Contact_mailaddress_zip String False

The Contact_mailaddress_zip field of the ARInvoice object.

Contact_mailaddress_country String False

The Contact_mailaddress_country field of the ARInvoice object.

Contact_mailaddress_countrycode String False

The Contact_mailaddress_countrycode field of the ARInvoice object.

Shipto_contactname String False

The Shipto_contactname field of the ARInvoice object.

Shipto_prefix String False

The Shipto_prefix field of the ARInvoice object.

Shipto_firstname String False

The Shipto_firstname field of the ARInvoice object.

Shipto_initial String False

The Shipto_initial field of the ARInvoice object.

Shipto_lastname String False

The Shipto_lastname field of the ARInvoice object.

Shipto_companyname String False

The Shipto_companyname field of the ARInvoice object.

Shipto_printas String False

The Shipto_printas field of the ARInvoice object.

Shipto_phone1 String False

The Shipto_phone1 field of the ARInvoice object.

Shipto_phone2 String False

The Shipto_phone2 field of the ARInvoice object.

Shipto_cellphone String False

The Shipto_cellphone field of the ARInvoice object.

Shipto_pager String False

The Shipto_pager field of the ARInvoice object.

Shipto_fax String False

The Shipto_fax field of the ARInvoice object.

Shipto_email1 String False

The Shipto_email1 field of the ARInvoice object.

Shipto_email2 String False

The Shipto_email2 field of the ARInvoice object.

Shipto_url1 String False

The Shipto_url1 field of the ARInvoice object.

Shipto_url2 String False

The Shipto_url2 field of the ARInvoice object.

Shipto_visible Boolean False

The Shipto_visible field of the ARInvoice object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the ARInvoice object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the ARInvoice object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the ARInvoice object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the ARInvoice object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the ARInvoice object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the ARInvoice object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the ARInvoice object.

Billto_contactname String False

The Billto_contactname field of the ARInvoice object.

Billto_prefix String False

The Billto_prefix field of the ARInvoice object.

Billto_firstname String False

The Billto_firstname field of the ARInvoice object.

Billto_initial String False

The Billto_initial field of the ARInvoice object.

Billto_lastname String False

The Billto_lastname field of the ARInvoice object.

Billto_companyname String False

The Billto_companyname field of the ARInvoice object.

Billto_printas String False

The Billto_printas field of the ARInvoice object.

Billto_phone1 String False

The Billto_phone1 field of the ARInvoice object.

Billto_phone2 String False

The Billto_phone2 field of the ARInvoice object.

Billto_cellphone String False

The Billto_cellphone field of the ARInvoice object.

Billto_pager String False

The Billto_pager field of the ARInvoice object.

Billto_fax String False

The Billto_fax field of the ARInvoice object.

Billto_email1 String False

The Billto_email1 field of the ARInvoice object.

Billto_email2 String False

The Billto_email2 field of the ARInvoice object.

Billto_url1 String False

The Billto_url1 field of the ARInvoice object.

Billto_url2 String False

The Billto_url2 field of the ARInvoice object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the ARInvoice object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the ARInvoice object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the ARInvoice object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the ARInvoice object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the ARInvoice object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the ARInvoice object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the ARInvoice object.

Prbatch String False

The Prbatch field of the ARInvoice object.

Prbatchkey Int64 False

The Prbatchkey field of the ARInvoice object.

Modulekey String False

The Modulekey field of the ARInvoice object.

Schopkey Int64 False

The Schopkey field of the ARInvoice object.

Systemgenerated String False

The Systemgenerated field of the ARInvoice object.

Haspostedrevrec String False

The Haspostedrevrec field of the ARInvoice object.

Auwhencreated Datetime False

The Auwhencreated field of the ARInvoice object.

Whenmodified Datetime False

The Whenmodified field of the ARInvoice object.

Createdby Int64 False

The Createdby field of the ARInvoice object.

Modifiedby Int64 False

The Modifiedby field of the ARInvoice object.

Megaentitykey Int64 False

The Megaentitykey field of the ARInvoice object.

Megaentityid String False

The Megaentityid field of the ARInvoice object.

Record_url String False

The Record_url field of the ARInvoice object.

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