GLDetail
Contains granular details of General Ledger (GL) entries, including transaction data for precise financial tracking.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the GL detail entry. |
| Batchkey | Int64 | Identifier for the batch associated with this entry. |
| Batch_date | Datetime | Date when the batch was created. |
| Batch_title | String | Title or description of the batch. |
| Symbol | String | Symbol or code representing the currency or transaction type. |
| Batch_no | Int64 | Sequential number assigned to the batch. |
| Bookid | String | Identifier for the book associated with this entry. |
| Childentity | String | Identifier for the subsidiary or child entity associated with this entry. |
| Modified | Datetime | Timestamp when the entry was last modified. |
| Referenceno | String | Reference number associated with the transaction. |
| Adj | Boolean | Indicates if the entry is an adjustment. |
| Modulekey | String | Key representing the module that generated the entry. |
| Ownershipkey | Int64 | Key representing the ownership of the entry. |
| Line_no | Int64 | Line number within the transaction or batch. |
| Entry_date | Datetime | Date of the journal entry. |
| Tr_type | Int64 | Transaction type code. |
| Document | String | Document associated with the transaction. |
| Accountno | String | Account number impacted by the transaction. |
| Accounttitle | String | Title or name of the account. |
| Statistical | String | Indicates if the entry is statistical in nature. |
| Departmentid | String | Identifier for the department associated with the entry. |
| Departmenttitle | String | Title or name of the department. |
| Locationid | String | Identifier for the location associated with the entry. |
| Locationname | String | Name of the location associated with the entry. |
| Currency | String | Currency used in the transaction. |
| Basecurr | String | Base currency used for reporting. |
| Description | String | Description or memo associated with the entry. |
| Debitamount | Double | Debit amount for this entry. |
| Creditamount | Double | Credit amount for this entry. |
| Amount | Double | Net amount for this entry. |
| Trx_debitamount | Double | Transaction debit amount in the transaction currency. |
| Trx_creditamount | Double | Transaction credit amount in the transaction currency. |
| Trx_amount | Double | Transaction amount in the transaction currency. |
| Cleared | String | Indicates if the entry has been cleared. |
| Clrdate | Datetime | Date when the entry was cleared. |
| Custentity | String | Customer entity associated with the entry. |
| Vendentity | String | Vendor entity associated with the entry. |
| Empentity | String | Employee entity associated with the entry. |
| Locentity | String | Location entity associated with the entry. |
| Recordtype | String | Type of record associated with this entry. |
| Recordid | String | Unique identifier for the record. |
| Docnumber | String | Document number associated with this entry. |
| State | String | State or status of the entry. |
| Whencreated | Datetime | Timestamp when the entry was created. |
| Whendue | Datetime | Due date associated with the entry. |
| Whenpaid | Datetime | Timestamp when the entry was paid. |
| Whenmodified | Datetime | Timestamp when the entry was last modified. |
| Prdescription | String | Description or notes for prior reconciliation. |
| Prcleared | String | Indicates if prior reconciliation was cleared. |
| Prclrdate | Datetime | Date when prior reconciliation was cleared. |
| Financialentity | String | Financial entity associated with the entry. |
| Totalentered | Double | Total amount entered in the batch or transaction. |
| Totalpaid | Double | Total amount paid for this entry. |
| Totaldue | Double | Total amount due for this entry. |
| Entrydescription | String | Description of the journal entry. |
| Glentrykey | Int64 | Unique key for the GL entry. |
| Createdby | String | Identifier for the user who created the entry. |
| Batch_state | String | State or status of the batch. |
| Entry_state | String | State or status of the entry within the batch. |
| Auwhencreated | Datetime | Timestamp when the entry was created for audit purposes. |
| Aucreatedby | Int64 | Identifier of the user who created the entry for audit purposes. |
| Modifiedby | Int64 | Identifier of the user who last modified the entry. |
| Projectdimkey | Int64 | Key associated with the project dimension. |
| Projectid | String | Identifier for the project associated with the entry. |
| Projectname | String | Name of the project associated with the entry. |
| Customerdimkey | Int64 | Key associated with the customer dimension. |
| Customerid | String | Identifier for the customer associated with the entry. |
| Customername | String | Name of the customer associated with the entry. |
| Vendordimkey | Int64 | Key associated with the vendor dimension. |
| Vendorid | String | Identifier for the vendor associated with the entry. |
| Vendorname | String | Name of the vendor associated with the entry. |
| Employeedimkey | Int64 | Key associated with the employee dimension. |
| Employeeid | String | Identifier for the employee associated with the entry. |
| Employeename | String | Name of the employee associated with the entry. |
| Itemdimkey | Int64 | Key associated with the item dimension. |
| Itemid | String | Identifier for the item associated with the entry. |
| Itemname | String | Name of the item associated with the entry. |
| Classdimkey | Int64 | Key associated with the class dimension. |
| Classid | String | Identifier for the class associated with the entry. |
| Classname | String | Name of the class associated with the entry. |
| Record_url | String | URL link to access the record associated with this entry. |