Get
/ci-rest-api/rest/1/citranposted
Query Standards
Finder
Following row finders are available for data filtering and optimizing request performance.
Select By Bch Num
By UUID
Select by Bch Num
Recommended finder parameters. Refer to Query Parameters for example.
| Parameter | Description | Sample |
|---|---|---|
| CompCode | Company Code | 001 |
| BchNum | Batch Number | 60424 |
| PostDate | Post Date | 2016-01-01 |
| BatchType | Batch Type | WRI |
| AuditDate | Date of Audit | 2025-08-18 |
By UUID
This is an optional finder for querying a specific Inventory Posted Transaction by row ID.
| Parameter | Description | Sample |
|---|---|---|
| /VUUID | The VUuid attribute is the Unique row ID | /ci-rest-api/rest/1/citranposted/D914A348B71934CFE05316821FACDD3B |
Security
HTTP
Type basic
Basic authentication
Query parameters
finder
string
ExampleselectByBchNum; CompCode=ZZ,BchNum=198569,PostDate=2025-08-20,BatchType=TRN,AuditDate=2025-08-20
limit
integer
Example25
offset
integer
Example0
totalResults
boolean
Exampletrue
orderBy
string
ExampleCitrnItemCode:desc
Responses
200
OK
Headers
Content-Type
string
Exampleapplication/vnd.oracle.adf.resourcecollection+json
{
"error": "{\n \"items\": [\n {\n \"CitrnCompCode\": \"ZZ\",\n \"CitrnCompName\": \"CMiC-ZZ Test Company Incorp\",\n \"CitrnTranType\": \"G\",\n \"CitrnTranTypeName\": \"General Ledger\",\n \"CitrnBchNum\": 192159,\n \"CitrnBchName\": \"SHAHIDWS 2025-06-11 WRI\",\n \"CitrnJobDeptWorderEqup\": null,\n \"CitrnPhsAccWitemComponcat\": null,\n \"CitrnCatExpTrancode\": null,\n \"CitrnTranNum\": 2324347351,\n \"CitrnSubstItemFlag\": null,\n \"CitrnActionCode\": null,\n \"CitrnItemClassCode\": \"OFFI\",\n \"CitrnItemClassName\": \"Office Supplies\",\n \"CitrnItemCode\": \"1104\",\n \"CitrnItemName\": \"1104\",\n \"CitrnItemTypeCode\": \"1\",\n \"CitrnItemTypeName\": \"Standard\",\n \"CitrnItemWmCode\": \"NA\",\n \"CitrnItemWmName\": \"Not Applic\",\n \"CitrnLocCode\": \"MAIN\",\n \"CitrnLocName\": \"Main Warehouse ABCDEFGHIKLMNOPQ\",\n \"CitrnReqQty\": null,\n \"CitrnQty\": 3,\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\": null,\n \"CitrnToFromCompName\": null,\n \"CitrnToFromDeptCode\": null,\n \"CitrnToFromDeptName\": null,\n \"CitrnToFromAccCode\": null,\n \"CitrnToFromAccName\": null,\n \"CitrnToFromJobCode\": null,\n \"CitrnToFromJobName\": null,\n \"CitrnToFromPhaseCode\": null,\n \"CitrnToFromPhaseName\": null,\n \"CitrnToFromCatCode\": null,\n \"CitrnToFromCatName\": null,\n \"CitrnToFromEqpCode\": null,\n \"CitrnToFromEqpName\": null,\n \"CitrnToFromComponCode\": null,\n \"CitrnToFromComponName\": null,\n \"CitrnToFromTrancodeCode\": null,\n \"CitrnToFromTrancodeName\": null,\n \"CitrnRefDate\": \"2025-06-10\",\n \"CitrnRefCode\": \"2\",\n \"CitrnRefDesc\": null,\n \"CitrnSrcCode\": null,\n \"CitrnSrcDesc\": null,\n \"CitrnReqNum\": null,\n \"CitrnReqReleaseNum\": null,\n \"CitrnReqLineNum\": null,\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 \"CitrnAmt\": 3.56,\n \"CitrnPostDate\": \"2025-06-10\",\n \"CitrnTranSnNum\": null,\n \"CitrnOverrideAmt\": null,\n \"CitrnWoCode\": null,\n \"CitrnWoName\": null,\n \"CitrnWitmLineNumber\": null,\n \"CitrnWitmLineName\": null,\n \"CitrnWoExpCode\": null,\n \"CitrnWoEx\npName\": null,\n \"CitrnWoTranType\": null,\n \"CitrnWDetailCode\": null,\n \"CitrnSalesTax1Amt\": null,\n \"CitrnSalesTax2Amt\": null,\n \"CitrnSalesTax3Amt\": null,\n \"CitrnOverrideCostAmt\": null,\n \"CitrnIuCreateDate\": \"2025-06-12T13:43:52-04:00\",\n \"CitrnIuUpdateDate\": \"2025-06-12T13:43:52-04:00\",\n \"CitrnJobDeptWoEqpName\": null,\n \"CitrnPhsaccWitemcompcatName\": null,\n \"CitrnCatExpTranName\": null,\n \"CitrnSuggestedPrice\": 1.187333,\n \"CitrnTotalPrice\": 3.561999,\n \"CitrnOnhandQty\": 96829.95,\n \"CitrnCalledFromAppCode\": \"CI\",\n \"CitrnUserFieldEdtFlag5\": null,\n \"CitrnUserFieldEdtFlag6\": null,\n \"CitrnUserFieldEdtFlag7\": null,\n \"CitrnUserFieldEdtFlag8\": null,\n \"CitrnUserFieldName5\": null,\n \"CitrnUserFieldName6\": null,\n \"CitrnUserFieldName7\": null,\n \"CitrnUserFieldName8\": null,\n \"CitrnWbsSetupFlag\": \"N\",\n \"CitrnTacSetupFlag\": \"N\",\n \"CitrnVUuid\": \"374DAD6E384206C6E0630B811DACF858\",\n \"CitrnBchType\": \"WRI\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://localhost:7101/ci-rest-api/rest/1/citranposted/374DAD6E384206C6E0630B811DACF858\",\n \"name\": \"citranposted\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://localhost:7101/ci-rest-api/rest/1/citranposted/374DAD6E384206C6E0630B811DACF858\",\n \"name\": \"citranposted\",\n \"kind\": \"item\"\n }\n ]\n },\n {\n \"CitrnCompCode\": \"ZZ\",\n \"CitrnCompName\": \"CMiC-ZZ Test Company Incorp\",\n \"CitrnTranType\": \"G\",\n \"CitrnTranTypeName\": \"General Ledger\",\n \"CitrnBchNum\": 192159,\n \"CitrnBchName\": \"SHAHIDWS 2025-06-11 WRI\",\n \"CitrnJobDeptWorderEqup\": null,\n \"CitrnPhsAccWitemComponcat\": null,\n \"CitrnCatExpTrancode\": null,\n \"CitrnTranNum\": 2324371699,\n \"CitrnSubstItemFlag\": null,\n \"CitrnActionCode\": null,\n \"CitrnItemClassCode\": \"OFFI\",\n \"CitrnItemClassName\": \"Office Supplies\",\n \"CitrnItemCode\": \"1104\",\n \"CitrnItemName\": \"1104\",\n \"CitrnItemTypeCode\": \"1\",\n \"CitrnItemTypeName\": \"Standard\",\n \"CitrnItemWmCode\": \"NA\",\n \"CitrnItemWmName\": \"Not Applic\",\n \"CitrnLocCode\": \"MAIN\",\n \"CitrnLocName\": \"Main Warehouse ABCDEFGHIKLMNOPQ\",\n \"CitrnReqQty\": null,\n \"CitrnQty\": 3,\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\": null,\n \"CitrnToFromCompName\": null,\n \"CitrnToFromDeptCode\": null,\n \"CitrnToFromDeptName\": null,\n \"CitrnToFromAccCode\": null,\n \"CitrnToFromAccName\": null,\n \"CitrnToFromJobCode\": null,\n \"CitrnToFromJobName\": null,\n \"CitrnToFromPhaseCode\": null,\n \"CitrnToFromPhaseName\": null,\n \"CitrnToFromCatCode\": null,\n \"CitrnToFromCatName\": null,\n \"CitrnToFromEqpCod\ne\": null,\n \"CitrnToFromEqpName\": null,\n \"CitrnToFromComponCode\": null,\n \"CitrnToFromComponName\": null,\n \"CitrnToFromTrancodeCode\": null,\n \"CitrnToFromTrancodeName\": null,\n \"CitrnRefDate\": \"2025-06-10\",\n \"CitrnRefCode\": \"2\",\n \"CitrnRefDesc\": null,\n \"CitrnSrcCode\": null,\n \"CitrnSrcDesc\": null,\n \"CitrnReqNum\": null,\n \"CitrnReqReleaseNum\": null,\n \"CitrnReqLineNum\": null,\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 \"CitrnAmt\": 3.56,\n \"CitrnPostDate\": \"2025-06-10\",\n \"CitrnTranSnNum\": null,\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 \"CitrnIuCreateDate\": \"2025-06-12T13:43:52-04:00\",\n \"CitrnIuUpdateDate\": \"2025-06-12T13:43:52-04:00\",\n \"CitrnJobDeptWoEqpName\": null,\n \"CitrnPhsaccWitemcompcatName\": null,\n \"CitrnCatExpTranName\": null,\n \"CitrnSuggestedPrice\": 1.187333,\n \"CitrnTotalPrice\": 3.561999,\n \"CitrnOnhandQty\": 96829.95,\n \"CitrnCalledFromAppCode\": \"CI\",\n \"CitrnUserFieldEdtFlag5\": null,\n \"CitrnUserFieldEdtFlag6\": null,\n \"CitrnUserFieldEdtFlag7\": null,\n \"CitrnUserFieldEdtFlag8\": null,\n \"CitrnUserFieldName5\": null,\n \"CitrnUserFieldName6\": null,\n \"CitrnUserFieldName7\": null,\n \"CitrnUserFieldName8\": null,\n \"CitrnWbsSetupFlag\": \"N\",\n \"CitrnTacSetupFlag\": \"N\",\n \"CitrnVUuid\": \"37634C37A4D13EECE0630B811DAC25E3\",\n \"CitrnBchType\": \"WRI\",\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://localhost:7101/ci-rest-api/rest/1/citranposted/37634C37A4D13EECE0630B811DAC25E3\",\n \"name\": \"citranposted\",\n \"kind\": \"item\"\n },\n {\n \"rel\": \"canonical\",\n \"href\": \"http://localhost:7101/ci-rest-api/rest/1/citranposted/37634C37A4D13EECE0630B811DAC25E3\",\n \"name\": \"citranposted\",\n \"kind\": \"item\"\n }\n ]\n }\n ],\n \"totalResults\": 2,\n \"count\": 2,\n \"hasMore\": false,\n \"limit\": 500,\n \"offset\": 0,\n \"links\": [\n {\n \"rel\": \"self\",\n \"href\": \"http://localhost:7101/ci-rest-api/rest/1/citranposted\",\n \"name\": \"citranposted\",\n\n \"kind\": \"collection\"\n }\n ]\n}"
}object