JDBC Driver for Sage Intacct

Build 22.0.8462

EPPayment

Retrieves EPPayment report data.

Columns

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

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