> ## 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 > ## 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 | ## OpenAPI ````json GET /glrestapi/rest/v1/rtigenericgldepts { "openapi": "3.0.0", "info": { "title": "API Catalog", "description": "", "version": "1.0.0" }, "servers": [ { "url": "https://mobtest.cmiccloudr12.com/cmictestrti", "description": "CMIC API Server" } ], "security": [ { "cmicBasicAuth": [] } ], "tags": [ { "name": "Highlights" }, { "name": "Asset Management | Equipment" }, { "name": "Asset Management | Fixed Assets" }, { "name": "Asset Management | Purchase Order" }, { "name": "Asset Management | Inventory" }, { "name": "Asset Management | Requisition" }, { "name": "Asset Management | Purchase Change Order" }, { "name": "Bim Model" }, { "name": "Bim Model Revision" }, { "name": "Bim Tag Model" }, { "name": "Bim Tags" }, { "name": "Bim FileUpload Jersey" }, { "name": "Core System | Business Partners" }, { "name": "Core System | Business Partner Addresses" }, { "name": "Core System | Bank" }, { "name": "Core System | Currency" }, { "name": "Core System | Exchange Rates" }, { "name": "Core System | Global Table Text Codes" }, { "name": "Core System | Global Table Regions" }, { "name": "Core System | Terms" }, { "name": "Core System | System Contact" }, { "name": "Core System | Weight Measures" }, { "name": "Core System | Field User Defined Classifiers" }, { "name": "Core System | User Defined Classifiers by Object" }, { "name": "Core System | User Extension Definitions by Object" }, { "name": "Core System | User Extention Field Data Value" }, { "name": "Core System | User Extension Values by Object" }, { "name": "Core System | User System Role" }, { "name": "Core System | User Project Role" }, { "name": "Core System | Documents by Object" }, { "name": "Core System | Audit Status Log by Object" }, { "name": "Core System | Licensed Users" }, { "name": "Core System | Company Access" }, { "name": "Core System | Copy User Settings" }, { "name": "Core System | User Maintenance" }, { "name": "Core System | User Roles" }, { "name": "Core System | Security Groups" }, { "name": "Core System | Job/Project Security" }, { "name": "Core System | Weight Measure with Conversions Code" }, { "name": "Core System | Weight Measure Conversions Code" }, { "name": "Core System | User-defined-fields" }, { "name": "Core System | User-extension" }, { "name": "ECM and Workflow | Image Manager" }, { "name": "Financials | General Ledger" }, { "name": "Financials | Accounts Payable" }, { "name": "Financials | Accounts Receivable" }, { "name": "Preventative Maintenance | Issue Work Orders" }, { "name": "Preventative Maintenance | Issue Work Items" }, { "name": "Preventative Maintenance | Issue Work Budgets" }, { "name": "Preventative Maintenance | Issue Priorities" }, { "name": "Preventative Maintenance | Issue Status" }, { "name": "Preventative Maintenance | Issue Types" }, { "name": "Preventative Maintenance | Accumulative Equipment" }, { "name": "Preventative Maintenance | Work Orders" }, { "name": "Preventative Maintenance | Work Items" }, { "name": "Preventative Maintenance | Work Budgets" }, { "name": "Preventative Maintenance | Priorities" }, { "name": "Preventative Maintenance | Tasks" }, { "name": "HCM | UKG Pay Deductions" }, { "name": "HCM | UKG Pay Earnings" }, { "name": "HCM | UKG Pay Headers" }, { "name": "HCM | UKG Pay Taxes" }, { "name": "HCM | Payroll Geographical States" }, { "name": "HCM | Payroll Trades" }, { "name": "HCM | Payroll Union" }, { "name": "HCM | Payroll Pay Runs" }, { "name": "HCM | Payroll Pay Groups" }, { "name": "HCM | Payroll Tax" }, { "name": "HCM | Payroll Worker Compensation" }, { "name": "HCM | Payroll Work Locations" }, { "name": "HCM | Payroll Trade Pay Rates" }, { "name": "HCM | Payroll Union Pay Rates" }, { "name": "HCM | Payroll Job Pay Rates" }, { "name": "HCM | Payroll Master Benefits" }, { "name": "HCM | Payroll Master Deductions" }, { "name": "HCM | Payroll Ben/Ded/Leave Base Codes" }, { "name": "HCM | Payroll Ben/Ded Plans" }, { "name": "HCM | Payroll Ben/Ded Plan Options" }, { "name": "HCM | Payroll Company Benefits" }, { "name": "HCM | Payroll Company Deductions" }, { "name": "HCM | Payroll Vertex Geographic Locations" }, { "name": "HCM | Payroll Checks" }, { "name": "HCM | Payroll Timesheets" }, { "name": "HCM | Employee" }, { "name": "HCM | Employee (Minimum payload)" }, { "name": "HCM | Employee History" }, { "name": "HCM | Tax Exemptions" }, { "name": "HCM | Employee Tax Overrides" }, { "name": "HCM | Employee Pay Splits" }, { "name": "HCM | Employee Benefits" }, { "name": "HCM | Employee Clock In and Out" }, { "name": "HCM | Employee Deductions" }, { "name": "HCM | Employee Leaves" }, { "name": "HCM | Employee Leave History" }, { "name": "HCM | Employee Hour Types" }, { "name": "HCM | Employee Pay History" }, { "name": "HCM | Employee Work Statuses" }, { "name": "HCM | Employee Security Group" }, { "name": "HCM | Crewtime Crew" }, { "name": "HCM | Crewtime Employee Timesheet" }, { "name": "HCM | Crewtime Equipment Timesheet" }, { "name": "HCM | Crew Maintenance Activity Assignment" }, { "name": "HCM | Crew Maintenance Member Assignment" }, { "name": "HCM | Crew Maintenance Member Trade and Union Assignment" }, { "name": "HCM | Crew Maintenance Equipment Assignment" }, { "name": "HCM | Crew Maintenance Equipment Detail Assignment" }, { "name": "HCM | HR Requisitions" }, { "name": "HCM | HR Relations" }, { "name": "HCM | HR Employee Skills" }, { "name": "HCM | HR Incident" }, { "name": "HCM | HR Employee Relatives / Dependents" }, { "name": "HCM | HR Employee Positions" }, { "name": "HCM | HR Applicants" }, { "name": "HCM | HR Applications" }, { "name": "HCM | Vertex Location City" }, { "name": "HCM | HR Application History" }, { "name": "HCM | HR Dependent Benefits" }, { "name": "HCM | HR Dependent Deductions" }, { "name": "HCM | HR Employee Elected Plans" }, { "name": "HCM | HR Employee Training Certifications" }, { "name": "HCM | HR Trainings" }, { "name": "HCM | E-Timesheets" }, { "name": "HCM | System Contacts" }, { "name": "HCM | System User Payroll Security Group" }, { "name": "HCM | Payroll Timesheet Posting" }, { "name": "HCM | CrewTimesheet Posting" }, { "name": "HCM | HR Positions Master" }, { "name": "HCM | Payroll Pay Periods" }, { "name": "HCM | Payroll Rate Codes" }, { "name": "HCM | Payroll Overhead Codes and Rates" }, { "name": "HCM | Payroll Assigned Overhead to Jobs" }, { "name": "Materials Management | Material Sale Orders" }, { "name": "Materials Management | Material Sale Orders Details" }, { "name": "Materials Management | Truck Rate Detail" }, { "name": "Opportunity Management | Competitors" }, { "name": "Opportunity Management | Opportunities" }, { "name": "Opportunity Management | Revenue Details" }, { "name": "Opportunity Management | Opportunity History" }, { "name": "Opportunity Management | Organization" }, { "name": "Project Controls | Job Billing" }, { "name": "Project Controls | Job Cost" }, { "name": "Project Controls | PCI Details" }, { "name": "Project Controls | Unposted PCI Details" }, { "name": "Project Controls | PCI Headers" }, { "name": "Project Controls | Owner Change Orders" }, { "name": "Project Controls | CM Statuses" }, { "name": "Project Controls | CM Types" }, { "name": "Project Controls | CM Vendor Details" }, { "name": "Project Controls | Post PCI" }, { "name": "Project Management | Uploading Documents" }, { "name": "Project Management | Downloading Documents" }, { "name": "Project Management | Foreign Bid Item Imports" }, { "name": "Project Management | Communications" }, { "name": "Project Management | Daily Journals" }, { "name": "Project Management | Communications Types" }, { "name": "Project Management | Daily Journal Daily Work Plans" }, { "name": "Project Management | Daily Journal Field Forces" }, { "name": "Project Management | Daily Journal Labour" }, { "name": "Project Management | Daily Journal Materials" }, { "name": "Project Management | Daily Journal Owner Equipment" }, { "name": "Project Management | Daily Journal Quality Control" }, { "name": "Project Management | Daily Journal Tasks" }, { "name": "Project Management | Daily Journal Trade Equipment" }, { "name": "Project Management | Daily Journal Transactions" }, { "name": "Project Management | Daily Journal User Defined Data" }, { "name": "Project Management | Daily Journal Visitors" }, { "name": "Project Management | Daily Journal Bill Details" }, { "name": "Project Management | Field Work Directives" }, { "name": "Project Management | Contract Types" }, { "name": "Project Management | Company Contacts" }, { "name": "Project Management | Distribution BCC" }, { "name": "Project Management | Distribution CC" }, { "name": "Project Management | Field Work Directive Statuses" }, { "name": "Project Management | Issues" }, { "name": "Project Management | Key Players" }, { "name": "Project Management | Meetings" }, { "name": "Project Management | Meeting Attendees" }, { "name": "Project Management | Meeting Item Statuses" }, { "name": "Project Management | Meeting Tracks" }, { "name": "Project Management | Notes" }, { "name": "Project Management | Projects" }, { "name": "Project Management | Project Items" }, { "name": "Project Management | Project Item Phase Segment Sums" }, { "name": "Project Management | Project Partners" }, { "name": "Project Management | Notices" }, { "name": "Project Management | Notice Statuses" }, { "name": "Project Management | Owner JS Query" }, { "name": "Project Management | PCI Real Locations" }, { "name": "Project Management | Project Contacts" }, { "name": "Project Management | RFIs (Requests for Information)" }, { "name": "Project Management | RFI Statuses" }, { "name": "Project Management | Submittal Packages" }, { "name": "Project Management | Submittal Package Details" }, { "name": "Project Management | Submittal Package Status" }, { "name": "Project Management | Submittals" }, { "name": "Project Management | Submittal Status" }, { "name": "Project Management | Transmittals" }, { "name": "Project Management | Subcontract Headers" }, { "name": "Project Management | Subcontract Schedules" }, { "name": "Project Management | Subcontract Sechedule Phase Segment Sums" }, { "name": "Project Management | User Roles" }, { "name": "Project Management | Punchlists" }, { "name": "Project Management | Punchlist Details" }, { "name": "Project Management | Punchlist Statuses" }, { "name": "Project Management | Meeting Items" }, { "name": "Project Management | Self Perform Vendor" }, { "name": "Project Management | Submittal Types" }, { "name": "Project Management | Assign contact and partner to project" }, { "name": "Project Management | Subcontract Prequal" }, { "name": "Project Management | Bid Item Package" } ], "paths": { "/glrestapi/rest/v1/rtigenericgldepts": { "get": { "tags": [ "Financials | General Ledger" ], "summary": "Retrieve GL Departments By Code", "description": "## Query Standards\n\n\n### Finder\n\nFollowing row finders are available for data filtering and optimizing request performance.\n\n- Select DeptCompany\n- By UUID\n \n\n#### Select DeptCompany\n\nRecommended finder parameters. Refer to Query Parameters for example.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| deptCompanyCod | Company Code that the Department belongs to | 001 |\n\n#### By UUID\n\nThis is an optional finder for querying a specific Department by row ID.\n\n| Parameter | Description | Sample |\n| --- | --- | --- |\n| /VUUID | The VUuid attribute is the Unique row ID | /glrestapi/rest/v1/rtigenericgldepts/:AABRgyAAIAALJRGAAJ |", "parameters": [ { "name": "Content-Type", "in": "header", "schema": { "type": "string" }, "example": "application/json" }, { "name": "finder", "in": "query", "schema": { "type": "string" }, "example": "selectDeptCompany;deptCompanyCode=RVC" }, { "name": "limit", "in": "query", "schema": { "type": "integer" }, "example": "500" }, { "name": "offset", "in": "query", "schema": { "type": "integer" }, "example": "0" }, { "name": "totalResults", "in": "query", "schema": { "type": "boolean" }, "example": "true" }, { "name": "orderBy", "in": "query", "schema": { "type": "string" }, "example": "DeptName:desc" } ], "responses": { "200": { "description": "OK", "headers": { "Content-Type": { "schema": { "type": "string", "example": "application/vnd.oracle.adf.resourcecollection+json" } } }, "content": { "application/json": { "schema": { "type": "object" }, "examples": { "example-0": { "summary": "Successful Response", "value": { "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:56+00:00", "DeptIuUpdateDate": "2024-02-15T19:24:17+00:00", "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": { "summary": "Successful Response", "value": { "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:11+00:00", "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:30+00:00", "DeptIuUpdateDate": "2025-05-16T16:23:26+00:00", "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" } ] } } } } } } } } } }, "components": { "securitySchemes": { "cmicBasicAuth": { "type": "http", "scheme": "basic", "description": "Basic authentication" } } } } ````