JDBC Driver for Oracle SCM

Build 22.0.8462

SpokeSystemItemRelationships

The Spoke System Item Relationships resource manages the relationship between an internal item and spoke system item.

Columns

Name Type Description
ItemRelationshipId [KEY] String Value that uniquely identifies the spoke system item relationship.
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String Abbreviation that identifies the organization.
InventoryItemId String Value that uniquely identifies an item.
Item String Name or number of the part, item, product, or service.
SpokeSystemId String Value that uniquely identifies the spoke system.
SpokeSystemCode String Abbreviation that identifies the spoke system.
SpokeSystemItem String Name or number of the spoke system item.
RelationshipDescription String Description of the spoke system item relationship.
StartDateTime Datetime Date and time when the spoke system item relationship becomes effective.
EndDateTime Datetime Date when the spoke system item relationship becomes ineffective.
CreationDateTime Datetime Date and time when the user created the spoke system item relationship.
LastUpdateDateTime Datetime Date and time when the user most recently updated the spoke system item relationship.
CreatedBy String User who created the spoke system item relationship.
LastUpdateLogin String Login that the user used when updating the spoke system item relationship.
LastUpdatedBy String User who most recently updated the spoke system item relationship.

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