Marketing Treatment Product

The products associated with a marketing treatment.

QName: {http://xmlns.oracle.com/apps/marketing/coreMarketing/treatments/treatmentService/}TrmtItemAssoc

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

Contained by

Marketing Treatment

Handled by

Marketing Treatment Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AttachmentEntityName

string

The entity name used by attachments that is used to categorize when uploading to stellant.

CreatedBy

string

The user who created the record.

CreationDate

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

The date when the record was created.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

Description

string

The free text description of the record.

InventoryItemId

long

The identifier of the inventory item associated with the product associated with this treatment.

InventoryOrgId

long

The identifier of the inventory item organization associated with the product associated with this treatment.

ItemId

long

The identifier of the inventory item.

LastUpdateDate

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

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdatedBy

string

The user who last updated the record.

LongDescription

string

A long description of the product associated with the treatment.

ObjectVersionNumber

int

The number used to implement 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 determine whether another session has updated the row.

OrganizationId

long

The identifier of the inventory organization.

PrimaryFlag

boolean

Indicates whether this product is a primary product for this treatment.

PrimaryProduct

string

The name of the primary product for this treatment.

ProdAssocId

long

The primary identifier of the association to the Product.
  • Primary Key

ProdGroupId

long

The identifier of the product group.

ProdGroupId1

long

The identifier of the product group.
  • Primary Key

ProdGroupName

string

The name of the product group if this record represents a product group.

Product

string

The name of the product if this record represents a product.

ProductDescription

string

The description of the product if this record represents a product.

ProductGroupDescriptionText

string

The description of the product group.

ProductName

string

The name of product or product group. It is the product name if this record represents a product. It is the product group name if this record represents a product group.

ProductType

string

Indicates if this record represents a product or a product group.

TreatmentId

long

The treatment identifier associated with the product associated with the treatment as a foreign key.

UOMCode

string

The attribute that captures the unit of measure for product.