Retrieve Master Categories By Code

Updated on 25 Sep 2024
2 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/jc-rest-api/rest/1/jcmastercategories

Query Standards

Finder

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

Select Category
By UUID

Select Category

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
compCode	Company Code	001
categoryCode	Category Code	O

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectCategory;compCode=001, categoryCode=O

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleCatName:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "CatActiveFlag": "Y",
      "CatAvailableOnScFlag": "B",
      "CatBillAccCode": "40001",
      "CatBillGroupCode": null,
      "CatBillingFlag": "Y",
      "CatBudgetFlag": "Y",
      "CatCcAccCode": "16010",
      "CatCode": "O",
      "CatCompCode": "001",
      "CatCostFlag": "Y",
      "CatCostRollupCatCode": null,
      "CatCostTypeCode": null,
      "CatCtrlCode": "ALL",
      "CatDefaultBillingType": null,
      "CatDefaultBudmethCode": "A",
      "CatDefaultInvFormatCode": null,
      "CatEtimeFlag": "N",
      "CatExclCostBudgWip": "N",
      "CatExclCostWip": "N",
      "CatFwdLossOvrhPct": null,
      "CatHier": "001     O               ",
      "CatIbAlternateWipAccCode": null,
      "CatInclInForecastFlag": "Y",
      "CatIuCreateDate": "2015-04-21T01:00:25Z",
      "CatIuUpdateDate": "2020-08-20T05:47:30Z",
      "CatJbBackupCatColumnNum": 4,
      "CatJcsCostType": null,
      "CatLabourForecastFlag": "N",
      "CatLbcAccCode": null,
      "CatLtcAccCode": "21010",
      "CatName": "Other",
      "CatNonRecoverableFlag": "N",
      "CatProcurementFlag": "Y",
      "CatRate": null,
      "CatReserveRevAccCode": "41011",
      "CatUnbilledRevAccCode": "41009",
      "CatWbsvCode1": null,
      "CatWbsvCode2": null,
      "CatWbsvCode3": null,
      "CatWbsvCode4": null,
      "CatWbsvEditableFlag1": "Y",
      "CatWbsvEditableFlag2": "Y",
      "CatWbsvEditableFlag3": "Y",
      "CatWbsvEditableFlag4": "N",
      "CatWbsvRequiredFlag1": "N",
      "CatWbsvRequiredFlag2": "N",
      "CatWbsvRequiredFlag3": "N",
      "CatWbsvRequiredFlag4": "N",
      "CatWipAccCode": "51050",
      "CatWmCode": "$",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000014F00000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000014F00000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        }
      ]
    },
    {
      "CatActiveFlag": "Y",
      "CatAvailableOnScFlag": "B",
      "CatBillAccCode": "40030",
      "CatBillGroupCode": null,
      "CatBillingFlag": "Y",
      "CatBudgetFlag": "Y",
      "CatCcAccCode": "16010",
      "CatCode": "OEQ",
      "CatCompCode": "001",
      "CatCostFlag": "Y",
      "CatCostRollupCatCode": null,
      "CatCostTypeCode": null,
      "CatCtrlCode": "E",
      "CatDefaultBillingType": null,
      "CatDefaultBudmethCode": "A",
      "CatDefaultInvFormatCode": null,
      "CatEtimeFlag": "N",
      "CatExclCostBudgWip": "N",
      "CatExclCostWip": "N",
      "CatFwdLossOvrhPct": null,
      "CatHier": "001     E               OEQ             ",
      "CatIbAlternateWipAccCode": null,
      "CatInclInForecastFlag": "Y",
      "CatIuCreateDate": "2015-05-11T05:25:07Z",
      "CatIuUpdateDate": "2020-08-20T05:47:30Z",
      "CatJbBackupCatColumnNum": null,
      "CatJcsCostType": null,
      "CatLabourForecastFlag": "N",
      "CatLbcAccCode": "9999",
      "CatLtcAccCode": "21010",
      "CatName": "Owned Equipment",
      "CatNonRecoverableFlag": "N",
      "CatProcurementFlag": "Y",
      "CatRate": null,
      "CatReserveRevAccCode": "41011",
      "CatUnbilledRevAccCode": "41009",
      "CatWbsvCode1": null,
      "CatWbsvCode2": null,
      "CatWbsvCode3": null,
      "CatWbsvCode4": null,
      "CatWbsvEditableFlag1": "Y",
      "CatWbsvEditableFlag2": "Y",
      "CatWbsvEditableFlag3": "Y",
      "CatWbsvEditableFlag4": "N",
      "CatWbsvRequiredFlag1": "N",
      "CatWbsvRequiredFlag2": "N",
      "CatWbsvRequiredFlag3": "N",
      "CatWbsvRequiredFlag4": "N",
      "CatWipAccCode": "50040",
      "CatWmCode": "HR",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000034F455100000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000034F455100000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        }
      ]
    },
    {
      "CatActiveFlag": "Y",
      "CatAvailableOnScFlag": "B",
      "CatBillAccCode": "40001",
      "CatBillGroupCode": null,
      "CatBillingFlag": "Y",
      "CatBudgetFlag": "Y",
      "CatCcAccCode": "16010",
      "CatCode": "OH",
      "CatCompCode": "001",
      "CatCostFlag": "Y",
      "CatCostRollupCatCode": null,
      "CatCostTypeCode": null,
      "CatCtrlCode": "ALL",
      "CatDefaultBillingType": null,
      "CatDefaultBudmethCode": "A",
      "CatDefaultInvFormatCode": null,
      "CatEtimeFlag": "N",
      "CatExclCostBudgWip": "N",
      "CatExclCostWip": "N",
      "CatFwdLossOvrhPct": null,
      "CatHier": "001     OH              ",
      "CatIbAlternateWipAccCode": null,
      "CatInclInForecastFlag": "Y",
      "CatIuCreateDate": "2015-04-21T01:00:25Z",
      "CatIuUpdateDate": "2020-08-20T05:47:30Z",
      "CatJbBackupCatColumnNum": 1,
      "CatJcsCostType": null,
      "CatLabourForecastFlag": "N",
      "CatLbcAccCode": "9999",
      "CatLtcAccCode": "21010",
      "CatName": "Overhead",
      "CatNonRecoverableFlag": "N",
      "CatProcurementFlag": "Y",
      "CatRate": null,
      "CatReserveRevAccCode": "41011",
      "CatUnbilledRevAccCode": "41009",
      "CatWbsvCode1": null,
      "CatWbsvCode2": null,
      "CatWbsvCode3": null,
      "CatWbsvCode4": null,
      "CatWbsvEditableFlag1": "Y",
      "CatWbsvEditableFlag2": "Y",
      "CatWbsvEditableFlag3": "Y",
      "CatWbsvEditableFlag4": "N",
      "CatWbsvRequiredFlag1": "N",
      "CatWbsvRequiredFlag2": "N",
      "CatWbsvRequiredFlag3": "N",
      "CatWbsvRequiredFlag4": "N",
      "CatWipAccCode": "51060",
      "CatWmCode": "$",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000024F4800000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories/0002000000024F4800000003303031",
          "name": "jcmastercategories",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 3,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/jc-rest-api/rest/1/jcmastercategories",
      "name": "jcmastercategories",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create a JC Job Master Phase/Cost Code

Retrieve Master Categories By Code

Query Standards

Finder

Select Category

What's Next

Contact Us