JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersAffectedObjectAffectedItemItemRevision

The association of an item with a supplier who provides that item, such as the association of item CAR with supplier Zoom Incorporated.

Columns

Name Type Description
ProductChangeOrdersChangeId String ProductChangeOrdersChangeId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
AffectedobjectChangeLineId String AffectedobjectChangeLineId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
AffecteditemItemId String AffecteditemItemId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
AffecteditemOrganizationId String AffecteditemOrganizationId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
RevisionId String An unique identifier of a revision.
ItemId String An unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
OrganizationId String An unique identifier for 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.
RevisionCode String An attribute value that represents a revision.
ItemRevisionDescription String The description for on item revision.
RevisionReason String RevisionReason of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
RevisionReasonValue String An attribute value that represents the reason for a revision.
EffectivityDate Datetime Revision effectively date
ImplementationDate Datetime Date and time when the revision was implemented.
ChangeLineId String ChangeLineId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
EndEffectivityDate Datetime Date and time when the effectivity of the revision ends.
CopyAttachments Bool CopyAttachments of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
CopyDocuments Bool CopyDocuments of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
AltRevisionCode String AltRevisionCode of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
VersionAsOfDate Datetime VersionAsOfDate of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
RevisionExtensibleFlexfieldCategoryCode String An attribute value for the EFF category code for the Item revision.
ObjectVersionNumber Int This value is set to value of '1
CreationDateTime Datetime Who column: An attribute that indicates the date and time of the creation of the item revision.
LastUpdateDateTime Datetime Who column: An attribute which indicates the date and time of the last update of the item revision.
VersionId String Default Value: -1
ContextChangeLineId String Default Value: -1
ContextDate Datetime ContextDate of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
ContextVersionId String Default Value: -1
AttachmentEntityName String Default Value: ITEM_REVISION_ENTITY
InvItemIdChar String InvItemIdChar of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
OrgIdChar String OrgIdChar of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
RevisionIdChar String RevisionIdChar of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
OrganizationId1 String OrganizationId1 of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
InventoryItemId String InventoryItemId of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
ObjectVersionNumber1 Int ObjectVersionNumber1 of ProductChangeOrdersAffectedObjectAffectedItemItemRevision
CreatedBy String Who column: An attribute which indicates the user that created the item revision.
LastUpdateLogin String Who column: An attribute which indicates the user that logged in last for the item revision
LastUpdatedBy String Who column: An attribute which indicates the user that last updated the item revision
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