Retrieve Inventory Issue By Code

19 Jun 2024
3 Minutes to read

Print
Dark
Light

Retrieve Inventory Issue By Code

Updated on 19 Jun 2024
3 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/ciinventoryissue

Query Standards

Finder

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

Select by Inventory Issue Finder
By UUID

Select by Inventory Issue Finder

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
CompCode	Company Code	001
BchNum	Batch Number	4460743
ReqNum	Requisition Number	RQ000001

By UUID

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

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

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleCiInventoryIssueFinder;CompCode=001,BchNum=4460743,ReqNum=RQ000001

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleCitrnVUuid:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "CitrnCompCode": "001",
      "CitrnCompName": "CMiC Construction Inc",
      "CitrnTranType": "J",
      "CitrnTranTypeName": "Job",
      "CitrnBchNum": 4460743,
      "CitrnBchName": "CMICUSER 2022-10-16 REQ",
      "CitrnJobDeptWorderEqup": "14001",
      "CitrnPhsAccWitemComponcat": "01430",
      "CitrnCatExpTrancode": "O",
      "CitrnTranNum": null,
      "CitrnSubstItemFlag": "N",
      "CitrnActionCode": null,
      "CitrnItemClassCode": "29",
      "CitrnItemClassName": "Safety Materials",
      "CitrnItemCode": "01003500",
      "CitrnItemName": "Hard Hat",
      "CitrnItemTypeCode": "SA",
      "CitrnItemTypeName": "Safety Materials",
      "CitrnItemWmCode": "EA",
      "CitrnItemWmName": "Each",
      "CitrnLocCode": null,
      "CitrnLocName": null,
      "CitrnReqQty": null,
      "CitrnQty": null,
      "CitrnToFromLocCode": null,
      "CitrnToFromLocName": null,
      "CitrnToFromItemClassCode": null,
      "CitrnToFromItemClassName": null,
      "CitrnToFromItemCode": null,
      "CitrnToFromItemName": null,
      "CitrnToFromItemTypeCode": null,
      "CitrnToFromItemTypeName": null,
      "CitrnToFromWmCode": null,
      "CitrnToFromWmName": null,
      "CitrnToFromQty": null,
      "CitrnToFromCompCode": "001",
      "CitrnToFromCompName": "CMiC Construction Inc",
      "CitrnToFromDeptCode": "113",
      "CitrnToFromDeptName": "New York Operations",
      "CitrnToFromAccCode": "51050",
      "CitrnToFromAccName": "Other Job Costs",
      "CitrnToFromJobCode": "14001",
      "CitrnToFromJobName": "1 ULV Facilities Upgrade",
      "CitrnToFromPhaseCode": "01430",
      "CitrnToFromPhaseName": "Quality Assurance",
      "CitrnToFromCatCode": "O",
      "CitrnToFromCatName": "Other",
      "CitrnToFromEqpCode": null,
      "CitrnToFromEqpName": null,
      "CitrnToFromComponCode": null,
      "CitrnToFromComponName": null,
      "CitrnToFromTrancodeCode": null,
      "CitrnToFromTrancodeName": null,
      "CitrnRefDate": "2022-10-16T10:34:45Z",
      "CitrnRefCode": null,
      "CitrnRefDesc": null,
      "CitrnSrcCode": null,
      "CitrnSrcDesc": null,
      "CitrnReqNum": "RQ000001",
      "CitrnReqReleaseNum": null,
      "CitrnReqLineNum": 1,
      "CitrnWbsvCode1": null,
      "CitrnWbsvCode2": null,
      "CitrnWbsvCode3": null,
      "CitrnWbsvCode4": null,
      "CitrnWbsvCode5": null,
      "CitrnWbsvCode6": null,
      "CitrnWbsvCode7": null,
      "CitrnWbsvCode8": null,
      "CitrnWbsvCode9": null,
      "CitrnWbsvCode10": null,
      "CitrnWbsvCode11": null,
      "CitrnWbsvCode12": null,
      "CitrnPmCode": null,
      "CitrnMovedToInvFlag": null,
      "CitrnFromAllocQty": null,
      "CitrnRecPriceAmt": null,
      "CitrnRecCurrCode": null,
      "CitrnSalesTax1Code": null,
      "CitrnSalesTax1Name": null,
      "CitrnSalesTax2Code": null,
      "CitrnSalesTax2Name": null,
      "CitrnSalesTax3Code": null,
      "CitrnSalesTax3Name": null,
      "CitrnTicketNumber": null,
      "CitrnTicketPrintFlag": null,
      "CitrnTranSnNum": null,
      "CitrnSalesTax1TaxableFlag": "Y",
      "CitrnSalesTax2TaxableFlag": "Y",
      "CitrnSalesTax3TaxableFlag": "Y",
      "CitrnOverrideAmt": null,
      "CitrnWoCode": null,
      "CitrnWoName": null,
      "CitrnWitmLineNumber": null,
      "CitrnWitmLineName": null,
      "CitrnWoExpCode": null,
      "CitrnWoExpName": null,
      "CitrnWoTranType": null,
      "CitrnWDetailCode": null,
      "CitrnSalesTax1Amt": null,
      "CitrnSalesTax2Amt": null,
      "CitrnSalesTax3Amt": null,
      "CitrnOverrideCostAmt": null,
      "CitrnStockQty": null,
      "CitrnStockWmCode": "EA",
      "CitrnWmConvNum": 1,
      "CitrnRowid": "AAAXgWAADAADwSQAAO",
      "CitrnIuCreateDate": "2022-10-16T10:34:45Z",
      "CitrnIuUpdateDate": null,
      "CitrnJobDeptWoEqpName": "1 ULV Facilities Upgrade",
      "CitrnPhsaccWitemcompcatName": "Quality Assurance",
      "CitrnCatExpTranName": "Other",
      "CitrnSuggestedPrice": 0,
      "CitrnTotalPrice": null,
      "CitrnOnhandQty": 978,
      "CitrnConvQty": null,
      "CitrnUserField5": null,
      "CitrnUserField6": null,
      "CitrnUserField7": null,
      "CitrnUserField8": null,
      "CitrnCalledFromAppCode": "CI",
      "CitrnUserFieldEdtFlag5": "Y",
      "CitrnUserFieldEdtFlag6": "Y",
      "CitrnUserFieldEdtFlag7": "Y",
      "CitrnUserFieldEdtFlag8": "N",
      "CitrnUserFieldName5": null,
      "CitrnUserFieldName6": null,
      "CitrnUserFieldName7": null,
      "CitrnUserFieldName8": null,
      "CitrnWbsSetupFlag": "Y",
      "CitrnTacSetupFlag": "N",
      "CitrnPostDate": null,
      "CitrnVUuid": "EB2F774537F83A6AE05316821FACF907",
      "CitrnPostBchFlag": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciinventoryissue/EB2F774537F83A6AE05316821FACF907",
          "name": "ciinventoryissue",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciinventoryissue/EB2F774537F83A6AE05316821FACF907",
          "name": "ciinventoryissue",
          "kind": "item"
        }
      ]
    },
    {
      "CitrnCompCode": "001",
      "CitrnCompName": "CMiC Construction Inc",
      "CitrnTranType": "J",
      "CitrnTranTypeName": "Job",
      "CitrnBchNum": 4460743,
      "CitrnBchName": "CMICUSER 2022-10-16 REQ",
      "CitrnJobDeptWorderEqup": "14001",
      "CitrnPhsAccWitemComponcat": "01430",
      "CitrnCatExpTrancode": "O",
      "CitrnTranNum": null,
      "CitrnSubstItemFlag": "N",
      "CitrnActionCode": null,
      "CitrnItemClassCode": "29",
      "CitrnItemClassName": "Safety Materials",
      "CitrnItemCode": "1261",
      "CitrnItemName": "Safety Glasses - Clear",
      "CitrnItemTypeCode": "SA",
      "CitrnItemTypeName": "Safety Materials",
      "CitrnItemWmCode": "EA",
      "CitrnItemWmName": "Each",
      "CitrnLocCode": null,
      "CitrnLocName": null,
      "CitrnReqQty": null,
      "CitrnQty": null,
      "CitrnToFromLocCode": null,
      "CitrnToFromLocName": null,
      "CitrnToFromItemClassCode": null,
      "CitrnToFromItemClassName": null,
      "CitrnToFromItemCode": null,
      "CitrnToFromItemName": null,
      "CitrnToFromItemTypeCode": null,
      "CitrnToFromItemTypeName": null,
      "CitrnToFromWmCode": null,
      "CitrnToFromWmName": null,
      "CitrnToFromQty": null,
      "CitrnToFromCompCode": "001",
      "CitrnToFromCompName": "CMiC Construction Inc",
      "CitrnToFromDeptCode": "113",
      "CitrnToFromDeptName": "New York Operations",
      "CitrnToFromAccCode": "51050",
      "CitrnToFromAccName": "Other Job Costs",
      "CitrnToFromJobCode": "14001",
      "CitrnToFromJobName": "1 ULV Facilities Upgrade",
      "CitrnToFromPhaseCode": "01430",
      "CitrnToFromPhaseName": "Quality Assurance",
      "CitrnToFromCatCode": "O",
      "CitrnToFromCatName": "Other",
      "CitrnToFromEqpCode": null,
      "CitrnToFromEqpName": null,
      "CitrnToFromComponCode": null,
      "CitrnToFromComponName": null,
      "CitrnToFromTrancodeCode": null,
      "CitrnToFromTrancodeName": null,
      "CitrnRefDate": "2022-10-16T10:34:45Z",
      "CitrnRefCode": null,
      "CitrnRefDesc": null,
      "CitrnSrcCode": null,
      "CitrnSrcDesc": null,
      "CitrnReqNum": "RQ000001",
      "CitrnReqReleaseNum": null,
      "CitrnReqLineNum": 2,
      "CitrnWbsvCode1": null,
      "CitrnWbsvCode2": null,
      "CitrnWbsvCode3": null,
      "CitrnWbsvCode4": null,
      "CitrnWbsvCode5": null,
      "CitrnWbsvCode6": null,
      "CitrnWbsvCode7": null,
      "CitrnWbsvCode8": null,
      "CitrnWbsvCode9": null,
      "CitrnWbsvCode10": null,
      "CitrnWbsvCode11": null,
      "CitrnWbsvCode12": null,
      "CitrnPmCode": null,
      "CitrnMovedToInvFlag": null,
      "CitrnFromAllocQty": null,
      "CitrnRecPriceAmt": null,
      "CitrnRecCurrCode": null,
      "CitrnSalesTax1Code": null,
      "CitrnSalesTax1Name": null,
      "CitrnSalesTax2Code": null,
      "CitrnSalesTax2Name": null,
      "CitrnSalesTax3Code": null,
      "CitrnSalesTax3Name": null,
      "CitrnTicketNumber": null,
      "CitrnTicketPrintFlag": null,
      "CitrnTranSnNum": null,
      "CitrnSalesTax1TaxableFlag": "Y",
      "CitrnSalesTax2TaxableFlag": "Y",
      "CitrnSalesTax3TaxableFlag": "Y",
      "CitrnOverrideAmt": null,
      "CitrnWoCode": null,
      "CitrnWoName": null,
      "CitrnWitmLineNumber": null,
      "CitrnWitmLineName": null,
      "CitrnWoExpCode": null,
      "CitrnWoExpName": null,
      "CitrnWoTranType": null,
      "CitrnWDetailCode": null,
      "CitrnSalesTax1Amt": null,
      "CitrnSalesTax2Amt": null,
      "CitrnSalesTax3Amt": null,
      "CitrnOverrideCostAmt": null,
      "CitrnStockQty": null,
      "CitrnStockWmCode": "EA",
      "CitrnWmConvNum": 1,
      "CitrnRowid": "AAAXgWAADAADwSQAAP",
      "CitrnIuCreateDate": "2022-10-16T10:34:45Z",
      "CitrnIuUpdateDate": null,
      "CitrnJobDeptWoEqpName": "1 ULV Facilities Upgrade",
      "CitrnPhsaccWitemcompcatName": "Quality Assurance",
      "CitrnCatExpTranName": "Other",
      "CitrnSuggestedPrice": 0,
      "CitrnTotalPrice": null,
      "CitrnOnhandQty": 987,
      "CitrnConvQty": null,
      "CitrnUserField5": null,
      "CitrnUserField6": null,
      "CitrnUserField7": null,
      "CitrnUserField8": null,
      "CitrnCalledFromAppCode": "CI",
      "CitrnUserFieldEdtFlag5": "Y",
      "CitrnUserFieldEdtFlag6": "Y",
      "CitrnUserFieldEdtFlag7": "Y",
      "CitrnUserFieldEdtFlag8": "N",
      "CitrnUserFieldName5": null,
      "CitrnUserFieldName6": null,
      "CitrnUserFieldName7": null,
      "CitrnUserFieldName8": null,
      "CitrnWbsSetupFlag": "Y",
      "CitrnTacSetupFlag": "N",
      "CitrnPostDate": null,
      "CitrnVUuid": "EB2F774537F93A6AE05316821FACF907",
      "CitrnPostBchFlag": null,
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciinventoryissue/EB2F774537F93A6AE05316821FACF907",
          "name": "ciinventoryissue",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciinventoryissue/EB2F774537F93A6AE05316821FACF907",
          "name": "ciinventoryissue",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 2,
  "hasMore": false,
  "limit": 25,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciinventoryissue",
      "name": "ciinventoryissue",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create an Inventory Item

Retrieve Inventory Issue By Code

Query Standards

Finder

Select by Inventory Issue Finder

By UUID

What's Next

Contact Us