API Catalog

Retrieve GL Departments By Code

01 Oct 2025
2 Minutes to read

Print
Dark
Light

Retrieve GL Departments By Code

Updated on 01 Oct 2025
2 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

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

Security

HTTP

Type basic

Basic authentication

Header parameters

Content-Type

string

Exampleapplication/json

Query parameters

finder

string

ExampleselectDeptCompany;deptCompanyCode=RVC

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleDeptName:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

example-0

Successful Response

{
  "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

{
  "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

What's Next

Retrieve GL document drill downs By Code

Retrieve GL Departments By Code

Query Standards

Finder

Select DeptCompany

By UUID

What's Next

Contact Us