JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersV2

The Product Change Orders resource manages the change object.

Columns

Name Type Description
ChangeId [KEY] String Value that uniquely identifies the change.
ChangeTypeId String Value that uniquely identifies the type of change object.
ChangeNotice String Value that uniquely identifies the change object.
ChangeName String Name of the change object.
Description String Description of the change object.
OrganizationId String Value that uniquely identifies the organization of the change object.
PriorityCode String Abbreviation that identifies the priority of the change object.
ReasonCode String Abbreviation that identifies the reason for the change.
ChangeTypeValue String Value that determines the type of change. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task.
OrganizationCode String Abbreviation that identifies the organization of the change object.
PriorityCodeValue String Value that determines the priority of the change object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Priorities task.
ReasonCodeValue String Value that determines the reason for the change order. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Reasons task.
AssigneeId String Value that uniquely identifies the user assigned to the change object.
RequestorId String Value that uniquely identifies the user who requested the change object.
AssignedTo String User who the application assigned to the change object.
RequestedBy String User who requested the change object.
StatusType String Type of status of the change object. Valid values are open, interim approval, approval, scheduled, and completed. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Statuses task.
StatusCode String Abbreviation that identifies the status of the change object.
ApprovalStatus String Status of approval of the change order.
StatusTypeValue String Value of the status type of the change object. Valid values are open, interim approval, approval, scheduled, and completed.
StatusCodeValue String Abbreviation that identifies the status of the change object. Valid values are open, interim approval, approval, scheduled, and completed.
ApprovalStatusValue String Value that indicates the approval status of the change object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task.
EffectiveImmediatelyFlag Bool Contains one of the following values: true or false. If true, then the change order is effective immediately. If false, then the change order is not effective immediately. The default value is false.
EffectivityIncrementDays Long Number of days by which the effective date of the change object is incremented.
CreatedBy String User who created the change object.
LastUpdatedBy String User who most recently updated the change object.
LastUpdateLogin String Login that the user used when updating the change order.
AssignedToRole String Role that is used to define users to whom the change object can be assigned.
ApprovalDateTime Datetime Date when the change was approved.
NeedByDateTime Datetime Date by when the change is expected to be completed.
InitiationDateTime Datetime Date when the workflow corresponding to the change order was started.
ImplementationDateTime Datetime Date when this change order was implemented.
CancellationDateTime Datetime Date when this change order was canceled.
ApprovalRequestDateTime Datetime Date when this change order was sent for approval.
CreationDateTime Datetime Date when the change object was created.
LastUpdateDateTime Datetime Date when the change object was updated.

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