Tableau Connector for Sage Intacct

Build 21.0.7930

PODocument

Retrieves PODocument report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the PODocument object.

Docno String False

The Docno field of the PODocument object.

Docid String False

The Docid field of the PODocument object.

Createdfrom String False

The Createdfrom field of the PODocument object.

State String False

The State field of the PODocument object.

Closed Boolean False

The Closed field of the PODocument object.

Whencreated Datetime False

The Whencreated field of the PODocument object.

Whenmodified Datetime False

The Whenmodified field of the PODocument object.

Whendue Datetime False

The Whendue field of the PODocument object.

Status String False

The Status field of the PODocument object.

Ponumber String False

The Ponumber field of the PODocument object.

Vendordocno String False

The Vendordocno field of the PODocument object.

Docparid String False

The Docparid field of the PODocument object.

Docparkey String False

The Docparkey field of the PODocument object.

Docparclass String False

The Docparclass field of the PODocument object.

Term_name String False

The Term_name field of the PODocument object.

Note String False

The Note field of the PODocument object.

Warehouse_locationid String False

The Warehouse_locationid field of the PODocument object.

Shipvia String False

The Shipvia field of the PODocument object.

User String False

The User field of the PODocument object.

Createduser String False

The Createduser field of the PODocument object.

Userid String False

The Userid field of the PODocument object.

Createduserid String False

The Createduserid field of the PODocument object.

Contact_contactname String False

The Contact_contactname field of the PODocument object.

Contact_prefix String False

The Contact_prefix field of the PODocument object.

Contact_firstname String False

The Contact_firstname field of the PODocument object.

Contact_initial String False

The Contact_initial field of the PODocument object.

Contact_lastname String False

The Contact_lastname field of the PODocument object.

Contact_companyname String False

The Contact_companyname field of the PODocument object.

Contact_printas String False

The Contact_printas field of the PODocument object.

Contact_phone1 String False

The Contact_phone1 field of the PODocument object.

Contact_phone2 String False

The Contact_phone2 field of the PODocument object.

Contact_cellphone String False

The Contact_cellphone field of the PODocument object.

Contact_pager String False

The Contact_pager field of the PODocument object.

Contact_fax String False

The Contact_fax field of the PODocument object.

Contact_email1 String False

The Contact_email1 field of the PODocument object.

Contact_email2 String False

The Contact_email2 field of the PODocument object.

Contact_url1 String False

The Contact_url1 field of the PODocument object.

Contact_url2 String False

The Contact_url2 field of the PODocument object.

Contact_visible Boolean False

The Contact_visible field of the PODocument object.

Contact_mailaddress_address1 String False

The Contact_mailaddress_address1 field of the PODocument object.

Contact_mailaddress_address2 String False

The Contact_mailaddress_address2 field of the PODocument object.

Contact_mailaddress_city String False

The Contact_mailaddress_city field of the PODocument object.

Contact_mailaddress_state String False

The Contact_mailaddress_state field of the PODocument object.

Contact_mailaddress_zip String False

The Contact_mailaddress_zip field of the PODocument object.

Contact_mailaddress_country String False

The Contact_mailaddress_country field of the PODocument object.

Contact_mailaddress_countrycode String False

The Contact_mailaddress_countrycode field of the PODocument object.

Shiptokey String False

The Shiptokey field of the PODocument object.

Shipto_contactname String False

The Shipto_contactname field of the PODocument object.

Shipto_prefix String False

The Shipto_prefix field of the PODocument object.

Shipto_firstname String False

The Shipto_firstname field of the PODocument object.

Shipto_initial String False

The Shipto_initial field of the PODocument object.

Shipto_lastname String False

The Shipto_lastname field of the PODocument object.

Shipto_companyname String False

The Shipto_companyname field of the PODocument object.

Shipto_printas String False

The Shipto_printas field of the PODocument object.

Shipto_phone1 String False

The Shipto_phone1 field of the PODocument object.

Shipto_phone2 String False

The Shipto_phone2 field of the PODocument object.

Shipto_cellphone String False

The Shipto_cellphone field of the PODocument object.

Shipto_pager String False

The Shipto_pager field of the PODocument object.

Shipto_fax String False

The Shipto_fax field of the PODocument object.

Shipto_email1 String False

The Shipto_email1 field of the PODocument object.

Shipto_email2 String False

The Shipto_email2 field of the PODocument object.

Shipto_url1 String False

The Shipto_url1 field of the PODocument object.

Shipto_url2 String False

The Shipto_url2 field of the PODocument object.

Shipto_visible Boolean False

The Shipto_visible field of the PODocument object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the PODocument object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the PODocument object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the PODocument object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the PODocument object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the PODocument object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the PODocument object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the PODocument object.

Billtokey String False

The Billtokey field of the PODocument object.

Billto_contactname String False

The Billto_contactname field of the PODocument object.

Billto_prefix String False

The Billto_prefix field of the PODocument object.

Billto_firstname String False

The Billto_firstname field of the PODocument object.

Billto_initial String False

The Billto_initial field of the PODocument object.

Billto_lastname String False

The Billto_lastname field of the PODocument object.

Billto_companyname String False

The Billto_companyname field of the PODocument object.

Billto_printas String False

The Billto_printas field of the PODocument object.

Billto_phone1 String False

The Billto_phone1 field of the PODocument object.

Billto_phone2 String False

The Billto_phone2 field of the PODocument object.

Billto_cellphone String False

The Billto_cellphone field of the PODocument object.

Billto_pager String False

The Billto_pager field of the PODocument object.

Billto_fax String False

The Billto_fax field of the PODocument object.

Billto_email1 String False

The Billto_email1 field of the PODocument object.

Billto_email2 String False

The Billto_email2 field of the PODocument object.

Billto_url1 String False

The Billto_url1 field of the PODocument object.

Billto_url2 String False

The Billto_url2 field of the PODocument object.

Billto_visible Boolean False

The Billto_visible field of the PODocument object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the PODocument object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the PODocument object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the PODocument object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the PODocument object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the PODocument object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the PODocument object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the PODocument object.

Message String False

The Message field of the PODocument object.

Prrecordkey String False

The Prrecordkey field of the PODocument object.

Invbatchkey String False

The Invbatchkey field of the PODocument object.

Prinvbatchkey String False

The Prinvbatchkey field of the PODocument object.

Printed String False

The Printed field of the PODocument object.

Backorder String False

The Backorder field of the PODocument object.

Subtotal Double False

The Subtotal field of the PODocument object.

Total Double False

The Total field of the PODocument object.

Entglgroup Int64 False

The Entglgroup field of the PODocument object.

Currency String False

The Currency field of the PODocument object.

Exchratedate Datetime False

The Exchratedate field of the PODocument object.

Exchratetypes_name String False

The Exchratetypes_name field of the PODocument object.

Exchrate Double False

The Exchrate field of the PODocument object.

Schopkey String False

The Schopkey field of the PODocument object.

Salescontract String False

The Salescontract field of the PODocument object.

Usedascontract String False

The Usedascontract field of the PODocument object.

Trx_subtotal Double False

The Trx_subtotal field of the PODocument object.

Trx_total Double False

The Trx_total field of the PODocument object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the PODocument object.

Reneweddoc String False

The Reneweddoc field of the PODocument object.

Basecurr String False

The Basecurr field of the PODocument object.

Systemgenerated String False

The Systemgenerated field of the PODocument object.

Invoicerunkey Int64 False

The Invoicerunkey field of the PODocument object.

Docpar_in_out String False

The Docpar_in_out field of the PODocument object.

Custvendid String False

The Custvendid field of the PODocument object.

Custvendname String False

The Custvendname field of the PODocument object.

Trx_totalpaid String False

The Trx_totalpaid field of the PODocument object.

Totalpaid String False

The Totalpaid field of the PODocument object.

Trx_totalentered String False

The Trx_totalentered field of the PODocument object.

Totalentered String False

The Totalentered field of the PODocument object.

Trx_totaldue String False

The Trx_totaldue field of the PODocument object.

Totaldue String False

The Totaldue field of the PODocument object.

Paymentstatus String False

The Paymentstatus field of the PODocument object.

Megaentitykey Int64 False

The Megaentitykey field of the PODocument object.

Megaentityid String False

The Megaentityid field of the PODocument object.

Megaentityname String False

The Megaentityname field of the PODocument object.

Record_url String False

The Record_url field of the PODocument object.

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