GLBatch
Retrieves GLBatch report data.
Table Specific Information
Sage Intacct allows the user to update the GLBatch table and the associated GLEntry child table (read-only) by adding new GLEntry items to the associated GLBatch object.
The driver does this by using the ItemAggregate field. The following is an example of an UPDATE statement:
UPDATE GLBatch SET [Batch_Title] = 'new title',
ItemAggregate=' <GLENTRY>
<ACCOUNTNO>6530/ACCOUNTNO>
<DESCRIPTION>modifyme/DESCRIPTION>
<LOCATIONKEY>4/LOCATIONKEY>
<LOCATION>100/LOCATION>
<LOCATIONNAME>corporate/LOCATIONNAME>
<TRX_AMOUNT>20/TRX_AMOUNT> <TR_TYPE>-1/TR_TYPE>
<GLDIMTYPE>location/GLDIMTYPE> <GLDIMSERVICE>service/GLDIMSERVICE>
/GLENTRY>
<GLENTRY>
<ACCOUNTNO>6530/ACCOUNTNO> <DESCRIPTION>modified/DESCRIPTION>
<LOCATIONKEY>4/LOCATIONKEY> <LOCATION>100/LOCATION> <LOCATIONNAME>corporate/LOCATIONNAME>
<MODIFIEDBY>NULL/MODIFIEDBY><PROJECTID>null/PROJECTID><TRX_AMOUNT>20/TRX_AMOUNT>
<TR_TYPE>1/TR_TYPE> <GLDIMTYPE>location/GLDIMTYPE> <GLDIMSERVICE>service
/GLDIMSERVICE>
/GLENTRY>'
where Recrdno='xxx'
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
The Recordno field of the GLBatch object. |
| Batchno | Int64 | False |
The Batchno field of the GLBatch object. |
| Batch_title | String | False |
The Batch_title field of the GLBatch object. |
| Balance | Double | False |
The Balance field of the GLBatch object. |
| Journal | String | False |
The Journal field of the GLBatch object. |
| Batch_date | Datetime | False |
The Batch_date field of the GLBatch object. |
| Module | String | False |
The Module field of the GLBatch object. |
| Userkey | Int64 | False |
The Userkey field of the GLBatch object. |
| Referenceno | String | False |
The Referenceno field of the GLBatch object. |
| Reversed | Datetime | False |
The Reversed field of the GLBatch object. |
| Reversedkey | Int64 | False |
The Reversedkey field of the GLBatch object. |
| Reversedfrom | String | False |
The Reversedfrom field of the GLBatch object. |
| Templatekey | Int64 | False |
The Templatekey field of the GLBatch object. |
| Prbatchkey | Int64 | False |
The Prbatchkey field of the GLBatch object. |
| Modified | Datetime | False |
The Modified field of the GLBatch object. |
| Modifiedbyid | String | False |
The Modifiedbyid field of the GLBatch object. |
| Schopkey | Int64 | False |
The Schopkey field of the GLBatch object. |
| Baselocation | String | False |
The Baselocation field of the GLBatch object. |
| Baselocation_no | String | False |
The Baselocation_no field of the GLBatch object. |
| Userinfo_loginid | String | False |
The Userinfo_loginid field of the GLBatch object. |
| Whencreated | Datetime | False |
The Whencreated field of the GLBatch object. |
| Whenmodified | Datetime | False |
The Whenmodified field of the GLBatch object. |
| Createdby | Int64 | False |
The Createdby field of the GLBatch object. |
| Modifiedby | Int64 | False |
The Modifiedby field of the GLBatch object. |
| State | String | False |
The State field of the GLBatch object. |
| Megaentitykey | Int64 | False |
The Megaentitykey field of the GLBatch object. |
| Megaentityid | String | False |
The Megaentityid field of the GLBatch object. |
| Megaentityname | String | False |
The Megaentityname field of the GLBatch object. |
| Record_url | String | False |
The Record_url field of the GLBatch object. |
| ItemAggregate | String | False |
The GLEntry items related to the GLBatch object. |