Retrieve JC Job Phases By Code
  • 04 Nov 2025
  • 3 Minutes to read
  • Dark
    Light

Retrieve JC Job Phases By Code

  • Dark
    Light

Article summary

Get
/jc-rest-api/rest/1/jcjobcostcodes

Overview

Cost codes are used in combination with categories (categories of cost types) to specify a job’s cost elements. For example, a cost code for electrical work can have categories for materials, labor, and equipment associated to the cost code to allow specification of the cost code’s type of cost. The JCJobCostCodes endpoint allows the create, update and query of cost codes under a specified company and job combination.

Notes

UI Navigation

Project Controls > Job Costing > Job > Assigned Cost Codes

Reference Article

Job Costing – Assign Cost Codes (Phases)

Job Costing – Enter Cost Codes

Path Parameters

ParameterDescriptionExample
/VUUIDThe VUuid attribute is the Unique row IDE731F2DF0435AED6E053B08610AC219A

Query Standards

KeyRecommendedDescription
finderYesFilters data based on attributes. See finder details below. Finders can be combined using a comma delimiter between parameters that implies an "and" statement. For more information on using the finder functionality please see Best PracticeData Filtering requirements
limitYesA limit restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count, then the framework will return all available resources. For additional information on using the limit functionality please visit Best PracticeData Filtering requirements
offsetYesThe offset skips a specified number of items in a data list before it starts showing results. For example, if you set an offset of 10, it skips the first 10 items and begins showing from the 11th item. For additional information on using Offset functionality please visit Best PracticeData Filtering requirements
orderByYesThe orderBy attribute retrieves rows using an order ensuring the response payload displays data in the order supplied in the URL parameter using the GET method. For more information on using orderBy functionality please visit Best PracticeData Filtering requirements

jcjobcostcodes Finders

FinderParameterData TypeData LengthDescriptionExample
PrimaryKeyGjjpVUuidstring64This finder parameter queries a single cost code record by Vuuid./jc-rest-api/rest/1/jcjobcostcodes?finder=PrimaryKey;GjjpVUuid=E731F2DF042AAED6E053B08610AC219A
selectJobPhasesauditDatedatetimeThis finder parameter queries cost codes based on the combined uICreate and uIUpdate dates. Supplying a date will return all records created or updated after that date, making it useful for retrieving only changes since the last invoice data pull. Can be combined with optional parameters ‘compCode’, ‘jobCode’ and ‘phaseCode’/jc-rest-api/rest/1/jcjobcostcodes?finder=selectJobPhases;auditDate=2015-05-04
selectJobPhasescompCodestring8This finder parameter queries cost codes by Company Code. Can be combined with optional parameters ‘auditDate’, ‘jobCode’ and ‘phaseCode’/jc-rest-api/rest/1/jcjobcostcodes?finder=selectJobPhases;compCode=001
selectJobPhasesjobCodestring10This finder parameter queries cost codes by Job Code. Can be combined with optional parameters ‘compCode’, ‘auditDate’ and ‘phaseCode’./jc-rest-api/rest/1/jcjobcostcodes?finder=selectJobPhases;jobCode=000001
selectJobPhasesphaseCodestring16This finder parameter queries cost codes by Cost Code. Can be combined with optional parameters ‘compCode’, ‘auditDate’ and ‘jobCode’./jc-rest-api/rest/1/jcjobcostcodes?finder=selectJobPhases;phaseCode=00
Security
HTTP
Type basic

Basic authentication

Query parameters
finder
string
ExampleselectJobPhases;jobCode=00100, phaseCode=00015, compCode=001, auditDate=2016-01-01
limit
integer
Example500
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleGjjpVUuid:desc
Responses
200

OK

Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
  "items": [
    {
      "GjjpActComplDate": null,
      "GjjpActStartDate": null,
      "GjjpActiveFlag": "Y",
      "GjjpAttachOraseq": 829398435,
      "GjjpBillCode": null,
      "GjjpBillName": null,
      "GjjpBillingRateTableCode": null,
      "GjjpBillingTypeCode": null,
      "GjjpBillingUnitFlag": "Y",
      "GjjpBudgUnit": null,
      "GjjpChgOrdUnit": null,
      "GjjpClvValueCode1": null,
      "GjjpClvValueCode2": null,
      "GjjpClvValueCode3": null,
      "GjjpClvValueCode4": null,
      "GjjpClvValueCode5": null,
      "GjjpClvValueCode6": null,
      "GjjpCode": "00015",
      "GjjpCompCode": "001",
      "GjjpComplUnit": null,
      "GjjpCreateDate": "2022-10-20T18:26:03Z",
      "GjjpCtrlCode": "00",
      "GjjpEbudgCostAmt": null,
      "GjjpEbudgRevenueAmt": null,
      "GjjpEqpOraseq": null,
      "GjjpEstComplDate": null,
      "GjjpEstStartDate": null,
      "GjjpFactor": null,
      "GjjpFactorableFlg": "N",
      "GjjpFinalProductFlag": null,
      "GjjpHbRecAmt": null,
      "GjjpHier": "001     00100     00              00015           ",
      "GjjpInvoiceFormatCode": null,
      "GjjpItemCode": null,
      "GjjpItemCompCode": null,
      "GjjpItemTypeCode": null,
      "GjjpIuCreateDate": "2022-10-20T18:26:03Z",
      "GjjpIuUpdateDate": "2023-01-25T04:35:30Z",
      "GjjpJobCode": "00100",
      "GjjpJobCtrlCode": "ALL",
      "GjjpMaxBillingAmt": null,
      "GjjpMaxBillingBudgetAmt": null,
      "GjjpName": "Drawings",
      "GjjpObudgCostAmt": null,
      "GjjpObudgRevenueAmt": null,
      "GjjpObudgUnit": 0,
      "GjjpPhsTypeCode": null,
      "GjjpPriorComplUnit": null,
      "GjjpProjQty": null,
      "GjjpProjThresholdPct": null,
      "GjjpQraOverrideIndicator": null,
      "GjjpRecAmt": null,
      "GjjpSingleCatBudgFlag": null,
      "GjjpStatusCode": "P",
      "GjjpStoreFcastApprovedFlg": "N",
      "GjjpUeValidFlag": "Y",
      "GjjpUnitFcastAttachOraseq": 829398436,
      "GjjpUserEnteredProjQty": null,
      "GjjpWmCode": "LS",
      "GjjpVUuid": "EB75B7A51AA77F0AE05316821FAC1C51",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjobcostcodes/EB75B7A51AA77F0AE05316821FAC1C51",
          "name": "jcjobcostcodes",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjobcostcodes/EB75B7A51AA77F0AE05316821FAC1C51",
          "name": "jcjobcostcodes",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 1,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcjobcostcodes",
      "name": "jcjobcostcodes",
      "kind": "collection"
    }
  ]
}
object