JDBC Driver for Sage Intacct

Build 22.0.8462

EPPaymentRequest

Retrieves EPPaymentRequest report data.

Columns

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

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