JDBC Driver for Sage Intacct

Build 20.0.7654

GLDetail

Retrieves GLDetail report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the GLDetail object.
Batchkey Int64 The Batchkey field of the GLDetail object.
Batch_date Datetime The Batch_date field of the GLDetail object.
Batch_title String The Batch_title field of the GLDetail object.
Symbol String The Symbol field of the GLDetail object.
Batch_no Int64 The Batch_no field of the GLDetail object.
Bookid String The Bookid field of the GLDetail object.
Childentity String The Childentity field of the GLDetail object.
Modified Datetime The Modified field of the GLDetail object.
Referenceno String The Referenceno field of the GLDetail object.
Adj Boolean The Adj field of the GLDetail object.
Modulekey String The Modulekey field of the GLDetail object.
Ownershipkey Int64 The Ownershipkey field of the GLDetail object.
Line_no Int64 The Line_no field of the GLDetail object.
Entry_date Datetime The Entry_date field of the GLDetail object.
Tr_type Int64 The Tr_type field of the GLDetail object.
Document String The Document field of the GLDetail object.
Accountno String The Accountno field of the GLDetail object.
Accounttitle String The Accounttitle field of the GLDetail object.
Statistical String The Statistical field of the GLDetail object.
Departmentid String The Departmentid field of the GLDetail object.
Departmenttitle String The Departmenttitle field of the GLDetail object.
Locationid String The Locationid field of the GLDetail object.
Locationname String The Locationname field of the GLDetail object.
Currency String The Currency field of the GLDetail object.
Basecurr String The Basecurr field of the GLDetail object.
Description String The Description field of the GLDetail object.
Debitamount Double The Debitamount field of the GLDetail object.
Creditamount Double The Creditamount field of the GLDetail object.
Amount Double The Amount field of the GLDetail object.
Trx_debitamount Double The Trx_debitamount field of the GLDetail object.
Trx_creditamount Double The Trx_creditamount field of the GLDetail object.
Trx_amount Double The Trx_amount field of the GLDetail object.
Cleared String The Cleared field of the GLDetail object.
Clrdate Datetime The Clrdate field of the GLDetail object.
Custentity String The Custentity field of the GLDetail object.
Vendentity String The Vendentity field of the GLDetail object.
Empentity String The Empentity field of the GLDetail object.
Locentity String The Locentity field of the GLDetail object.
Recordtype String The Recordtype field of the GLDetail object.
Recordid String The Recordid field of the GLDetail object.
Docnumber String The Docnumber field of the GLDetail object.
State String The State field of the GLDetail object.
Whencreated Datetime The Whencreated field of the GLDetail object.
Whendue Datetime The Whendue field of the GLDetail object.
Whenpaid Datetime The Whenpaid field of the GLDetail object.
Whenmodified Datetime The Whenmodified field of the GLDetail object.
Prdescription String The Prdescription field of the GLDetail object.
Prcleared String The Prcleared field of the GLDetail object.
Prclrdate Datetime The Prclrdate field of the GLDetail object.
Financialentity String The Financialentity field of the GLDetail object.
Totalentered Double The Totalentered field of the GLDetail object.
Totalpaid Double The Totalpaid field of the GLDetail object.
Totaldue Double The Totaldue field of the GLDetail object.
Entrydescription String The Entrydescription field of the GLDetail object.
Glentrykey Int64 The Glentrykey field of the GLDetail object.
Createdby String The Createdby field of the GLDetail object.
Batch_state String The Batch_state field of the GLDetail object.
Entry_state String The Entry_state field of the GLDetail object.
Auwhencreated Datetime The Auwhencreated field of the GLDetail object.
Aucreatedby Int64 The Aucreatedby field of the GLDetail object.
Modifiedby Int64 The Modifiedby field of the GLDetail object.
Projectdimkey Int64 The Projectdimkey field of the GLDetail object.
Projectid String The Projectid field of the GLDetail object.
Projectname String The Projectname field of the GLDetail object.
Customerdimkey Int64 The Customerdimkey field of the GLDetail object.
Customerid String The Customerid field of the GLDetail object.
Customername String The Customername field of the GLDetail object.
Vendordimkey Int64 The Vendordimkey field of the GLDetail object.
Vendorid String The Vendorid field of the GLDetail object.
Vendorname String The Vendorname field of the GLDetail object.
Employeedimkey Int64 The Employeedimkey field of the GLDetail object.
Employeeid String The Employeeid field of the GLDetail object.
Employeename String The Employeename field of the GLDetail object.
Itemdimkey Int64 The Itemdimkey field of the GLDetail object.
Itemid String The Itemid field of the GLDetail object.
Itemname String The Itemname field of the GLDetail object.
Classdimkey Int64 The Classdimkey field of the GLDetail object.
Classid String The Classid field of the GLDetail object.
Classname String The Classname field of the GLDetail object.
Record_url String The Record_url field of the GLDetail object.

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