---
title: "Retrieve GL Departments By Code"
slug: "retrieve-gl-departments-by-code"
updated: 2026-05-26T12:53:14Z
published: 2026-05-26T12:53:48Z
canonical: "developers.cmicglobal.com/retrieve-gl-departments-by-code"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://developers.cmicglobal.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Retrieve GL Departments By Code

Get/glrestapi/rest/v1/rtigenericgldepts

## Query Standards

### Finder

Following row finders are available for data filtering and optimizing request performance.

- Select DeptCompany
- By UUID

#### Select DeptCompany

Recommended finder parameters. Refer to Query Parameters for example.

| Parameter | Description | Sample |
| --- | --- | --- |
| deptCompanyCod | Company Code that the Department belongs to | 001 |

#### By UUID

This is an optional finder for querying a specific Department by row ID.

| Parameter | Description | Sample |
| --- | --- | --- |
| /VUUID | The VUuid attribute is the Unique row ID | /glrestapi/rest/v1/rtigenericgldepts/:AABRgyAAIAALJRGAAJ |

SecurityHTTPType basic

Basic authentication

Header parametersContent-TypestringExampleapplication/json

Query parametersfinderstringExampleselectDeptCompany;deptCompanyCode=RVC
limitintegerExample500
offsetintegerExample0
totalResultsbooleanExampletrue
orderBystringExampleDeptName:desc

Responses200

OK

HeadersContent-TypestringExampleapplication/vnd.oracle.adf.resourcecollection+json
<select class='api-response-data' aria-label='Media type'><option value='e154d37a-d21f-4ab3-a13c-e99a765f58e1'>application/json</option>
</select><select class='select-example' aria-label='Media type'><option value='9151c3c6-d41b-46b5-8c9c-b7f2183833cb'>example-0</option>
<option value='0e0bc339-44f3-4b20-995e-d0298c17ca78'>example-1</option>
</select>example-0

Successful Response

```json
{
  "items": [
    {
      "DeptActiveFlag": "Y",
      "DeptAdd1": null,
      "DeptAdd2": null,
      "DeptAdd3": null,
      "DeptAddrCode": null,
      "DeptAddrCompCode": null,
      "DeptApTax1Code": null,
      "DeptApTax2Code": null,
      "DeptApTax3Code": null,
      "DeptAreaCode": null,
      "DeptBalanceFlag": "N",
      "DeptBillingRateCode": null,
      "DeptBuCode": "00",
      "DeptBuName": "Non Business",
      "DeptCkDigitCode": null,
      "DeptCloseYr": 2009,
      "DeptCode": "00",
      "DeptCompCode": "RVC",
      "DeptConschartCode": "RVCHART",
      "DeptCountry": null,
      "DeptCountryCode": null,
      "DeptCtrlCode": null,
      "DeptCtrlName": null,
      "DeptFaxAreaCode": null,
      "DeptFaxCountryCode": null,
      "DeptFaxNum": null,
      "DeptFedTax1Code": null,
      "DeptFedTax2Code": null,
      "DeptHier": "RVC     00    ",
      "DeptIbRevAccCode": "1000.175",
      "DeptIncomeCloseAccCode": "3000.100",
      "DeptIncomeCloseDeptCode": "00",
      "DeptInterClearAccCode": "1000.100",
      "DeptJbAltCompAddCode": null,
      "DeptJbAltRemitAddCode": null,
      "DeptName": "Company Level",
      "DeptPer": 3,
      "DeptPhoneNum": null,
      "DeptPostalCode": null,
      "DeptRecalSalChrgrateFlag": "Y",
      "DeptRegionCode": null,
      "DeptRegionName": null,
      "DeptRowid": "AAAsOtAAGAACCsTAAP",
      "DeptTax1Code": null,
      "DeptTax1IncinvFlag": null,
      "DeptTax2Code": null,
      "DeptTax2IncinvFlag": null,
      "DeptTax3Code": null,
      "DeptTax3IncinvFlag": null,
      "DeptTax4Code": null,
      "DeptTax4IncinvFlag": null,
      "DeptTax5Code": null,
      "DeptTax5IncinvFlag": null,
      "DeptTaxCode": null,
      "DeptWcbCode": null,
      "DeptYr": 2024,
      "DeptIuCreateDate": "2010-12-06T16:08:56Z",
      "DeptIuUpdateDate": "2024-02-15T19:24:17Z",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAP",
          "name": "rtigenericgldepts",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAP",
          "name": "rtigenericgldepts",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 1,
  "count": 1,
  "hasMore": false,
  "limit": 1,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts",
      "name": "rtigenericgldepts",
      "kind": "collection"
    }
  ]
}
```

example-1

Successful Response

```json
{
  "items": [
    {
      "DeptActiveFlag": "Y",
      "DeptAdd1": null,
      "DeptAdd2": null,
      "DeptAdd3": null,
      "DeptAddrCode": null,
      "DeptAddrCompCode": null,
      "DeptApTax1Code": null,
      "DeptApTax2Code": null,
      "DeptApTax3Code": null,
      "DeptAreaCode": "434",
      "DeptBalanceFlag": "N",
      "DeptBillingRateCode": null,
      "DeptBuCode": "55",
      "DeptBuName": "Public Sector",
      "DeptCkDigitCode": null,
      "DeptCloseYr": 2019,
      "DeptCode": "40",
      "DeptCompCode": "ZZ",
      "DeptConschartCode": "ZZCHART",
      "DeptCountry": null,
      "DeptCountryCode": null,
      "DeptCtrlCode": "00",
      "DeptCtrlName": "Company Level33333",
      "DeptFaxAreaCode": null,
      "DeptFaxCountryCode": null,
      "DeptFaxNum": null,
      "DeptFedTax1Code": null,
      "DeptFedTax2Code": null,
      "DeptHier": "ZZ      40    ",
      "DeptIbRevAccCode": null,
      "DeptIncomeCloseAccCode": "3000.100",
      "DeptIncomeCloseDeptCode": "00",
      "DeptInterClearAccCode": null,
      "DeptJbAltCompAddCode": null,
      "DeptJbAltRemitAddCode": null,
      "DeptName": "Equipment Maintenace",
      "DeptPer": 2,
      "DeptPhoneNum": "830-3788",
      "DeptPostalCode": null,
      "DeptRecalSalChrgrateFlag": "Y",
      "DeptRegionCode": "CA",
      "DeptRegionName": "California",
      "DeptRowid": "AAAsOtAAGAACCsVAAA",
      "DeptTax1Code": null,
      "DeptTax1IncinvFlag": null,
      "DeptTax2Code": null,
      "DeptTax2IncinvFlag": null,
      "DeptTax3Code": null,
      "DeptTax3IncinvFlag": null,
      "DeptTax4Code": null,
      "DeptTax4IncinvFlag": null,
      "DeptTax5Code": null,
      "DeptTax5IncinvFlag": null,
      "DeptTaxCode": null,
      "DeptWcbCode": null,
      "DeptYr": 2024,
      "DeptIuCreateDate": null,
      "DeptIuUpdateDate": "2024-02-07T13:59:11Z",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsVAAA",
          "name": "rtigenericgldepts",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsVAAA",
          "name": "rtigenericgldepts",
          "kind": "item"
        }
      ]
    },
    {
      "DeptActiveFlag": "Y",
      "DeptAdd1": "test",
      "DeptAdd2": null,
      "DeptAdd3": null,
      "DeptAddrCode": "ADD1",
      "DeptAddrCompCode": null,
      "DeptApTax1Code": null,
      "DeptApTax2Code": null,
      "DeptApTax3Code": null,
      "DeptAreaCode": null,
      "DeptBalanceFlag": "Y",
      "DeptBillingRateCode": null,
      "DeptBuCode": "55",
      "DeptBuName": "Public Sector",
      "DeptCkDigitCode": null,
      "DeptCloseYr": 2019,
      "DeptCode": "123456",
      "DeptCompCode": "ZZ",
      "DeptConschartCode": "ZZCHART",
      "DeptCountry": "usa",
      "DeptCountryCode": null,
      "DeptCtrlCode": "00",
      "DeptCtrlName": "Company Level33333",
      "DeptFaxAreaCode": null,
      "DeptFaxCountryCode": null,
      "DeptFaxNum": null,
      "DeptFedTax1Code": null,
      "DeptFedTax2Code": null,
      "DeptHier": "ZZ      123456",
      "DeptIbRevAccCode": null,
      "DeptIncomeCloseAccCode": "3000.100",
      "DeptIncomeCloseDeptCode": "00",
      "DeptInterClearAccCode": "6003.104",
      "DeptJbAltCompAddCode": null,
      "DeptJbAltRemitAddCode": null,
      "DeptName": "6 digit",
      "DeptPer": 12,
      "DeptPhoneNum": null,
      "DeptPostalCode": "233121",
      "DeptRecalSalChrgrateFlag": "N",
      "DeptRegionCode": "FL",
      "DeptRegionName": "Florida",
      "DeptRowid": "AAAsOtAAGAACCsTAAc",
      "DeptTax1Code": null,
      "DeptTax1IncinvFlag": null,
      "DeptTax2Code": null,
      "DeptTax2IncinvFlag": null,
      "DeptTax3Code": null,
      "DeptTax3IncinvFlag": null,
      "DeptTax4Code": null,
      "DeptTax4IncinvFlag": null,
      "DeptTax5Code": null,
      "DeptTax5IncinvFlag": null,
      "DeptTaxCode": null,
      "DeptWcbCode": null,
      "DeptYr": 2020,
      "DeptIuCreateDate": "2011-07-28T15:42:30Z",
      "DeptIuUpdateDate": "2025-05-16T16:23:26Z",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAc",
          "name": "rtigenericgldepts",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts/AAAsOtAAGAACCsTAAc",
          "name": "rtigenericgldepts",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 38,
  "count": 2,
  "hasMore": true,
  "limit": 2,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://localhost:7101/gl-rest-api/rest/v1/rtigenericgldepts",
      "name": "rtigenericgldepts",
      "kind": "collection"
    }
  ]
}
```

object