Skip to main content

InventoryItem

InventoryItems. Represents a stock or non-stock inventory item.

type InventoryItem {
  inventoryId: Int!
  inventoryNumber: String!
  description: String
  status: String
  type: String
  itemClassId: String
  postingClassId: String
  vatCodeId: String
  priceClassId: String
  lotSerialClassId: String
  defaultPrice: Decimal!
  recommendedPrice: Decimal
  pendingCost: Decimal!
  pendingCostDate: DateTime
  currentCost: Decimal!
  effectiveDate: DateTime
  lastCost: Decimal!
  baseUnit: String!
  salesUnit: String!
  purchaseUnit: String!
  costPriceStatisticsLastCost: Decimal
  costPriceStatisticsAverageCost: Decimal
  costPriceStatisticsMinCost: Decimal
  costPriceStatisticsMaxCost: Decimal
  intrastatCn8: String
  intrastatCountryOfOrigin: String
  intrastatSupplementaryMeasureUnit: String
  packagingBaseItemWeight: Decimal!
  packagingWeightUom: String
  packagingBaseItemVolume: Decimal!
  packagingVolumeUom: String
  stockItem: Boolean!
  kitItem: Boolean!
  defaultWarehouseId: String
  defaultIssueFromId: String
  defaultReceiptToId: String
  note: String
  lastModifiedDateTime: DateTime!
  createdDateTime: DateTime!
  deletedDatabaseRecord: Boolean!
  companyId: Int!
  id: String!
  createdInDataMartDateTime: DateTime!
  updatedInDataMartDateTime: DateTime!
}

Fields​

InventoryItem.inventoryId ● Int! non-null scalar​

inventoryId > (PK) The unique identifier of the inventory item.

InventoryItem.inventoryNumber ● String! non-null scalar​

inventoryNumber > The code of the inventory item.

InventoryItem.description ● String scalar​

description > The description of the inventory item.

InventoryItem.status ● String scalar​

status > The current status of the inventory item.

InventoryItem.type ● String scalar​

type > The type of the inventory item.

InventoryItem.itemClassId ● String scalar​

itemClassId > The item class code of the inventory item.

InventoryItem.postingClassId ● String scalar​

postingClassId > The posting class code of the inventory item.

InventoryItem.vatCodeId ● String scalar​

vatCodeId > The tax category (VAT code) of the inventory item.

InventoryItem.priceClassId ● String scalar​

priceClassId > The price class code of the inventory item.

InventoryItem.lotSerialClassId ● String scalar​

lotSerialClassId > The lot/serial class code of the inventory item.

InventoryItem.defaultPrice ● Decimal! non-null scalar​

defaultPrice > The base sales price of the inventory item.

recommendedPrice > The recommended price of the inventory item.

InventoryItem.pendingCost ● Decimal! non-null scalar​

pendingCost > The pending standard cost of the inventory item.

InventoryItem.pendingCostDate ● DateTime scalar​

pendingCostDate > The date the pending standard cost becomes effective.

InventoryItem.currentCost ● Decimal! non-null scalar​

currentCost > The current standard cost of the inventory item.

InventoryItem.effectiveDate ● DateTime scalar​

effectiveDate > The date the current standard cost became effective.

InventoryItem.lastCost ● Decimal! non-null scalar​

lastCost > The previous standard cost of the inventory item.

InventoryItem.baseUnit ● String! non-null scalar​

baseUnit > The base unit of measure of the inventory item.

InventoryItem.salesUnit ● String! non-null scalar​

salesUnit > The sales unit of measure of the inventory item.

InventoryItem.purchaseUnit ● String! non-null scalar​

purchaseUnit > The purchase unit of measure of the inventory item.

InventoryItem.costPriceStatisticsLastCost ● Decimal scalar​

costPriceStatisticsLastCost > The cost of the last received or issued transaction across all warehouses.

InventoryItem.costPriceStatisticsAverageCost ● Decimal scalar​

costPriceStatisticsAverageCost > The average cost across all warehouses (total cost / quantity on hand).

InventoryItem.costPriceStatisticsMinCost ● Decimal scalar​

costPriceStatisticsMinCost > The minimum cost across all warehouses.

InventoryItem.costPriceStatisticsMaxCost ● Decimal scalar​

costPriceStatisticsMaxCost > The maximum cost across all warehouses.

InventoryItem.intrastatCn8 ● String scalar​

intrastatCn8 > The CN8 commodity code (Intrastat).

InventoryItem.intrastatCountryOfOrigin ● String scalar​

intrastatCountryOfOrigin > The country of origin (Intrastat).

InventoryItem.intrastatSupplementaryMeasureUnit ● String scalar​

intrastatSupplementaryMeasureUnit > The supplementary measure unit (Intrastat).

InventoryItem.packagingBaseItemWeight ● Decimal! non-null scalar​

packagingBaseItemWeight > The base item weight of the inventory item.

InventoryItem.packagingWeightUom ● String scalar​

packagingWeightUom > The unit of measure for the item weight.

InventoryItem.packagingBaseItemVolume ● Decimal! non-null scalar​

packagingBaseItemVolume > The base item volume of the inventory item.

InventoryItem.packagingVolumeUom ● String scalar​

packagingVolumeUom > The unit of measure for the item volume.

InventoryItem.stockItem ● Boolean! non-null scalar​

stockItem > Indicates whether the inventory item is a stock item.

InventoryItem.kitItem ● Boolean! non-null scalar​

kitItem > Indicates whether the inventory item is a kit item.

InventoryItem.defaultWarehouseId ● String scalar​

defaultWarehouseId > The code of the default warehouse.

InventoryItem.defaultIssueFromId ● String scalar​

defaultIssueFromId > The code of the default issue-from location.

InventoryItem.defaultReceiptToId ● String scalar​

defaultReceiptToId > The code of the default receipt-to location.

InventoryItem.note ● String scalar​

note > The free-text note attached to the inventory item.

InventoryItem.lastModifiedDateTime ● DateTime! non-null scalar​

lastModifiedDateTime > The last modified date and time of the inventory item.

InventoryItem.createdDateTime ● DateTime! non-null scalar​

createdDateTime > The date and time when the inventory item record was created.

InventoryItem.deletedDatabaseRecord ● Boolean! non-null scalar​

deletedDatabaseRecord > Indicates whether this record has been marked as deleted in the database.

InventoryItem.companyId ● Int! non-null scalar​

companyId > (PK) The unique identifier of the company.

InventoryItem.id ● String! non-null scalar​

id > The unique identifier of the document in DataMart.

InventoryItem.createdInDataMartDateTime ● DateTime! non-null scalar​

createdInDataMartDateTime > The UTC DateTime when this document has been added to DataMart.

InventoryItem.updatedInDataMartDateTime ● DateTime! non-null scalar​

updatedInDataMartDateTime > The UTC DateTime when this document has been updated in DataMart.

Returned By​

inventoryItems query