Retrieve JC Job Phases By Code
    • 04 Nov 2025
    • 4 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
    example-0

    Successful Response - Finder - selectJobPhases

    {
      "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"
        }
      ]
    }
    example-1

    Successful Response - Finder - selectJobPhases

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