Retrieve Inventory Classes By Code

19 Jun 2024
2 Minutes to read

Print
Dark
Light

Retrieve Inventory Classes By Code

Updated on 19 Jun 2024
2 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/ci-rest-api/rest/1/ciclass

Query Standards

Finder

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

Select by Date
By UUID

Select by Date

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
AuditDate	Create or update date time filter	2022-12-20

By UUID

This is an optional finder for querying a specific Inventory Classe by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/ci-rest-api/rest/1/ciclass/D2B734260E2A3E82E05316821FAC9629

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectByDate;AuditDate=2016-12-24

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleCiclasVUuid:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "CiclasAccumDeprAccCode": null,
      "CiclasAccumDeprAccName": null,
      "CiclasAdjAccCode": "50710",
      "CiclasAdjAccName": "Inventory Adj - Cost Update",
      "CiclasAffilRevAccCode": "40015",
      "CiclasAffilRevAccName": "Inventory Revenue",
      "CiclasAllowNegQtyFlag": "Y",
      "CiclasAutoBuildCmpFlag": "N",
      "CiclasBbPriceOrPctCode": "C",
      "CiclasClassCode": "PROD",
      "CiclasClassName": "Production Items",
      "CiclasCmpFlag": "N",
      "CiclasCompCode": "001",
      "CiclasCompName": "CMiC Construction Inc",
      "CiclasCostMethCode": "AVG",
      "CiclasCostUpdateLevelCode": "I",
      "CiclasCreditJcCatCode": "PROD",
      "CiclasCreditJcCatName": "Production Cost",
      "CiclasCtrlClassCode": null,
      "CiclasCtrlClassName": null,
      "CiclasCustRevAccCode": "40015",
      "CiclasCustRevAccName": "Inventory Revenue",
      "CiclasDefaultLocCode": null,
      "CiclasDefaultLocName": null,
      "CiclasDeprExpAccCode": null,
      "CiclasDeprExpAccName": null,
      "CiclasEmCostComponCode": null,
      "CiclasEmCostComponName": null,
      "CiclasHier": "001      .PROD .",
      "CiclasInvAccCode": "17010",
      "CiclasInvAccName": "Inventory Asset",
      "CiclasIuCreateDate": "2017-02-10T03:32:28Z",
      "CiclasIuCreateUser": "ADWAIT",
      "CiclasIuUpdateDate": "2017-02-10T04:24:40Z",
      "CiclasIuUpdateUser": "ADWAIT",
      "CiclasLotCtrlFlag": "N",
      "CiclasMsAvailableFlag": "N",
      "CiclasMszpcCode": null,
      "CiclasPartialDasmblFlag": "N",
      "CiclasProdFlag": "Y",
      "CiclasRevAccCode": "40015",
      "CiclasRevAccName": "Inventory Revenue",
      "CiclasRowid": "AAAX0uAAAAAAw5BAAW",
      "CiclasRtrnFlag": "N",
      "CiclasSalesProductFlag": "N",
      "CiclasSalesTax1Code": null,
      "CiclasSalesTax1Name": null,
      "CiclasSalesTax2Code": null,
      "CiclasSalesTax2Name": null,
      "CiclasSalesTax3Code": null,
      "CiclasSalesTax3Name": null,
      "CiclasSellPrice": null,
      "CiclasSellPriceOrPctCode": "C",
      "CiclasSerialFlag": "N",
      "CiclasSoldAtCostAccCode": "50600",
      "CiclasSoldAtCostAccName": "Cost of Goods Sold",
      "CiclasSuspAccCode": "17040",
      "CiclasSuspAccName": "Inventory Suspense",
      "CiclasTax1Code": null,
      "CiclasTax1Name": null,
      "CiclasTax2Code": null,
      "CiclasTax2Name": null,
      "CiclasTax3Code": null,
      "CiclasTax3Name": null,
      "CiclasTruckClassCode": null,
      "CiclasUsageCode": "N",
      "CiclasVUuid": "D2B734260ED33E82E05316821FAC9629",
      "CiclasVarAccCode": "50720",
      "CiclasVarAccName": "Inventory Variance- Purchasing",
      "CiclasVelocityCode": null,
      "CiclasWriAccCode": "50700",
      "CiclasWriAccName": "Inventory Writeoff Expense",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciclass/D2B734260ED33E82E05316821FAC9629",
          "name": "ciclass",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciclass/D2B734260ED33E82E05316821FAC9629",
          "name": "ciclass",
          "kind": "item"
        }
      ]
    },
    {
      "CiclasAccumDeprAccCode": null,
      "CiclasAccumDeprAccName": null,
      "CiclasAdjAccCode": "50710",
      "CiclasAdjAccName": "Inventory Adj - Cost Update",
      "CiclasAffilRevAccCode": "40015",
      "CiclasAffilRevAccName": "Inventory Revenue",
      "CiclasAllowNegQtyFlag": "Y",
      "CiclasAutoBuildCmpFlag": "N",
      "CiclasBbPriceOrPctCode": "P",
      "CiclasClassCode": "AGGR",
      "CiclasClassName": "Aggregates",
      "CiclasCmpFlag": "N",
      "CiclasCompCode": "001",
      "CiclasCompName": "CMiC Construction Inc",
      "CiclasCostMethCode": "STD",
      "CiclasCostUpdateLevelCode": "I",
      "CiclasCreditJcCatCode": null,
      "CiclasCreditJcCatName": null,
      "CiclasCtrlClassCode": null,
      "CiclasCtrlClassName": null,
      "CiclasCustRevAccCode": "40015",
      "CiclasCustRevAccName": "Inventory Revenue",
      "CiclasDefaultLocCode": null,
      "CiclasDefaultLocName": null,
      "CiclasDeprExpAccCode": null,
      "CiclasDeprExpAccName": null,
      "CiclasEmCostComponCode": null,
      "CiclasEmCostComponName": null,
      "CiclasHier": "001      .AGGR .",
      "CiclasInvAccCode": "17010",
      "CiclasInvAccName": "Inventory Asset",
      "CiclasIuCreateDate": "2017-02-10T04:35:45Z",
      "CiclasIuCreateUser": "ADWAIT",
      "CiclasIuUpdateDate": null,
      "CiclasIuUpdateUser": null,
      "CiclasLotCtrlFlag": "N",
      "CiclasMsAvailableFlag": "Y",
      "CiclasMszpcCode": null,
      "CiclasPartialDasmblFlag": "N",
      "CiclasProdFlag": "N",
      "CiclasRevAccCode": "40015",
      "CiclasRevAccName": "Inventory Revenue",
      "CiclasRowid": "AAAX0uAAAAAAw5GAAP",
      "CiclasRtrnFlag": "N",
      "CiclasSalesProductFlag": "N",
      "CiclasSalesTax1Code": null,
      "CiclasSalesTax1Name": null,
      "CiclasSalesTax2Code": null,
      "CiclasSalesTax2Name": null,
      "CiclasSalesTax3Code": null,
      "CiclasSalesTax3Name": null,
      "CiclasSellPrice": null,
      "CiclasSellPriceOrPctCode": "P",
      "CiclasSerialFlag": "N",
      "CiclasSoldAtCostAccCode": "50600",
      "CiclasSoldAtCostAccName": "Cost of Goods Sold",
      "CiclasSuspAccCode": "20010",
      "CiclasSuspAccName": "Accrued Liabilities",
      "CiclasTax1Code": null,
      "CiclasTax1Name": null,
      "CiclasTax2Code": null,
      "CiclasTax2Name": null,
      "CiclasTax3Code": null,
      "CiclasTax3Name": null,
      "CiclasTruckClassCode": null,
      "CiclasUsageCode": "N",
      "CiclasVUuid": "D2B734260F483E82E05316821FAC9629",
      "CiclasVarAccCode": "50720",
      "CiclasVarAccName": "Inventory Variance- Purchasing",
      "CiclasVelocityCode": null,
      "CiclasWriAccCode": "50700",
      "CiclasWriAccName": "Inventory Writeoff Expense",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciclass/D2B734260F483E82E05316821FAC9629",
          "name": "ciclass",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciclass/D2B734260F483E82E05316821FAC9629",
          "name": "ciclass",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 2,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciclass",
      "name": "ciclass",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create a Inventory Item Detail

Retrieve Inventory Classes By Code

Query Standards

Finder

Select by Date

By UUID

What's Next

Contact Us