JDBC Driver for Oracle SCM

Build 22.0.8462

PhysicalInventoryTags

The Physical Inventory Tags resource manages physical inventory tags.

Columns

Name Type Description
TagId [KEY] String Value that uniquely identifies the physical inventory tag.
PhysicalInventoryId String Value that uniquely identifies the physical inventory.
PhysicalInventoryName String Name of the physical inventory.
OrganizationId String Value that uniquely identifies the inventory organization.
OrganizationCode String Abbreviation that identifies the inventory organization.
TagVoidCode String Value that indicates if the tag is not valid. Contains one of the following values. 1: tag is void. 2: tag is active. The default value is 2.
TagVoid String Value that indicates if the tag is not valid. Contains one of the following values. Void: tag is void. Active: tag is active. The default value is Active.
TagTypeCode String Abbreviation that identifies the type of physical inventory tag that the create tag action creates.
TagType String Type of physical inventory tags generated after the generate tags action. A list of accepted values is defined in the lookup type INV_TAG_TYPE. There is no default value for this attribute.
TagNumber String Number that inventory assigns to the physical inventory tag. It represents the contents of a unique item location in inventory.
AdjustmentId String AdjustmentId of PhysicalInventoryTags
InventoryItemId String Value that uniquely identifies the inventory item number in physical inventory.
ItemNumber String Name of the item. This item is unique compared to other items according to item attributes.
TagQuantity String Quantity of the stock keeping unit on the tag for the item.
TagUOMCode String Abbreviation that identifies the unit of measure of the quantity for the stock keeping unit counted on the tag.
TagUnitOfMeasure String Unit of measure of the quantity for the stock keeping unit counted on the tag.
TagSecondaryQuantity String Quantity in the secondary unit of measure of the item.
TagSecondaryUOMCode String Abbreviation that identifies the secondary unit of measure of the item.
TagSecondaryUnitOfMeasure String Secondary unit of measure of the item.
Subinventory String Physical or logical area in the inventory organization where you store material.
LocatorId String Value that uniquely identifies the locator.
Locator String Physical area, such as a row, aisle, bin, or shelf, in the subinventory that stores material.
LotNumber String Number that identifies the lot. Inventory uses the lot to create items that share the similar production costs and specifications.
LotExpirationDate Datetime Date when the availability of the lot for transaction and planning purposes expires.
Revision String Version of the item that inventory is counting.
SerialNumber String Number that uniquely identifies a single quantity of the item inventory is counting.
CountedByEmployeeId String Value that uniquely identifies the person who performed the physical count.
CountedByEmployeeName String Name of the user who performed the physical inventory count.
OwningTypeCode String Abbreviation that identifies the type of owner of the financial liability of consigned inventory. Contains one of the following values. 1: owning party is supplier site 2: owning party is inventory organization. The default value is 2.
OwningType String Type of owner of the financial liability of consigned inventory. Contains one of the following values. Supplier site: owning party is supplier site Inventory organization: owning party is inventory organization. The default value is Inventory organization.
OwningEntityId String Value that uniquely identifies the owning party that is financially responsible for consigned inventory.
OwningPartySite String Value that identifies the party site where the owning party resides.
OwningParty String Owning party that is financially responsible for consigned inventory.
ProcurementBU String Business unit that manages and owns the purchasing document.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462