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