RecurGLEntry
Contains individual entries within recurring GL batches, detailing accounts, amounts, and effective dates for consistent financial postings.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the recurring GL entry. |
| Recurglbatchno | String | Batch number associated with the recurring GL entry. |
| Locationkey | String | Key for the location associated with the entry. |
| Location | String | Code for the location associated with the entry. |
| Locationname | String | Name of the location associated with the entry. |
| Deptkey | String | Key for the department associated with the entry. |
| Department | String | Code for the department associated with the entry. |
| Departmentname | String | Name of the department associated with the entry. |
| Accountkey | String | Key for the account associated with the entry. |
| Accountno | String | Account number associated with the entry. |
| Accounttitle | String | Title of the account associated with the entry. |
| Document | String | Document associated with the recurring GL entry. |
| Tr_type | String | Transaction type for the GL entry. |
| Amount | String | Amount for the recurring GL entry. |
| Memo | String | Memo or note for the entry. |
| Whencreated | Datetime | Timestamp when the entry was created. |
| Username | String | Username of the person who created the entry. |
| Allocationkey | String | Key for the allocation associated with the entry. |
| Allocation | String | Allocation code associated with the entry. |
| Units | String | Number of units associated with the entry. |
| Basecurr | String | Base currency for the entry. |
| Currency | String | Transaction currency for the entry. |
| Trx_amount | String | Transaction amount for the entry in the specified currency. |
| Exch_rate_date | Datetime | Date of the exchange rate used for the entry. |
| Exch_rate_type_id | String | Type of exchange rate applied to the entry. |
| Exchange_rate | Double | Exchange rate applied to the entry. |
| Projectdimkey | Int64 | Key for the project dimension associated with the entry. |
| Projectid | String | Identifier for the project associated with the entry. |
| Projectname | String | Name of the project associated with the entry. |
| Customerdimkey | Int64 | Key for the customer dimension associated with the entry. |
| Customerid | String | Identifier for the customer associated with the entry. |
| Customername | String | Name of the customer associated with the entry. |
| Vendordimkey | Int64 | Key for the vendor dimension associated with the entry. |
| Vendorid | String | Identifier for the vendor associated with the entry. |
| Vendorname | String | Name of the vendor associated with the entry. |
| Employeedimkey | Int64 | Key for the employee dimension associated with the entry. |
| Employeeid | String | Identifier for the employee associated with the entry. |
| Employeename | String | Name of the employee associated with the entry. |
| Itemdimkey | Int64 | Key for the item dimension associated with the entry. |
| Itemid | String | Identifier for the item associated with the entry. |
| Itemname | String | Name of the item associated with the entry. |
| Classdimkey | Int64 | Key for the class dimension associated with the 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 for accessing the record of the entry. |