Retrieve Master Categories By Code
  • 06 Jan 2025
  • 2 Minutes to read
  • Dark
    Light

Retrieve Master Categories By Code

  • Dark
    Light

Article summary

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.

ParameterDescriptionSample
compCodeCompany Code001
categoryCodeCategory CodeO
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

OK

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-21T13:00:25Z",
      "CatIuUpdateDate": "2020-08-20T17: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-11T17:25:07Z",
      "CatIuUpdateDate": "2020-08-20T17: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-21T13:00:25Z",
      "CatIuUpdateDate": "2020-08-20T17: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