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
{
"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-16T22: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-16T22: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-16T22: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-16T22: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