Retrieve Inventory Posted Transactions By Code
  • 01 Oct 2025
  • 3 Minutes to read
  • Dark
    Light

Retrieve Inventory Posted Transactions By Code

  • Dark
    Light

Article summary

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.

ParameterDescriptionSample
CompCodeCompany Code001
BchNumBatch Number60424
PostDatePost Date2016-01-01
BatchTypeBatch TypeWRI
AuditDateDate of Audit2025-08-18

By UUID

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

ParameterDescriptionSample
/VUUIDThe 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
{
  "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