Item Transaction Attribute

An attribute with metadata that is defined during item creation; the value of the attribute is captured when the item is usedin a transaction, such as the attribute Monogram for item Shirt.

QName: {http://xmlns.oracle.com/apps/scm/productModel/itemClasses/itemClassServiceV2/}TransAttr

Logical Business Objects

  • SCM : Product Model : Item Class

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Item Transaction Attribute Metadata

Contains

Item Transaction Attribute

Contained by

Item Class

Handled by

Item Class

Attributes

The following table describes attributes in the service data object.

Name Type Description

BaseValueSetId

long

Indicates the starting value of the Transactional Attribute.

CreatedBy

string

Who column: An attribute that indicates who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: An attribute that indicates the date and time of the creation of the record.

CurrentDBTime

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Current database time.

DataTypeCode

string

Data type of the Transactional Attribute. It can be Character, Date, Number or Time.

Description

string

Description of Transactional Attribute.

DisplayName

string

Display Name of the Transactional Attribute.

DisplayNameDisp

string

Display Name Disp of the transactional Attribute.

InternalName

string

A short description of the Transactional Attribute used internally.

ItemClassId

long

The unique identifier for an item class.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: indicates the date and time of the last update of the row.

LastUpdateLogin

string

Who column: indicates the session login associated to the user who last updated the row.

LastUpdatedBy

string

Who column: indicates the user who last updated the row.

ObjectVersionNumber

int

Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

StartDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Effective Start Date.

TransAttrMetaData

Item Transaction Attribute Metadata

The metadata, such as default value or hidden indicator, that is used to define the behavior of transactional item attributes.

TransAttrTranslation

Item Transaction Attribute

Transactional Attributes TL

TransactionalAttrId

long

An attribute with metadata that is defined during item creation; the value of the attribute is captured when the item is used in a transaction, such as the attribute Monogram for item Shirt.
  • Primary Key

TransactionalAttrMetadataId

long

The metadata, such as default value or hidden indicator, that is used to define the behavior of transactional item attributes.

UOMCode

string

Standard unit of measure.