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. |