API Catalog

Retrieve Inventory Posted Transactions By Code

01 Oct 2025
3 Minutes to read

Print
Dark
Light

Retrieve Inventory Posted Transactions By Code

Updated on 01 Oct 2025
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/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

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

{
  "items": [
    {
      "CitrnCompCode": "ZZ",
      "CitrnCompName": "CMiC-ZZ  Test Company Incorp",
      "CitrnTranType": "G",
      "CitrnTranTypeName": "General Ledger",
      "CitrnBchNum": 192159,
      "CitrnBchName": "SHAHIDWS 2025-06-11 WRI",
      "CitrnJobDeptWorderEqup": null,
      "CitrnPhsAccWitemComponcat": null,
      "CitrnCatExpTrancode": null,
      "CitrnTranNum": 2324347351,
      "CitrnSubstItemFlag": null,
      "CitrnActionCode": null,
      "CitrnItemClassCode": "OFFI",
      "CitrnItemClassName": "Office Supplies",
      "CitrnItemCode": "1104",
      "CitrnItemName": "1104",
      "CitrnItemTypeCode": "1",
      "CitrnItemTypeName": "Standard",
      "CitrnItemWmCode": "NA",
      "CitrnItemWmName": "Not Applic",
      "CitrnLocCode": "MAIN",
      "CitrnLocName": "Main Warehouse ABCDEFGHIKLMNOPQ",
      "CitrnReqQty": null,
      "CitrnQty": 3,
      "CitrnToFromLocCode": null,
      "CitrnToFromLocName": null,
      "CitrnToFromItemClassCode": null,
      "CitrnToFromItemClassName": null,
      "CitrnToFromItemCode": null,
      "CitrnToFromItemName": null,
      "CitrnToFromItemTypeCode": null,
      "CitrnToFromItemTypeName": null,
      "CitrnToFromWmCode": null,
      "CitrnToFromWmName": null,
      "CitrnToFromQty": null,
      "CitrnToFromCompCode": null,
      "CitrnToFromCompName": null,
      "CitrnToFromDeptCode": null,
      "CitrnToFromDeptName": null,
      "CitrnToFromAccCode": null,
      "CitrnToFromAccName": null,
      "CitrnToFromJobCode": null,
      "CitrnToFromJobName": null,
      "CitrnToFromPhaseCode": null,
      "CitrnToFromPhaseName": null,
      "CitrnToFromCatCode": null,
      "CitrnToFromCatName": null,
      "CitrnToFromEqpCode": null,
      "CitrnToFromEqpName": null,
      "CitrnToFromComponCode": null,
      "CitrnToFromComponName": null,
      "CitrnToFromTrancodeCode": null,
      "CitrnToFromTrancodeName": null,
      "CitrnRefDate": "2025-06-10",
      "CitrnRefCode": "2",
      "CitrnRefDesc": null,
      "CitrnSrcCode": null,
      "CitrnSrcDesc": null,
      "CitrnReqNum": null,
      "CitrnReqReleaseNum": null,
      "CitrnReqLineNum": null,
      "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,
      "CitrnAmt": 3.56,
      "CitrnPostDate": "2025-06-10",
      "CitrnTranSnNum": null,
      "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,
      "CitrnIuCreateDate": "2025-06-12T17:43:52Z",
      "CitrnIuUpdateDate": "2025-06-12T17:43:52Z",
      "CitrnJobDeptWoEqpName": null,
      "CitrnPhsaccWitemcompcatName": null,
      "CitrnCatExpTranName": null,
      "CitrnSuggestedPrice": 1.187333,
      "CitrnTotalPrice": 3.561999,
      "CitrnOnhandQty": 96829.95,
      "CitrnCalledFromAppCode": "CI",
      "CitrnUserFieldEdtFlag5": null,
      "CitrnUserFieldEdtFlag6": null,
      "CitrnUserFieldEdtFlag7": null,
      "CitrnUserFieldEdtFlag8": null,
      "CitrnUserFieldName5": null,
      "CitrnUserFieldName6": null,
      "CitrnUserFieldName7": null,
      "CitrnUserFieldName8": null,
      "CitrnWbsSetupFlag": "N",
      "CitrnTacSetupFlag": "N",
      "CitrnVUuid": "374DAD6E384206C6E0630B811DACF858",
      "CitrnBchType": "WRI",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/ci-rest-api/rest/1/citranposted/374DAD6E384206C6E0630B811DACF858",
          "name": "citranposted",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/ci-rest-api/rest/1/citranposted/374DAD6E384206C6E0630B811DACF858",
          "name": "citranposted",
          "kind": "item"
        }
      ]
    },
    {
      "CitrnCompCode": "ZZ",
      "CitrnCompName": "CMiC-ZZ  Test Company Incorp",
      "CitrnTranType": "G",
      "CitrnTranTypeName": "General Ledger",
      "CitrnBchNum": 192159,
      "CitrnBchName": "SHAHIDWS 2025-06-11 WRI",
      "CitrnJobDeptWorderEqup": null,
      "CitrnPhsAccWitemComponcat": null,
      "CitrnCatExpTrancode": null,
      "CitrnTranNum": 2324371699,
      "CitrnSubstItemFlag": null,
      "CitrnActionCode": null,
      "CitrnItemClassCode": "OFFI",
      "CitrnItemClassName": "Office Supplies",
      "CitrnItemCode": "1104",
      "CitrnItemName": "1104",
      "CitrnItemTypeCode": "1",
      "CitrnItemTypeName": "Standard",
      "CitrnItemWmCode": "NA",
      "CitrnItemWmName": "Not Applic",
      "CitrnLocCode": "MAIN",
      "CitrnLocName": "Main Warehouse ABCDEFGHIKLMNOPQ",
      "CitrnReqQty": null,
      "CitrnQty": 3,
      "CitrnToFromLocCode": null,
      "CitrnToFromLocName": null,
      "CitrnToFromItemClassCode": null,
      "CitrnToFromItemClassName": null,
      "CitrnToFromItemCode": null,
      "CitrnToFromItemName": null,
      "CitrnToFromItemTypeCode": null,
      "CitrnToFromItemTypeName": null,
      "CitrnToFromWmCode": null,
      "CitrnToFromWmName": null,
      "CitrnToFromQty": null,
      "CitrnToFromCompCode": null,
      "CitrnToFromCompName": null,
      "CitrnToFromDeptCode": null,
      "CitrnToFromDeptName": null,
      "CitrnToFromAccCode": null,
      "CitrnToFromAccName": null,
      "CitrnToFromJobCode": null,
      "CitrnToFromJobName": null,
      "CitrnToFromPhaseCode": null,
      "CitrnToFromPhaseName": null,
      "CitrnToFromCatCode": null,
      "CitrnToFromCatName": null,
      "CitrnToFromEqpCode": null,
      "CitrnToFromEqpName": null,
      "CitrnToFromComponCode": null,
      "CitrnToFromComponName": null,
      "CitrnToFromTrancodeCode": null,
      "CitrnToFromTrancodeName": null,
      "CitrnRefDate": "2025-06-10",
      "CitrnRefCode": "2",
      "CitrnRefDesc": null,
      "CitrnSrcCode": null,
      "CitrnSrcDesc": null,
      "CitrnReqNum": null,
      "CitrnReqReleaseNum": null,
      "CitrnReqLineNum": null,
      "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,
      "CitrnAmt": 3.56,
      "CitrnPostDate": "2025-06-10",
      "CitrnTranSnNum": null,
      "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,
      "CitrnIuCreateDate": "2025-06-12T17:43:52Z",
      "CitrnIuUpdateDate": "2025-06-12T17:43:52Z",
      "CitrnJobDeptWoEqpName": null,
      "CitrnPhsaccWitemcompcatName": null,
      "CitrnCatExpTranName": null,
      "CitrnSuggestedPrice": 1.187333,
      "CitrnTotalPrice": 3.561999,
      "CitrnOnhandQty": 96829.95,
      "CitrnCalledFromAppCode": "CI",
      "CitrnUserFieldEdtFlag5": null,
      "CitrnUserFieldEdtFlag6": null,
      "CitrnUserFieldEdtFlag7": null,
      "CitrnUserFieldEdtFlag8": null,
      "CitrnUserFieldName5": null,
      "CitrnUserFieldName6": null,
      "CitrnUserFieldName7": null,
      "CitrnUserFieldName8": null,
      "CitrnWbsSetupFlag": "N",
      "CitrnTacSetupFlag": "N",
      "CitrnVUuid": "37634C37A4D13EECE0630B811DAC25E3",
      "CitrnBchType": "WRI",
      "links": [
        {
          "rel": "self",
          "href": "http://localhost:7101/ci-rest-api/rest/1/citranposted/37634C37A4D13EECE0630B811DAC25E3",
          "name": "citranposted",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://localhost:7101/ci-rest-api/rest/1/citranposted/37634C37A4D13EECE0630B811DAC25E3",
          "name": "citranposted",
          "kind": "item"
        }
      ]
    }
  ],
  "totalResults": 2,
  "count": 2,
  "hasMore": false,
  "limit": 500,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://localhost:7101/ci-rest-api/rest/1/citranposted",
      "name": "citranposted",
      "kind": "collection"
    }
  ]
}

object

What's Next

Update a Specific Inventory Issue

Retrieve Inventory Posted Transactions By Code

Query Standards

Finder

Select by Bch Num

By UUID

What's Next

Contact Us