Tableau Connector for Sage Intacct

Build 21.0.7930

SODocument

Retrieves SODocument report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the SODocument object.

Docno String False

The Docno field of the SODocument object.

Docid String False

The Docid field of the SODocument object.

Createdfrom String False

The Createdfrom field of the SODocument object.

State String False

The State field of the SODocument object.

Closed Boolean False

The Closed field of the SODocument object.

Whencreated Datetime False

The Whencreated field of the SODocument object.

Whenmodified Datetime False

The Whenmodified field of the SODocument object.

Whendue Datetime False

The Whendue field of the SODocument object.

Status String False

The Status field of the SODocument object.

Ponumber String False

The Ponumber field of the SODocument object.

Vendordocno String False

The Vendordocno field of the SODocument object.

Docparid String False

The Docparid field of the SODocument object.

Docparkey String False

The Docparkey field of the SODocument object.

Docparclass String False

The Docparclass field of the SODocument object.

Term_name String False

The Term_name field of the SODocument object.

Note String False

The Note field of the SODocument object.

Warehouse_locationid String False

The Warehouse_locationid field of the SODocument object.

Shipvia String False

The Shipvia field of the SODocument object.

User String False

The User field of the SODocument object.

Createduser String False

The Createduser field of the SODocument object.

Userid String False

The Userid field of the SODocument object.

Createduserid String False

The Createduserid field of the SODocument object.

Contact_contactname String False

The Contact_contactname field of the SODocument object.

Contact_prefix String False

The Contact_prefix field of the SODocument object.

Contact_firstname String False

The Contact_firstname field of the SODocument object.

Contact_initial String False

The Contact_initial field of the SODocument object.

Contact_lastname String False

The Contact_lastname field of the SODocument object.

Contact_companyname String False

The Contact_companyname field of the SODocument object.

Contact_printas String False

The Contact_printas field of the SODocument object.

Contact_phone1 String False

The Contact_phone1 field of the SODocument object.

Contact_phone2 String False

The Contact_phone2 field of the SODocument object.

Contact_cellphone String False

The Contact_cellphone field of the SODocument object.

Contact_pager String False

The Contact_pager field of the SODocument object.

Contact_fax String False

The Contact_fax field of the SODocument object.

Contact_email1 String False

The Contact_email1 field of the SODocument object.

Contact_email2 String False

The Contact_email2 field of the SODocument object.

Contact_url1 String False

The Contact_url1 field of the SODocument object.

Contact_url2 String False

The Contact_url2 field of the SODocument object.

Contact_visible Boolean False

The Contact_visible field of the SODocument object.

Contact_mailaddress_address1 String False

The Contact_mailaddress_address1 field of the SODocument object.

Contact_mailaddress_address2 String False

The Contact_mailaddress_address2 field of the SODocument object.

Contact_mailaddress_city String False

The Contact_mailaddress_city field of the SODocument object.

Contact_mailaddress_state String False

The Contact_mailaddress_state field of the SODocument object.

Contact_mailaddress_zip String False

The Contact_mailaddress_zip field of the SODocument object.

Contact_mailaddress_country String False

The Contact_mailaddress_country field of the SODocument object.

Contact_mailaddress_countrycode String False

The Contact_mailaddress_countrycode field of the SODocument object.

Shiptokey String False

The Shiptokey field of the SODocument object.

Shipto_contactname String False

The Shipto_contactname field of the SODocument object.

Shipto_prefix String False

The Shipto_prefix field of the SODocument object.

Shipto_firstname String False

The Shipto_firstname field of the SODocument object.

Shipto_initial String False

The Shipto_initial field of the SODocument object.

Shipto_lastname String False

The Shipto_lastname field of the SODocument object.

Shipto_companyname String False

The Shipto_companyname field of the SODocument object.

Shipto_printas String False

The Shipto_printas field of the SODocument object.

Shipto_phone1 String False

The Shipto_phone1 field of the SODocument object.

Shipto_phone2 String False

The Shipto_phone2 field of the SODocument object.

Shipto_cellphone String False

The Shipto_cellphone field of the SODocument object.

Shipto_pager String False

The Shipto_pager field of the SODocument object.

Shipto_fax String False

The Shipto_fax field of the SODocument object.

Shipto_email1 String False

The Shipto_email1 field of the SODocument object.

Shipto_email2 String False

The Shipto_email2 field of the SODocument object.

Shipto_url1 String False

The Shipto_url1 field of the SODocument object.

Shipto_url2 String False

The Shipto_url2 field of the SODocument object.

Shipto_visible Boolean False

The Shipto_visible field of the SODocument object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the SODocument object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the SODocument object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the SODocument object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the SODocument object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the SODocument object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the SODocument object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the SODocument object.

Billtokey String False

The Billtokey field of the SODocument object.

Billto_contactname String False

The Billto_contactname field of the SODocument object.

Billto_prefix String False

The Billto_prefix field of the SODocument object.

Billto_firstname String False

The Billto_firstname field of the SODocument object.

Billto_initial String False

The Billto_initial field of the SODocument object.

Billto_lastname String False

The Billto_lastname field of the SODocument object.

Billto_companyname String False

The Billto_companyname field of the SODocument object.

Billto_printas String False

The Billto_printas field of the SODocument object.

Billto_phone1 String False

The Billto_phone1 field of the SODocument object.

Billto_phone2 String False

The Billto_phone2 field of the SODocument object.

Billto_cellphone String False

The Billto_cellphone field of the SODocument object.

Billto_pager String False

The Billto_pager field of the SODocument object.

Billto_fax String False

The Billto_fax field of the SODocument object.

Billto_email1 String False

The Billto_email1 field of the SODocument object.

Billto_email2 String False

The Billto_email2 field of the SODocument object.

Billto_url1 String False

The Billto_url1 field of the SODocument object.

Billto_url2 String False

The Billto_url2 field of the SODocument object.

Billto_visible Boolean False

The Billto_visible field of the SODocument object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the SODocument object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the SODocument object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the SODocument object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the SODocument object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the SODocument object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the SODocument object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the SODocument object.

Message String False

The Message field of the SODocument object.

Prrecordkey String False

The Prrecordkey field of the SODocument object.

Invbatchkey String False

The Invbatchkey field of the SODocument object.

Prinvbatchkey String False

The Prinvbatchkey field of the SODocument object.

Printed String False

The Printed field of the SODocument object.

Backorder String False

The Backorder field of the SODocument object.

Subtotal Double False

The Subtotal field of the SODocument object.

Total Double False

The Total field of the SODocument object.

Entglgroup Int64 False

The Entglgroup field of the SODocument object.

Currency String False

The Currency field of the SODocument object.

Exchratedate Datetime False

The Exchratedate field of the SODocument object.

Exchratetypes_name String False

The Exchratetypes_name field of the SODocument object.

Exchrate Double False

The Exchrate field of the SODocument object.

Schopkey String False

The Schopkey field of the SODocument object.

Salescontract String False

The Salescontract field of the SODocument object.

Usedascontract String False

The Usedascontract field of the SODocument object.

Trx_subtotal Double False

The Trx_subtotal field of the SODocument object.

Trx_total Double False

The Trx_total field of the SODocument object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the SODocument object.

Reneweddoc String False

The Reneweddoc field of the SODocument object.

Basecurr String False

The Basecurr field of the SODocument object.

Systemgenerated String False

The Systemgenerated field of the SODocument object.

Invoicerunkey Int64 False

The Invoicerunkey field of the SODocument object.

Docpar_in_out String False

The Docpar_in_out field of the SODocument object.

Custvendid String False

The Custvendid field of the SODocument object.

Custvendname String False

The Custvendname field of the SODocument object.

Haspostedrevrec String False

The Haspostedrevrec field of the SODocument object.

Contractid String False

The Contractid field of the SODocument object.

Contractdesc String False

The Contractdesc field of the SODocument object.

Trx_totalpaid String False

The Trx_totalpaid field of the SODocument object.

Totalpaid String False

The Totalpaid field of the SODocument object.

Trx_totalentered String False

The Trx_totalentered field of the SODocument object.

Totalentered String False

The Totalentered field of the SODocument object.

Trx_totaldue String False

The Trx_totaldue field of the SODocument object.

Totaldue String False

The Totaldue field of the SODocument object.

Paymentstatus String False

The Paymentstatus field of the SODocument object.

Sign_flag Int64 False

The Sign_flag field of the SODocument object.

Vsoepricelist String False

The Vsoepricelist field of the SODocument object.

Vsoeprclstkey String False

The Vsoeprclstkey field of the SODocument object.

Origdocdate Datetime False

The Origdocdate field of the SODocument object.

Hasadvbilling Boolean False

The Hasadvbilling field of the SODocument object.

Invoicerun_expensepricemarkup Double False

The Invoicerun_expensepricemarkup field of the SODocument object.

Invoicerun_description String False

The Invoicerun_description field of the SODocument object.

Projectkey Int64 False

The Projectkey field of the SODocument object.

Project String False

The Project field of the SODocument object.

Projectname String False

The Projectname field of the SODocument object.

Megaentitykey Int64 False

The Megaentitykey field of the SODocument object.

Megaentityid String False

The Megaentityid field of the SODocument object.

Megaentityname String False

The Megaentityname field of the SODocument object.

Record_url String False

The Record_url field of the SODocument object.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930