JDBC Driver for Sage Intacct

Build 22.0.8462

WfpmPaymentRequest

Retrieves WfpmPaymentRequest report data.

Columns

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

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