JDBC Driver for Sage Intacct

Build 22.0.8462

OtherReceipts

Retrieves OtherReceipts report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the OtherReceipts object.
Whencreated Datetime The Whencreated field of the OtherReceipts object.
Recordtype String The Recordtype field of the OtherReceipts object.
Description2 String The Description2 field of the OtherReceipts object.
Whenpaid Datetime The Whenpaid field of the OtherReceipts object.
Paymethod String The Paymethod field of the OtherReceipts object.
Docnumber String The Docnumber field of the OtherReceipts object.
Description String The Description field of the OtherReceipts object.
Bankaccountid String The Bankaccountid field of the OtherReceipts object.
Bankaccountname String The Bankaccountname field of the OtherReceipts object.
Bankaccountcurr String The Bankaccountcurr field of the OtherReceipts object.
Depositdate Datetime The Depositdate field of the OtherReceipts object.
Prbatchkey Int64 The Prbatchkey field of the OtherReceipts object.
Basecurr String The Basecurr field of the OtherReceipts object.
Currency String The Currency field of the OtherReceipts object.
Exch_rate_date Datetime The Exch_rate_date field of the OtherReceipts object.
Exch_rate_type_id String The Exch_rate_type_id field of the OtherReceipts object.
Exchange_rate Double The Exchange_rate field of the OtherReceipts object.
Totalentered Double The Totalentered field of the OtherReceipts object.
Trx_totalentered Double The Trx_totalentered field of the OtherReceipts object.
Recon_date Datetime The Recon_date field of the OtherReceipts object.
State String The State field of the OtherReceipts object.
Rawstate String The Rawstate field of the OtherReceipts object.
Cleared String The Cleared field of the OtherReceipts object.
Parentpayment Int64 The Parentpayment field of the OtherReceipts object.
Impliedlocation Int64 The Impliedlocation field of the OtherReceipts object.
Auwhencreated Datetime The Auwhencreated field of the OtherReceipts object.
Whenmodified Datetime The Whenmodified field of the OtherReceipts object.
Createdby Int64 The Createdby field of the OtherReceipts object.
Modifiedby Int64 The Modifiedby field of the OtherReceipts object.
Megaentitykey Int64 The Megaentitykey field of the OtherReceipts object.
Megaentityid String The Megaentityid field of the OtherReceipts object.
Megaentityname String The Megaentityname field of the OtherReceipts object.
Record_url String The Record_url field of the OtherReceipts object.

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