JDBC Driver for Sage Intacct

Build 22.0.8462

InvDocument

Retrieves InvDocument report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the InvDocument object.

Docno String False

The Docno field of the InvDocument object.

Docid String False

The Docid field of the InvDocument object.

Createdfrom String False

The Createdfrom field of the InvDocument object.

State String False

The State field of the InvDocument object.

Closed Boolean False

The Closed field of the InvDocument object.

Whencreated Datetime False

The Whencreated field of the InvDocument object.

Whenmodified Datetime False

The Whenmodified field of the InvDocument object.

Whendue Datetime False

The Whendue field of the InvDocument object.

Status String False

The Status field of the InvDocument object.

Ponumber String False

The Ponumber field of the InvDocument object.

Vendordocno String False

The Vendordocno field of the InvDocument object.

Docparid String False

The Docparid field of the InvDocument object.

Docparkey String False

The Docparkey field of the InvDocument object.

Docparclass String False

The Docparclass field of the InvDocument object.

Term_name String False

The Term_name field of the InvDocument object.

Note String False

The Note field of the InvDocument object.

Warehouse_locationid String False

The Warehouse_locationid field of the InvDocument object.

Shipvia String False

The Shipvia field of the InvDocument object.

User String False

The User field of the InvDocument object.

Createduser String False

The Createduser field of the InvDocument object.

Userid String False

The Userid field of the InvDocument object.

Createduserid String False

The Createduserid field of the InvDocument object.

Contact_contactname String False

The Contact_contactname field of the InvDocument object.

Contact_prefix String False

The Contact_prefix field of the InvDocument object.

Contact_firstname String False

The Contact_firstname field of the InvDocument object.

Contact_initial String False

The Contact_initial field of the InvDocument object.

Contact_lastname String False

The Contact_lastname field of the InvDocument object.

Contact_companyname String False

The Contact_companyname field of the InvDocument object.

Contact_printas String False

The Contact_printas field of the InvDocument object.

Contact_phone1 String False

The Contact_phone1 field of the InvDocument object.

Contact_phone2 String False

The Contact_phone2 field of the InvDocument object.

Contact_cellphone String False

The Contact_cellphone field of the InvDocument object.

Contact_pager String False

The Contact_pager field of the InvDocument object.

Contact_fax String False

The Contact_fax field of the InvDocument object.

Contact_email1 String False

The Contact_email1 field of the InvDocument object.

Contact_email2 String False

The Contact_email2 field of the InvDocument object.

Contact_url1 String False

The Contact_url1 field of the InvDocument object.

Contact_url2 String False

The Contact_url2 field of the InvDocument object.

Contact_visible Boolean False

The Contact_visible field of the InvDocument object.

Contact_mailaddress_address1 String False

The Contact_mailaddress_address1 field of the InvDocument object.

Contact_mailaddress_address2 String False

The Contact_mailaddress_address2 field of the InvDocument object.

Contact_mailaddress_city String False

The Contact_mailaddress_city field of the InvDocument object.

Contact_mailaddress_state String False

The Contact_mailaddress_state field of the InvDocument object.

Contact_mailaddress_zip String False

The Contact_mailaddress_zip field of the InvDocument object.

Contact_mailaddress_country String False

The Contact_mailaddress_country field of the InvDocument object.

Contact_mailaddress_countrycode String False

The Contact_mailaddress_countrycode field of the InvDocument object.

Shiptokey String False

The Shiptokey field of the InvDocument object.

Shipto_contactname String False

The Shipto_contactname field of the InvDocument object.

Shipto_prefix String False

The Shipto_prefix field of the InvDocument object.

Shipto_firstname String False

The Shipto_firstname field of the InvDocument object.

Shipto_initial String False

The Shipto_initial field of the InvDocument object.

Shipto_lastname String False

The Shipto_lastname field of the InvDocument object.

Shipto_companyname String False

The Shipto_companyname field of the InvDocument object.

Shipto_printas String False

The Shipto_printas field of the InvDocument object.

Shipto_phone1 String False

The Shipto_phone1 field of the InvDocument object.

Shipto_phone2 String False

The Shipto_phone2 field of the InvDocument object.

Shipto_cellphone String False

The Shipto_cellphone field of the InvDocument object.

Shipto_pager String False

The Shipto_pager field of the InvDocument object.

Shipto_fax String False

The Shipto_fax field of the InvDocument object.

Shipto_email1 String False

The Shipto_email1 field of the InvDocument object.

Shipto_email2 String False

The Shipto_email2 field of the InvDocument object.

Shipto_url1 String False

The Shipto_url1 field of the InvDocument object.

Shipto_url2 String False

The Shipto_url2 field of the InvDocument object.

Shipto_visible Boolean False

The Shipto_visible field of the InvDocument object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the InvDocument object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the InvDocument object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the InvDocument object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the InvDocument object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the InvDocument object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the InvDocument object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the InvDocument object.

Billtokey String False

The Billtokey field of the InvDocument object.

Billto_contactname String False

The Billto_contactname field of the InvDocument object.

Billto_prefix String False

The Billto_prefix field of the InvDocument object.

Billto_firstname String False

The Billto_firstname field of the InvDocument object.

Billto_initial String False

The Billto_initial field of the InvDocument object.

Billto_lastname String False

The Billto_lastname field of the InvDocument object.

Billto_companyname String False

The Billto_companyname field of the InvDocument object.

Billto_printas String False

The Billto_printas field of the InvDocument object.

Billto_phone1 String False

The Billto_phone1 field of the InvDocument object.

Billto_phone2 String False

The Billto_phone2 field of the InvDocument object.

Billto_cellphone String False

The Billto_cellphone field of the InvDocument object.

Billto_pager String False

The Billto_pager field of the InvDocument object.

Billto_fax String False

The Billto_fax field of the InvDocument object.

Billto_email1 String False

The Billto_email1 field of the InvDocument object.

Billto_email2 String False

The Billto_email2 field of the InvDocument object.

Billto_url1 String False

The Billto_url1 field of the InvDocument object.

Billto_url2 String False

The Billto_url2 field of the InvDocument object.

Billto_visible Boolean False

The Billto_visible field of the InvDocument object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the InvDocument object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the InvDocument object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the InvDocument object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the InvDocument object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the InvDocument object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the InvDocument object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the InvDocument object.

Message String False

The Message field of the InvDocument object.

Prrecordkey String False

The Prrecordkey field of the InvDocument object.

Invbatchkey String False

The Invbatchkey field of the InvDocument object.

Prinvbatchkey String False

The Prinvbatchkey field of the InvDocument object.

Printed String False

The Printed field of the InvDocument object.

Backorder String False

The Backorder field of the InvDocument object.

Subtotal Double False

The Subtotal field of the InvDocument object.

Total Double False

The Total field of the InvDocument object.

Entglgroup Int64 False

The Entglgroup field of the InvDocument object.

Currency String False

The Currency field of the InvDocument object.

Exchratedate Datetime False

The Exchratedate field of the InvDocument object.

Exchratetypes_name String False

The Exchratetypes_name field of the InvDocument object.

Exchrate Double False

The Exchrate field of the InvDocument object.

Schopkey String False

The Schopkey field of the InvDocument object.

Salescontract String False

The Salescontract field of the InvDocument object.

Usedascontract String False

The Usedascontract field of the InvDocument object.

Trx_subtotal Double False

The Trx_subtotal field of the InvDocument object.

Trx_total Double False

The Trx_total field of the InvDocument object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the InvDocument object.

Reneweddoc String False

The Reneweddoc field of the InvDocument object.

Basecurr String False

The Basecurr field of the InvDocument object.

Systemgenerated String False

The Systemgenerated field of the InvDocument object.

Invoicerunkey Int64 False

The Invoicerunkey field of the InvDocument object.

Docpar_in_out String False

The Docpar_in_out field of the InvDocument object.

Megaentitykey Int64 False

The Megaentitykey field of the InvDocument object.

Megaentityid String False

The Megaentityid field of the InvDocument object.

Megaentityname String False

The Megaentityname field of the InvDocument object.

Record_url String False

The Record_url field of the InvDocument object.

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