GLAccountCategory
Version: 1.33
General Ledger (G/L) Account Categories provide structure for reporting of General Ledger accounts. When creating General Ledger Accounts in the Chart of Accounts, an Account Category is required information for each G/L Account.
Through the graphical user interface (GUI), Gotransverse enables you to define the structure, size, and number sequence of the G/L Accounts and to define complex, hierarchical relationships either directly between G/L Accounts and/or between user-defined G/L Account Categories (click on the following link for details in GUI documentation: G/L Account Categories). You must match the accounting structure in Gotransverse with that of your corporate G/L system. Accounting and revenue reports generated in Gotransverse will contain the same relationships and break out as reports generated in the corporate G/L system. The G/L Transactions exported from Gotransverse can be easily imported into the corporate G/L system.
Gotransverse provides you with over a dozen commonly used G/L Account Categories. You can change any of them at any time, or before using them you have the option of deleting any of them. After an Account Category has been assigned, it cannot be deleted, but if you un-assign it, it can then be canceled.
GLAccountCategories are shown in the GUI alphabetically by Account Type group. Asset Account Categories are shown alphabetically, then Expense Account Categories, then Liabilities, and so forth.
GLAccountCategory can only be queried, viewed, and used through the Gotransverse API, but not created. Create G/L Account Categories in the Gotransverse GUI.
Query GLAccountCategory directly or through GLAccount.
Perform through the GUI
-
CREATE more G/L Account Categories as needed.
-
View the G/L Account Categories.
-
Assign the G/L Account Categories to General Ledger Accounts.
Perform through the API
-
Query and view the GLAccountCategories.
-
Assign the G/L Account Categories to General Ledger Accounts.
Parameters
Each G/L Account Category shown from the Query shows information for a number of Elements in the Entity. The following table shows the Elements, details of the Elements, and brief descriptions.
| Element Name | Query Key |
Element Type | Field Length | Description |
|---|---|---|---|---|
|
queryScope |
QueryScope |
- - |
Whether default query results are overridden by QueryScope resulting in SHALLOW or DEEP query results. Refer to QueryScope for details. |
|
|
eid |
Y |
Long |
System Generated |
System generated unique identity number assigned to all entities in Gotransverse. |
|
accountType |
AccountType |
255 |
The type of Account Category, Asset, Liability, and so forth. |
|
|
name |
Y |
String |
255 |
The name of the Account Category |
|
description |
String |
255 |
A description of the Account Category. |
|
|
status |
Y |
AccountingStatus |
255 |
The status of the General Ledger. Refer to AccountingStatus for details. |
Entity GLAccountCategories
The entity GLAccountCategories enables you to see multiple pages of the entity GLAccountCategory.
| Element Name | Element Type | Field Length | Description | |
|---|---|---|---|---|
|
pageNumber |
Integer |
as needed |
Shows the current page number. |
|
|
pageSize |
Integer |
as needed |
Shows the page size. |
|
|
totalElements |
Long |
as needed |
Shows the total number of items found. |
|
|
elementCount |
Integer |
as needed |
Shows the current count of the item in the number of items that were found. |
|
|
totalPages |
Integer |
as needed |
Shows the total number of pages. |
|
|
GLAccountCategories |
GLAccountCategory |
- - |
Shows the list of GLAccountCategories. |
|
Information for the related Entity of G/L Account Categories:
-
Entity G/L Account Categories
Query a G/L Account Category
Query Key Information
To query for all G/L Account Categories, use the SimpleDataQuery with no parameters.
| Query to Use | Query for | Returns | ||
|---|---|---|---|---|
|
SimpleDataQuery |
GLAccountCategory |
Complete list of all of your G/L Account Categories. |
||
To query for more specific information, use the SimpleDataQuery with one of the following Query Keys:
| Query Key | Value | Definition | ||
|---|---|---|---|---|
|
eid |
Integer |
The eid number of the G/L Account Category. |
||
|
name |
String |
The name of the G/L Account Category. |
||
|
status |
Query by status of the G/L Account Category. |
|||
Unknown Query Key Information
If you do not know the GL Account Category's eid or name or want to see all GL Account Categories:
| Query to Use | Query for | Returns | ||
|---|---|---|---|---|
|
SimpleDataQuery |
GLAccountCategory |
Complete list of all of your G/L Account Categories. |
||
SOAP Example Query and Response
The following SOAP example is a query of GLAccountCategory:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:query xmlns="http://www.tractbilling.com/billing/1_31/domain" xmlns:ns2="http://www.tractbilling.com/billing/1_31/service">
<ns2:queryRequest>
<simpleDataQuery startIndex="0" size="50">
<type>GLAccountCategory</type>
</simpleDataQuery>
</ns2:queryRequest>
</ns2:query>
</soap:Body>
</soap:Envelope>
This was the response:
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:queryResponse xmlns="http://www.tractbilling.com/billing/1_31/domain" xmlns:ns2="http://www.tractbilling.com/billing/1_31/service">
<ns2:return successful="true">
<glAccountCategories pageNumber="1" pageSize="50" totalElements="16" elementCount="16" totalPages="1">
<glAccountCategory name="Cash" description="Cash Assets" status="ACTIVE" eid="427">
<accountType name="Asset" description="Asset" eid="1"/>
</glAccountCategory>
<glAccountCategory name="Accounts Receivable" description="Accounts Receivable" status="ACTIVE" eid="428">
<accountType name="Asset" description="Asset" eid="1"/>
</glAccountCategory>
<glAccountCategory name="Inventory" description="Inventory Assets" status="ACTIVE" eid="429">
<accountType name="Asset" description="Asset" eid="1"/>
</glAccountCategory>
<glAccountCategory name="Accounts Payable" description="Accounts Payable" status="ACTIVE" eid="430">
<accountType name="Liability" description="Liability" eid="2"/>
</glAccountCategory>
<glAccountCategory name="Taxes Payable" description="Taxes & Regulatory Fees Payable" status="ACTIVE" eid="431">
<accountType name="Liability" description="Liability" eid="2"/>
</glAccountCategory>
<glAccountCategory name="Unearned Revenue" description="Unearned Revenue Liabilities" status="ACTIVE" eid="432">
<accountType name="Liability" description="Liability" eid="2"/>
</glAccountCategory>
<glAccountCategory name="Other Current Liabilities" description="Other Current Liabilities" status="ACTIVE" eid="433">
<accountType name="Liability" description="Liability" eid="2"/>
</glAccountCategory>
<glAccountCategory name="Subscription Revenue" description="Post Pay Subscriber Revenue" status="ACTIVE" eid="434">
<accountType name="Revenue" description="Revenue" eid="4"/>
</glAccountCategory>
<glAccountCategory name="Equipment Revenue" description="Equipment Revenue" status="ACTIVE" eid="435">
<accountType name="Revenue" description="Revenue" eid="4"/>
</glAccountCategory>
<glAccountCategory name="Other Revenue" description="Other Revenue" status="ACTIVE" eid="436">
<accountType name="Revenue" description="Revenue" eid="4"/>
</glAccountCategory>
<glAccountCategory name="Dealer/Agent Commissions" description="Dealer/Agent Commissions" status="ACTIVE" eid="437">
<accountType name="Expense" description="Expense" eid="5"/>
</glAccountCategory>
<glAccountCategory name="Credit & Collections" description="Credit & Collections" status="ACTIVE" eid="438">
<accountType name="Expense" description="Expense" eid="5"/>
</glAccountCategory>
<glAccountCategory name="Taxes" description="Taxes & Licenses" status="ACTIVE" eid="439">
<accountType name="Expense" description="Expense" eid="5"/>
</glAccountCategory>
<glAccountCategory name="Miscellaneous Expense" description="Miscellaneous Expense" status="ACTIVE" eid="440">
<accountType name="Expense" description="Expense" eid="5"/>
</glAccountCategory>
<glAccountCategory name="One-Time Revenues" description="One-Time Revenues" status="ACTIVE" eid="441">
<accountType name="Revenue" description="Revenue" eid="4"/>
</glAccountCategory>
<glAccountCategory name="Revenue" status="ACTIVE" eid="662">
<accountType name="Revenue" description="Revenue" eid="4"/>
</glAccountCategory>
</glAccountCategories>
</ns2:return>
</ns2:queryResponse>
</soap:Body>
</soap:Envelope>
REST Mount Point and Parameters
Query
-
GET https://my.tractbilling.com/t/s/r/1.33/glAccountCategories/<eid>
-
GET https://my.tractbilling.com/t/s/r/1.33/glAccountCategories?eid=<eid>
-
GET https://my.tractbilling.com/t/s/r/1.33/glAccountCategories?name=<name>
-
GET https://my.tractbilling.com/t/s/r/1.33/glAccountCategories?status=<status>