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 assocaited GLBatch object.
The driver does this by using the ItemAggregate field. The following is an example of an UPDATE statemet:
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. |