GLAcctGrp
Manages data for GL account groups, including group filters and configurations, to streamline categorization and reporting.
Table Specific Information
Insert
Insert is only supported when UseLegacy=False.
The following example illustrates how to insert into GLAcctGrp table:
INSERT INTO GLAcctGrp (Name, Normal_balance, Title, Totaltitle, Membertype, Itemaggregate) VALUES ('Testing Record 45', 'debit', 'A record', 'A record total', 'Accounts', '<acctrange_itemlist><acctrange><parentkey>1206</parentkey><rangefrom>1000</rangefrom><rangeto>1099</rangeto></acctrange></acctrange_itemlist>');
Note: Inserts are not supported with the Legacy API.
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
Unique identifier for the GL account group record. |
| Name [KEY] | String | False |
Name of the GL account group. |
| Normal_balance | String | False |
Indicates the normal balance type (debit or credit) for the GL account group. |
| Asof | String | False |
Specifies the 'as of' date or period for the GL account group. |
| Includechildamt | Boolean | False |
Indicates whether child amounts are included in the GL account group. |
| Title | String | False |
Title or description of the GL account group. |
| Totaltitle | String | False |
Title for the total amount of the GL account group. |
| Dbcr | String | False |
Specifies debit or credit balances for the GL account group. |
| Filterdept | String | False |
Department filter applied to the GL account group. |
| Filterloc | String | False |
Location filter applied to the GL account group. |
| Membertype | String | False |
Type of members included in the GL account group. |
| Deptno | String | False |
Department number associated with the GL account group. |
| Locno | String | False |
Location number associated with the GL account group. |
| Iskpi | Boolean | False |
Indicates whether the GL account group is part of a Key Performance Indicator (KPI). |
| Filtervendor | String | False |
Vendor filter applied to the GL account group. |
| Filtercustomer | String | False |
Customer filter applied to the GL account group. |
| Filterproject | String | False |
Project filter applied to the GL account group. |
| Filteremployee | String | False |
Employee filter applied to the GL account group. |
| Filteritem | String | False |
Item filter applied to the GL account group. |
| Filterclass | String | False |
Class filter applied to the GL account group. |
| Whencreated | Datetime | False |
Timestamp of when the GL account group was created. |
| Whenmodified | Datetime | False |
Timestamp of when the GL account group was last modified. |
| Createdby | Int64 | False |
User who created the GL account group. |
| Modifiedby | Int64 | False |
User who last modified the GL account group. |
| Megaentitykey | Int64 | False |
Key for the mega entity associated with the GL account group. |
| Megaentityid | String | False |
ID of the mega entity associated with the GL account group. |
| Megaentityname | String | False |
Name of the mega entity associated with the GL account group. |
| Projectdimkey | Int64 | False |
Key for the project dimension associated with the GL account group. |
| Projectid | String | False |
Project identifier associated with the GL account group. |
| Projectname | String | False |
Name of the project associated with the GL account group. |
| Customerdimkey | Int64 | False |
Key for the customer dimension associated with the GL account group. |
| Customerid | String | False |
Customer identifier associated with the GL account group. |
| Customername | String | False |
Name of the customer associated with the GL account group. |
| Vendordimkey | Int64 | False |
Key for the vendor dimension associated with the GL account group. |
| Vendorid | String | False |
Vendor identifier associated with the GL account group. |
| Vendorname | String | False |
Name of the vendor associated with the GL account group. |
| Employeedimkey | Int64 | False |
Key for the employee dimension associated with the GL account group. |
| Employeeid | String | False |
Employee identifier associated with the GL account group. |
| Employeename | String | False |
Name of the employee associated with the GL account group. |
| Itemdimkey | Int64 | False |
Key for the item dimension associated with the GL account group. |
| Itemid | String | False |
Item identifier associated with the GL account group. |
| Itemname | String | False |
Name of the item associated with the GL account group. |
| Classdimkey | Int64 | False |
Key for the class dimension associated with the GL account group. |
| Classid | String | False |
Class identifier associated with the GL account group. |
| Classname | String | False |
Name of the class associated with the GL account group. |
| Record_url | String | False |
URL for accessing the GL account group record. |