GLEntry
Stores information about individual GL entries, including amounts, accounts, and supporting details for journal postings.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the GL entry. |
| Batchno | Int64 | Identifier for the batch containing this entry. |
| Userno | Int64 | Identifier for the user associated with this entry. |
| Line_no | Int64 | Line number within the batch or transaction. |
| Tr_type | Int64 | Transaction type code for the entry. |
| Entry_date | Datetime | Date when the entry was recorded. |
| Amount | Double | Net amount of the entry. |
| Trx_amount | Double | Transaction amount in the transaction currency. |
| Accountkey | Int64 | Unique key representing the account for this entry. |
| Accountno | String | Account number associated with the entry. |
| Departmentkey | Int64 | Key representing the department associated with the entry. |
| Department | String | Identifier for the department linked to the entry. |
| Departmenttitle | String | Name or title of the department. |
| Locationkey | Int64 | Key representing the location associated with the entry. |
| Location | String | Identifier for the location linked to the entry. |
| Locationname | String | Name of the location associated with the entry. |
| Document | String | Document number or identifier for the entry. |
| Description | String | Description or memo associated with the entry. |
| Units | Int64 | Number of units associated with the entry, if applicable. |
| Basecurr | String | Base currency for the entry. |
| Currency | String | Currency used for the transaction. |
| Cleared | String | Indicates if the entry has been cleared. |
| Clrdate | Datetime | Date when the entry was cleared. |
| Timeperiod | Int64 | Time period associated with the entry. |
| Adj | String | Indicates if the entry is an adjustment. |
| Exch_rate_date | Datetime | Date used for determining the exchange rate. |
| Exch_rate_type_id | String | Type identifier for the exchange rate used. |
| Exchange_rate | Double | Exchange rate applied to the transaction. |
| Recon_date | Datetime | Date when the entry was reconciled. |
| Allocation | String | Allocation type or identifier for the entry. |
| Allocationkey | Int64 | Key representing the allocation associated with the entry. |
| Whencreated | Datetime | Timestamp when the entry was created. |
| Whenmodified | Datetime | Timestamp when the entry was last modified. |
| Createdby | Int64 | Identifier of the user who created the entry. |
| Modifiedby | Int64 | Identifier of the user who last modified the entry. |
| State | String | State or status of the entry. |
| Projectdimkey | Int64 | Key associated with the project dimension for this entry. |
| Projectid | String | Identifier for the project linked to the entry. |
| Projectname | String | Name of the project associated with the entry. |
| Customerdimkey | Int64 | Key representing the customer dimension for this entry. |
| Customerid | String | Identifier for the customer associated with the entry. |
| Customername | String | Name of the customer associated with the entry. |
| Vendordimkey | Int64 | Key representing the vendor dimension for this entry. |
| Vendorid | String | Identifier for the vendor associated with the entry. |
| Vendorname | String | Name of the vendor associated with the entry. |
| Employeedimkey | Int64 | Key representing the employee dimension for this entry. |
| Employeeid | String | Identifier for the employee associated with the entry. |
| Employeename | String | Name of the employee associated with the entry. |
| Itemdimkey | Int64 | Key representing the item dimension for this entry. |
| Itemid | String | Identifier for the item associated with the entry. |
| Itemname | String | Name of the item associated with the entry. |
| Classdimkey | Int64 | Key representing the class dimension for this entry. |
| 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 for this entry. |