JDBC Driver for Oracle SCM

Build 22.0.8462

ItemStructures

The Item Structures resource manages the details of an item structure. Use this resource to include a primary structure that is used to build the item, or an alternate structure.

Columns

Name Type Description
BillSequenceId [KEY] String A unique identifier for structure. This value is only updatable for the updated operation, otherwise read only.
ChangeNotice String Read Only: This attribute provides the Change Order Notice to which the service operation added all the Structure component changes. This could happen when a Needs Approval Rule fires.
OrganizationId String Value that uniquely identifies the organization.
OrganizationCode String A name of an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. This value is only updatable for the create operation, otherwise read only.
ItemId String Value that uniquely identifies the part, item, product, or service.
ItemNumber String An attribute that is an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes. This value is only updatable for the create operation, otherwise read only.
AlternateBOMDesignator String Alternate designator for the item structure.
StructureName String An attribute which value represents the name of a structure. This value is only updatable for the create operation, otherwise read only.
Description String The description for structure.
EffectivityControl Long Value that indicates the way effectivity is controlled within a structure. Valid values include Date, Unit Number, or Serial Number.
EffectivityControlValue String An attribute which value indicates the way effectivity is controlled within a structure. The values include Date, Unit Number, or Serial Number.
CommonItemNumber String Read Only: An attribute which value is the item number for a common structure.
CommonOrganizationCode String Read Only: An attribute which value is the name for the organziation for a common structure.
SourceItemNumber String Read Only: An attribute that represents the spoke system item number from which the structure is created.
SourceOrganizationCode String Read Only: An attribute indicating the source organization code from which the structure is created.
CreationDateTime Datetime Who column: An attribute that indicates the date and time of the creation of the structure.
LastUpdateDateTime Datetime Who column: An attribute which indicates the date and time of the last update of the structure.
OriginalSystemReference String The authoring system that is responsible for managing the record. If empty, the record is typically managed by the user interactively, in the standard user interface.
CreatedBy String Who column: An attribute which indicates the user that created the structure.
LastUpdateLogin String Who column: An attribute which indicates the user that logged in last for the structure.
LastUpdatedBy String Who column: An attribute which indicates the user that last updated the structure.
RequestId String This is the request id generated at import. Its use case is to verify import, the items will be published based on RequestID.

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