Contents x
      Create an Inventory Item
      • 25 Sep 2024
      • 2 Minutes to read
      • Print
      • Dark
        Light
      Contents

      Create an Inventory Item

      • Updated on 25 Sep 2024
      • 2 Minutes to read
      • Print
      • Dark
        Light
      Article summary

      Post
      /ci-rest-api/rest/1/ciitem

      Create Inventory Items

      UI Location: ASSET MANAGEMENT - Inventory - Setup - Item Master

      Security
      HTTP
      Type basic

      Basic authentication

      Header parameters
      Content-Type
      string
      Exampleapplication/vnd.oracle.adf.resourceItem+json
      Body parameters
      object
      Example{ "CiitemCompCode": "001", "CiitemItemCode": "1262", "CiitemBbPriceOrPctCode": "C", "CiitemWriAccCode": "50700", "CiitemRevAccCode": "40015", "CiitemInvAccCode": "17010", "CiitemSuspAccCode": "17040", "CiitemVarAccCode": "50720", "CiitemItemClassCode": "29", "CiitemCostUpdateLevelCode": "I", "CiitemCostMethCode": "AVG", "CiitemSellPriceOrPctCode": "C", "CiitemAdjAccCode": "50711", "CiitemWmCode": "EA", "CiitemSerialFlag": "N", "CiitemMsAvailableFlag": "N", "CiitemAutoBuildCmpFlag": "N", "CiitemUsageCode": "N", "CiitemAltWmAllowFlag": "N", "CiitemLotCtrlFlag": "N", "CiitemVUuid": "" }
      CiitemInvAccCode
      string Required

      Inventory account. Reference to the ACCOUNT table.

      CiitemWriAccCode
      string Required

      Write-off account. Reference to the ACCOUNT table.

      CiitemCompCode
      string Required

      Key value 1; Company code

      CiitemCostUpdateLevelCode
      string Required

      If using the Average Cost method of inventory valuation, specify whether to update the average cost of this inventory item by the total inventory (‘I’), or by the inventory within a specified location (‘L’).

      CiitemRevAccCode
      string Required

      Revenue account. Reference to the ACCOUNT table.

      CiitemAutoBuildCmpFlag
      string Required

      Auto build cmp Flag

      CiitemSerialFlag
      string Required

      ‘Y’ if the item is serialized, ‘N’ if not.

      CiitemAdjAccCode
      string Required

      Adjustment account. Reference to the ACCOUNT table.

      CiitemVarAccCode
      string Required

      Variance account. Reference to the ACCOUNT table.

      CiitemMsAvailableFlag
      string Required

      item available flag

      CiitemVUuid
      string Required

      Unique Row ID, leave empty

      CiitemCostMethCode
      string Required

      One of AVG (average cost), SF (standard FIFO), F (modified FIFO) and STD (standard cost). The validation program does not check but this should be the same value as in the item’s class.

      CiitemLotCtrlFlag
      string Required

      ‘Y’ or ‘N’. Set this to ‘N’ unless CIITEM_SERIAL_FLAG = ‘Y’ and CIITEM_COST_METH_CODE = ’F’

      CiitemSuspAccCode
      string Required

      Suspense account. Reference to the ACCOUNT table.

      CiitemItemClassCode
      string Required

      Key value 3; Reference (with CIITEM_COMP_CODE) to a class defined in the CICLASS table.

      CiitemUsageCode
      string Required

      Not used. Set this to ‘N’

      CiitemWmCode
      string Required

      Reference to a weight/measure code defined in WGTMES_TABLE

      CiitemBbPriceOrPctCode
      string Required

      ‘P’ if the buyback price is entered explicitly. ‘C’ if it calculated as a percentage of the cost price.

      CiitemItemCode
      string Required

      Key value 2; Inventory item code or number. If the fixed length flag is set in the control file, this code must be of the length specified in the control file.

      CiitemSellPriceOrPctCode
      string Required

      ‘P’ if the selling price is entered explicitly, ‘C’ if it calculated as a percentage of the cost price.

      CiitemAltWmAllowFlag
      string Required

      ‘Y’ if alternate unit conversions are enabled. ‘N’ if not.

      Responses
      201

      Created

      Headers
      Content-Type
      string
      Exampleapplication/vnd.oracle.adf.resourceitem+json
      {
  "CiitemAccumDeprAccCode": null,
  "CiitemAccumDeprAccName": null,
  "CiitemAdjAccCode": "50711",
  "CiitemAdjAccName": null,
  "CiitemAffilRevAccCode": null,
  "CiitemAffilRevAccName": null,
  "CiitemAllowNegQtyFlag": null,
  "CiitemAltWmAllowFlag": "N",
  "CiitemAutoBuildCmpFlag": "N",
  "CiitemBbPriceOrPctCode": "C",
  "CiitemBbPriceOrPctName": null,
  "CiitemBuybackPriceAmt": null,
  "CiitemClassName": null,
  "CiitemCmpFlag": null,
  "CiitemCompCode": "001",
  "CiitemCompName": null,
  "CiitemCostMethCode": "AVG",
  "CiitemCostMethName": null,
  "CiitemCostUpdateLevelCode": "I",
  "CiitemCostUpdateLevelName": null,
  "CiitemCreditJcCatCode": null,
  "CiitemCreditJcCatName": null,
  "CiitemCrtDate": null,
  "CiitemCrtUserCode": null,
  "CiitemCustRevAccCode": null,
  "CiitemCustRevAccName": null,
  "CiitemDefaultItemTypeCode": null,
  "CiitemDefaultLocCode": null,
  "CiitemDeprExpAccCode": null,
  "CiitemDeprExpAccName": null,
  "CiitemEmCostComponCode": null,
  "CiitemEmCostComponName": null,
  "CiitemImageFilename": null,
  "CiitemInvAccCode": "17010",
  "CiitemInvAccName": null,
  "CiitemInventoryItemCode": null,
  "CiitemInventoryItemName": null,
  "CiitemItemClassCode": "29",
  "CiitemItemCode": "1262",
  "CiitemItemDesc": null,
  "CiitemItemFixedLengthFlag": null,
  "CiitemItemLengthValue": null,
  "CiitemItemName": null,
  "CiitemIuCreateDate": null,
  "CiitemIuUpdateDate": null,
  "CiitemLastModifyDate": null,
  "CiitemLastModifyUserCode": null,
  "CiitemLotCtrlFlag": "N",
  "CiitemMarketPriceAmt": null,
  "CiitemMaxOnhandQty": null,
  "CiitemMaxOrderQty": null,
  "CiitemMinOnhandQty": null,
  "CiitemMinOrderQty": null,
  "CiitemMsAvailableFlag": "N",
  "CiitemMsptCode": null,
  "CiitemMszpcCode": null,
  "CiitemPartialDasmblFlag": null,
  "CiitemProdFlag": null,
  "CiitemRestockPriceAmt": null,
  "CiitemRevAccCode": "40015",
  "CiitemRevAccName": null,
  "CiitemRtrnFlag": null,
  "CiitemSalesProductFlag": null,
  "CiitemSalesTax1Code": null,
  "CiitemSalesTax1Name": null,
  "CiitemSalesTax2Code": null,
  "CiitemSalesTax2Name": null,
  "CiitemSalesTax3Code": null,
  "CiitemSalesTax3Name": null,
  "CiitemSellPriceAmt": null,
  "CiitemSellPriceOrPctCode": "C",
  "CiitemSellPriceOrPctName": null,
  "CiitemSerialFlag": "N",
  "CiitemSoldAtCostAccCode": null,
  "CiitemSoldAtCostAccName": null,
  "CiitemStdOnhandQty": null,
  "CiitemStdOrderQty": null,
  "CiitemSuspAccCode": "17040",
  "CiitemSuspAccName": null,
  "CiitemTax1Code": null,
  "CiitemTax1Name": null,
  "CiitemTax2Code": null,
  "CiitemTax2Name": null,
  "CiitemTax3Code": null,
  "CiitemTax3Name": null,
  "CiitemUsageCode": "N",
  "CiitemUsageName": null,
  "CiitemVUuid": "F29114ACA41A1C56E05316821FACAC2F",
  "CiitemVarAccCode": "50720",
  "CiitemVarAccName": null,
  "CiitemVelocityCode": null,
  "CiitemWmCode": "EA",
  "CiitemWmName": null,
  "CiitemWriAccCode": "50700",
  "CiitemWriAccName": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciitem/F29114ACA41A1C56E05316821FACAC2F",
      "name": "ciitem",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciitem/F29114ACA41A1C56E05316821FACAC2F",
      "name": "ciitem",
      "kind": "item"
    }
  ]
}
      object
      What's Next
      Contact Us
      Copyright © 2024 CMiC All Rights Reserved