JDBC Driver for Sage Intacct

Build 22.0.8462

APPaymentRequest

Retrieves APPaymentRequest report data.

Columns

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

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