RecurGLBatch
Houses information on recurring general ledger batches, enabling automatic posting of repeated financial transactions.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
Unique identifier for the recurring GL batch. |
| Transactionno | Int64 | False |
Transaction number associated with the batch. |
| Description | String | False |
Description of the GL batch. |
| Referenceno | String | False |
Reference number for the GL batch. |
| Journal | String | False |
Journal name linked to the GL batch. |
| Journalkey | String | False |
Unique key for the journal associated with the batch. |
| Journaltitle | String | False |
Title of the journal associated with the batch. |
| Lastposted | Datetime | False |
Date and time the batch was last posted. |
| Lastreversed | Datetime | False |
Date and time the batch was last reversed. |
| Whencreated | Datetime | False |
Date and time the batch was created. |
| Whenmodified | Datetime | False |
Date and time the batch was last modified. |
| Createdby | Int64 | False |
Identifier of the user who created the batch. |
| Modifiedby | Int64 | False |
Identifier of the user who last modified the batch. |
| Status | String | False |
Current status of the GL batch. |
| Statistical | Boolean | False |
Indicates whether the batch contains statistical entries. |
| Startdateje | Datetime | False |
Start date for the journal entries in the batch. |
| Occurje | Int64 | False |
Number of occurrences for the journal entries in the batch. |
| Enddateje | Datetime | False |
End date for the journal entries in the batch. |
| Repeatintervalje | String | False |
Interval for repeating journal entries in the batch. |
| Repeatje | String | False |
Repeat pattern for the journal entries in the batch. |
| Eomje | Boolean | False |
Indicates whether the journal entries repeat at the end of the month. |
| Jeexeccount | Int64 | False |
Count of executed journal entries in the batch. |
| Jenextexecdate | Datetime | False |
Next execution date for the journal entries in the batch. |
| Emailje | String | False |
Email address for notifications about journal entry execution. |
| Startdaterevje | Datetime | False |
Start date for reversing journal entries. |
| Occurrevje | Int64 | False |
Number of occurrences for reversing journal entries. |
| Enddaterevje | Datetime | False |
End date for reversing journal entries. |
| Repeatintervalrevje | String | False |
Interval for repeating reversing journal entries. |
| Repeatrevje | String | False |
Repeat pattern for reversing journal entries. |
| Eomrevje | Boolean | False |
Indicates whether reversing journal entries repeat at the end of the month. |
| Revjeexeccount | Int64 | False |
Count of executed reversing journal entries. |
| Revjenextexecdate | Datetime | False |
Next execution date for reversing journal entries. |
| Emailrevje | String | False |
Email address for notifications about reversing journal entry execution. |
| Ismanualpost | Boolean | False |
Indicates whether the batch requires manual posting. |
| Autorepeatby | String | False |
Method used to auto-repeat the batch. |
| Autorepeatinterval | Int64 | False |
Interval for auto-repeating the batch. |
| Baselocation_no | String | False |
Base location number associated with the batch. |
| Megaentitykey | Int64 | False |
Key for the mega-entity associated with the batch. |
| Megaentityid | String | False |
Identifier for the mega-entity associated with the batch. |
| Megaentityname | String | False |
Name of the mega-entity associated with the batch. |
| Record_url | String | False |
URL for accessing the record of the batch. |