JDBC Driver for Sage Intacct

Build 22.0.8462

APPayment

Retrieves APPayment report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the APPayment object.
Prbatchkey Int64 The Prbatchkey field of the APPayment object.
Recordtype String The Recordtype field of the APPayment object.
Description String The Description field of the APPayment object.
Totalentered Double The Totalentered field of the APPayment object.
Totalpaid Double The Totalpaid field of the APPayment object.
Totalselected Double The Totalselected field of the APPayment object.
Totaldue Double The Totaldue field of the APPayment object.
State String The State field of the APPayment object.
Whencreated Datetime The Whencreated field of the APPayment object.
Whenpaid Datetime The Whenpaid field of the APPayment object.
Termkey Int64 The Termkey field of the APPayment object.
Termname String The Termname field of the APPayment object.
Whendiscount Datetime The Whendiscount field of the APPayment object.
Recordid String The Recordid field of the APPayment object.
Userkey Int64 The Userkey field of the APPayment object.
Whendue Datetime The Whendue field of the APPayment object.
Docnumber String The Docnumber field of the APPayment object.
Cleared String The Cleared field of the APPayment object.
Clrdate Datetime The Clrdate field of the APPayment object.
Modulekey String The Modulekey field of the APPayment object.
Status String The Status field of the APPayment object.
Systemgenerated String The Systemgenerated field of the APPayment object.
Whenposted Datetime The Whenposted field of the APPayment object.
Onhold Boolean The Onhold field of the APPayment object.
Currency String The Currency field of the APPayment object.
Trx_totalentered Double The Trx_totalentered field of the APPayment object.
Trx_totalpaid Double The Trx_totalpaid field of the APPayment object.
Trx_totalselected Double The Trx_totalselected field of the APPayment object.
Trx_totaldue Double The Trx_totaldue field of the APPayment object.
Deliverymethod String The Deliverymethod field of the APPayment object.
Recon_date Datetime The Recon_date field of the APPayment object.
Basecurr String The Basecurr field of the APPayment object.
Locationkey Int64 The Locationkey field of the APPayment object.
Auwhencreated Datetime The Auwhencreated field of the APPayment object.
Whenmodified Datetime The Whenmodified field of the APPayment object.
Createdby Int64 The Createdby field of the APPayment object.
Modifiedby Int64 The Modifiedby field of the APPayment object.
Nr_totalentered Double The Nr_totalentered field of the APPayment object.
Nr_trx_totalentered Double The Nr_trx_totalentered field of the APPayment object.
Paymenttype String The Paymenttype field of the APPayment object.
Paymentdate Datetime The Paymentdate field of the APPayment object.
Receiptdate Datetime The Receiptdate field of the APPayment object.
Paymentamount Double The Paymentamount field of the APPayment object.
Documentnumber String The Documentnumber field of the APPayment object.
Memo String The Memo field of the APPayment object.
Financialaccount String The Financialaccount field of the APPayment object.
Vendorname String The Vendorname field of the APPayment object.
Vendorid String The Vendorid field of the APPayment object.
Megaentitykey Int64 The Megaentitykey field of the APPayment object.
Megaentityid String The Megaentityid field of the APPayment object.
Record_url String The Record_url field of the APPayment object.

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