JDBC Driver for Sage Intacct

Build 20.0.7654

ExpenseAdjustments

Retrieves ExpenseAdjustments report data.

Columns

Name Type ReadOnly Description
Recordid [KEY] String False

The Recordid field of the ExpenseAdjustments object.

Contact_lastname String False

The Contact_lastname field of the ExpenseAdjustments object.

Contact_firstname String False

The Contact_firstname field of the ExpenseAdjustments object.

Recordno String False

The Recordno field of the ExpenseAdjustments object.

Whencreated Datetime False

The Whencreated field of the ExpenseAdjustments object.

Whenposted Datetime False

The Whenposted field of the ExpenseAdjustments object.

Totalentered Double False

The Totalentered field of the ExpenseAdjustments object.

State String False

The State field of the ExpenseAdjustments object.

Totalpaid Double False

The Totalpaid field of the ExpenseAdjustments object.

Totalselected Double False

The Totalselected field of the ExpenseAdjustments object.

Totaldue Double False

The Totaldue field of the ExpenseAdjustments object.

Recordtype String False

The Recordtype field of the ExpenseAdjustments object.

Systemgenerated String False

The Systemgenerated field of the ExpenseAdjustments object.

Prbatch String False

The Prbatch field of the ExpenseAdjustments object.

Prbatchkey Int64 False

The Prbatchkey field of the ExpenseAdjustments object.

Empentity String False

The Empentity field of the ExpenseAdjustments object.

Description String False

The Description field of the ExpenseAdjustments object.

Whenpaid Datetime False

The Whenpaid field of the ExpenseAdjustments object.

Whenmodified Datetime False

The Whenmodified field of the ExpenseAdjustments object.

Currency String False

The Currency field of the ExpenseAdjustments object.

Basecurr String False

The Basecurr field of the ExpenseAdjustments object.

Entity String False

The Entity field of the ExpenseAdjustments object.

Userkey String False

The Userkey field of the ExpenseAdjustments object.

Employeeid String False

The Employeeid field of the ExpenseAdjustments object.

Docnumber String False

The Docnumber field of the ExpenseAdjustments object.

Nr_totalentered Double False

The Nr_totalentered field of the ExpenseAdjustments object.

Nr_trx_totalentered Double False

The Nr_trx_totalentered field of the ExpenseAdjustments object.

Auwhencreated Datetime False

The Auwhencreated field of the ExpenseAdjustments object.

Createdby Int64 False

The Createdby field of the ExpenseAdjustments object.

Modifiedby Int64 False

The Modifiedby field of the ExpenseAdjustments object.

Megaentitykey Int64 False

The Megaentitykey field of the ExpenseAdjustments object.

Megaentityid String False

The Megaentityid field of the ExpenseAdjustments object.

Record_url String False

The Record_url field of the ExpenseAdjustments object.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654