JDBC Driver for Sage Intacct

Build 22.0.8462

ARPayment

Retrieves ARPayment report data.

Columns

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

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