Tableau Connector for Sage Intacct

Build 21.0.7930

APPymt

Retrieves APPymt report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the APPymt object.

Recordtype String False

The Recordtype field of the APPymt object.

Recordid String False

The Recordid field of the APPymt object.

Financialentity String False

The Financialentity field of the APPymt object.

State String False

The State field of the APPymt object.

Paymentmethod String False

The Paymentmethod field of the APPymt object.

Paymentmethodkey Int64 False

The Paymentmethodkey field of the APPymt object.

Entity String False

The Entity field of the APPymt object.

Vendorid String False

The Vendorid field of the APPymt object.

Vendorname String False

The Vendorname field of the APPymt object.

Docnumber String False

The Docnumber field of the APPymt object.

Description String False

The Description field of the APPymt object.

Description2 String False

The Description2 field of the APPymt object.

Whencreated Datetime False

The Whencreated field of the APPymt object.

Whenpaid Datetime False

The Whenpaid field of the APPymt object.

Basecurr String False

The Basecurr field of the APPymt object.

Currency String False

The Currency field of the APPymt object.

Exch_rate_date Datetime False

The Exch_rate_date field of the APPymt object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the APPymt object.

Exchange_rate Double False

The Exchange_rate field of the APPymt object.

Totalentered Double False

The Totalentered field of the APPymt object.

Totalselected Double False

The Totalselected field of the APPymt object.

Totalpaid Double False

The Totalpaid field of the APPymt object.

Totaldue String False

The Totaldue field of the APPymt object.

Trx_totalentered Double False

The Trx_totalentered field of the APPymt object.

Trx_totalselected Double False

The Trx_totalselected field of the APPymt object.

Trx_totalpaid Double False

The Trx_totalpaid field of the APPymt object.

Trx_totaldue Double False

The Trx_totaldue field of the APPymt object.

Billtopaytocontactname String False

The Billtopaytocontactname field of the APPymt object.

Prbatch String False

The Prbatch field of the APPymt object.

Auwhencreated Datetime False

The Auwhencreated field of the APPymt object.

Whenmodified Datetime False

The Whenmodified field of the APPymt object.

Createdby Int64 False

The Createdby field of the APPymt object.

Modifiedby Int64 False

The Modifiedby field of the APPymt object.

Megaentitykey Int64 False

The Megaentitykey field of the APPymt object.

Megaentityid String False

The Megaentityid field of the APPymt object.

Record_url String False

The Record_url field of the APPymt object.

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