Tableau Connector for Sage Intacct

Build 21.0.7930

SODocumentEntry

Retrieves SODocumentEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the SODocumentEntry object.
Dochdrno Int64 The Dochdrno field of the SODocumentEntry object.
Dochdrid String The Dochdrid field of the SODocumentEntry object.
Bundlenumber String The Bundlenumber field of the SODocumentEntry object.
Line_no Int64 The Line_no field of the SODocumentEntry object.
Itemid String The Itemid field of the SODocumentEntry object.
Itemname String The Itemname field of the SODocumentEntry object.
Itemdesc String The Itemdesc field of the SODocumentEntry object.
Unit String The Unit field of the SODocumentEntry object.
Warehouse_location_no String The Warehouse_location_no field of the SODocumentEntry object.
Warehouse_name String The Warehouse_name field of the SODocumentEntry object.
Memo String The Memo field of the SODocumentEntry object.
Quantity Double The Quantity field of the SODocumentEntry object.
Qty_converted Double The Qty_converted field of the SODocumentEntry object.
Retailprice Double The Retailprice field of the SODocumentEntry object.
Price Double The Price field of the SODocumentEntry object.
Total Double The Total field of the SODocumentEntry object.
Whencreated Datetime The Whencreated field of the SODocumentEntry object.
Whenmodified Datetime The Whenmodified field of the SODocumentEntry object.
Item_taxable Boolean The Item_taxable field of the SODocumentEntry object.
Item_taxgroup_recordno Int64 The Item_taxgroup_recordno field of the SODocumentEntry object.
Item_renewalmacro_macroid String The Item_renewalmacro_macroid field of the SODocumentEntry object.
Extended_description String The Extended_description field of the SODocumentEntry object.
Itemglgroup String The Itemglgroup field of the SODocumentEntry object.
State String The State field of the SODocumentEntry object.
Status String The Status field of the SODocumentEntry object.
Glentrykey1 Int64 The Glentrykey1 field of the SODocumentEntry object.
Glentrykey2 Int64 The Glentrykey2 field of the SODocumentEntry object.
Cost Double The Cost field of the SODocumentEntry object.
Cost_method String The Cost_method field of the SODocumentEntry object.
Average_cost String The Average_cost field of the SODocumentEntry object.
Whse_average_cost String The Whse_average_cost field of the SODocumentEntry object.
Uiqty Double The Uiqty field of the SODocumentEntry object.
Discountpercent Double The Discountpercent field of the SODocumentEntry object.
Uiprice Double The Uiprice field of the SODocumentEntry object.
Uivalue Double The Uivalue field of the SODocumentEntry object.
Locationid String The Locationid field of the SODocumentEntry object.
Locationname String The Locationname field of the SODocumentEntry object.
Departmentid String The Departmentid field of the SODocumentEntry object.
Departmentname String The Departmentname field of the SODocumentEntry object.
Deptkey String The Deptkey field of the SODocumentEntry object.
Locationkey String The Locationkey field of the SODocumentEntry object.
Timetypekey Int64 The Timetypekey field of the SODocumentEntry object.
Timetypename String The Timetypename field of the SODocumentEntry object.
Timenotes String The Timenotes field of the SODocumentEntry object.
Eeaccountlabelkey Int64 The Eeaccountlabelkey field of the SODocumentEntry object.
Eeaccountlabel String The Eeaccountlabel field of the SODocumentEntry object.
Source_dockey String The Source_dockey field of the SODocumentEntry object.
Source_doclinekey String The Source_doclinekey field of the SODocumentEntry object.
Revrectemplate String The Revrectemplate field of the SODocumentEntry object.
Revrectemplatekey String The Revrectemplatekey field of the SODocumentEntry object.
Revrecstartdate Datetime The Revrecstartdate field of the SODocumentEntry object.
Itemterm String The Itemterm field of the SODocumentEntry object.
Termperiod String The Termperiod field of the SODocumentEntry object.
Revrecenddate Datetime The Revrecenddate field of the SODocumentEntry object.
Prorateprice Boolean The Prorateprice field of the SODocumentEntry object.
Deferrevenue String The Deferrevenue field of the SODocumentEntry object.
Sc_revrectemplate String The Sc_revrectemplate field of the SODocumentEntry object.
Sc_revrectemplatekey String The Sc_revrectemplatekey field of the SODocumentEntry object.
Sc_revrecstartdate Datetime The Sc_revrecstartdate field of the SODocumentEntry object.
Sc_revrecenddate Datetime The Sc_revrecenddate field of the SODocumentEntry object.
Sc_startdate Datetime The Sc_startdate field of the SODocumentEntry object.
Item_itemtype String The Item_itemtype field of the SODocumentEntry object.
Item_numdec_sale String The Item_numdec_sale field of the SODocumentEntry object.
Item_numdec_std String The Item_numdec_std field of the SODocumentEntry object.
Item_numdec_pur String The Item_numdec_pur field of the SODocumentEntry object.
Item_revposting String The Item_revposting field of the SODocumentEntry object.
Item_computeforshortterm Boolean The Item_computeforshortterm field of the SODocumentEntry object.
Item_renewalmacrokey Int64 The Item_renewalmacrokey field of the SODocumentEntry object.
Item_uomgrpkey Int64 The Item_uomgrpkey field of the SODocumentEntry object.
Discount_memo String The Discount_memo field of the SODocumentEntry object.
Item_revprinting String The Item_revprinting field of the SODocumentEntry object.
Currency String The Currency field of the SODocumentEntry object.
Exchratedate Datetime The Exchratedate field of the SODocumentEntry object.
Exchratetype String The Exchratetype field of the SODocumentEntry object.
Exchrate Double The Exchrate field of the SODocumentEntry object.
Trx_price Double The Trx_price field of the SODocumentEntry object.
Trx_value Double The Trx_value field of the SODocumentEntry object.
Schedulename String The Schedulename field of the SODocumentEntry object.
Scheduleid String The Scheduleid field of the SODocumentEntry object.
Recurdocname String The Recurdocname field of the SODocumentEntry object.
Recurdocid String The Recurdocid field of the SODocumentEntry object.
Recurdocentrykey Int64 The Recurdocentrykey field of the SODocumentEntry object.
Renewalmacro String The Renewalmacro field of the SODocumentEntry object.
Renewalmacrokey String The Renewalmacrokey field of the SODocumentEntry object.
Overridetax Boolean The Overridetax field of the SODocumentEntry object.
Sc_createrecursched String The Sc_createrecursched field of the SODocumentEntry object.
Sc_existingsched String The Sc_existingsched field of the SODocumentEntry object.
Sc_extendlineperiod Boolean The Sc_extendlineperiod field of the SODocumentEntry object.
Sc_installpricing Boolean The Sc_installpricing field of the SODocumentEntry object.
Recurcontractid String The Recurcontractid field of the SODocumentEntry object.
Source_docid String The Source_docid field of the SODocumentEntry object.
Billable Boolean The Billable field of the SODocumentEntry object.
Billed Boolean The Billed field of the SODocumentEntry object.
Billabletimeentrykey Int64 The Billabletimeentrykey field of the SODocumentEntry object.
Billableprentrykey Int64 The Billableprentrykey field of the SODocumentEntry object.
Billabledocentrykey Int64 The Billabledocentrykey field of the SODocumentEntry object.
Percentval Double The Percentval field of the SODocumentEntry object.
Taxabsval Double The Taxabsval field of the SODocumentEntry object.
Taxableamount Double The Taxableamount field of the SODocumentEntry object.
Linetotal Double The Linetotal field of the SODocumentEntry object.
Discount Double The Discount field of the SODocumentEntry object.
Trx_taxabsval Double The Trx_taxabsval field of the SODocumentEntry object.
Trx_linetotal Double The Trx_linetotal field of the SODocumentEntry object.
Taxvaloverride Boolean The Taxvaloverride field of the SODocumentEntry object.
Projectkey String The Projectkey field of the SODocumentEntry object.
Projectname String The Projectname field of the SODocumentEntry object.
Taskkey String The Taskkey field of the SODocumentEntry object.
Taskname String The Taskname field of the SODocumentEntry object.
Billingtemplatekey String The Billingtemplatekey field of the SODocumentEntry object.
Billingtemplate String The Billingtemplate field of the SODocumentEntry object.
Projectdimkey Int64 The Projectdimkey field of the SODocumentEntry object.
Projectid String The Projectid field of the SODocumentEntry object.
Vendordimkey Int64 The Vendordimkey field of the SODocumentEntry object.
Vendorid String The Vendorid field of the SODocumentEntry object.
Vendorname String The Vendorname field of the SODocumentEntry object.
Employeedimkey Int64 The Employeedimkey field of the SODocumentEntry object.
Employeeid String The Employeeid field of the SODocumentEntry object.
Employeename String The Employeename field of the SODocumentEntry object.
Record_url String The Record_url field of the SODocumentEntry object.

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