Copyright © 2026, Oracle and/or its affiliates.
Field Index SQL Mapping

Class /event/notification/product_inventory/patch/attribute_change

The /event/notification/product_inventory/patch/attribute_change is generated when a /purchased_product is modified

Notes

  • This object can be read by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be modified by the owner or any billing group leader within the brand who is an ancestor of the owner.
  • This object can be created by anyone.

Links



Field Index

Type Field Name
array PIN_FLD_RESULTS
poid
string
string
enum
timestamp
string
timestamp
int
string
string
timestamp
poid
poid
poid
poid
int
array
string
string
string
string
substruct
array3
substruct
array
poid
string
string
string
array3
substruct
substruct
substruct
substruct
array
string
array3
array
poid
string
string
substruct


Field Details

array PIN_FLD_RESULTS

Stores the /purchased_product related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_POID

Poid of the /purchased_product or /purchased_discount object.

Notes

Links

string PIN_FLD_IDENTIFICATION_CODE

Unique identification code for the product.

Notes

Links

string PIN_FLD_LIFECYCLE_STATUS

Lifecycle status of the product inventory.

Notes

Links

enum PIN_FLD_STATUS

Status of the purchased product or purchased discount.

Notes

Links

timestamp PIN_FLD_START_T

Start time - Timestamp of when purchased product is purchased (Portal Time).

Notes

Links

string PIN_FLD_DESCR

Description of the purchased product or purchased discount.

Notes

Links

timestamp PIN_FLD_END_T

End time - Timestamp of when purchase product should end (Portal Time).

Notes

Links

int PIN_FLD_IS_BUNDLE

Specifies if the product is a bundle. Possible values - 1 (bundle) or 0 (independent product/discount)

Notes

Links

string PIN_FLD_NAME

Name of the purchased product or purchased discount.

Notes

Links

string PIN_FLD_PRICE_LIST_NAME

Price list name of the product.

Notes

Links

timestamp PIN_FLD_CREATED_T

Created time - Timestamp of when purchased product is Created (Portal Time).

Notes

Links

poid PIN_FLD_DEAL_OBJ

Poid of immediate parent product.

Notes

Links

poid PIN_FLD_ACCOUNT_OBJ

Poid of the account which has the product.

Notes

Links

poid PIN_FLD_SOURCE_OBJ

Poid of the /purchased_product or /purchased_discount as source object.

Notes

Links

poid PIN_FLD_PLAN_OBJ

Poid of top level bundle product.

Notes

Links

int PIN_FLD_BUNDLE_LEVEL

Stores the bundled product hierarchy level.

Notes

Links

array PIN_FLD_PRODUCT_CHARACTERISTIC

Array with info about product characteristics.

Notes

Links

string PIN_FLD_IDENTIFICATION_CODE

Identification code for the product characteristic.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_NAME

Name of the product characteristic.

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 255 bytes

Links

string PIN_FLD_TYPE_STR

Type of the product characteristic.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 0 bytes

Links

string PIN_FLD_VALUE

Value of the object.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

substruct PIN_FLD_DATA

Substruct to store custom data or Service details.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_VALUES

Array to store custom data or Service alias details.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_PRODUCT_OFFERING

Name and Identification code of the product offering

Notes

Links

array PIN_FLD_SERVICES

Array with info about Service.

Notes

Links

poid PIN_FLD_POID

POID of the service.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_NAME

Name of the service.

Notes

  • Cannot specify on object creation
  • Cannot be modified
  • Maximum length is 0 bytes

Links

string PIN_FLD_LOGIN

Login for the service.

Notes

  • Cannot specify on object creation
  • Cannot be modified
  • Maximum length is 0 bytes

Links

string PIN_FLD_IDENTIFICATION_CODE

Identification code for the realizing service.

Notes

  • Cannot specify on object creation
  • Cannot be modified
  • Maximum length is 0 bytes

Links

array3 PIN_FLD_ALIAS_LIST

The array of aliases for service.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_ACCOUNT

First Name, Last Name and Status for the Account Object

Notes

Links

substruct PIN_FLD_CYCLE_END_INFO

Substruct to pass offset for PIN_FLD_CYCLE_END_T.

Notes

Links

substruct PIN_FLD_USAGE_END_INFO

Substruct to pass offset for PIN_FLD_USAGE_END_T.

Notes

Links

substruct PIN_FLD_PURCHASE_END_INFO

Substruct to pass offset for PIN_FLD_PURCHASE_END_T.

Notes

Links

array PIN_FLD_PRODUCT_PRICE

Array with info about Product Price Overrides.

Notes

Links

string PIN_FLD_TYPE_STR

The type string of the price override (recurring/oneTime).

Notes

  • Cannot specify on object creation
  • Cannot be modified
  • Maximum length is 0 bytes

Links

array3 PIN_FLD_VALUES

Array with the override types.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_PRODUCT_RELATIONSHIP

Array with info about Product relationships.

Notes

Links

poid PIN_FLD_POID

The poid of the related product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_IDENTIFICATION_CODE

The Identification code of the related product.

Notes

  • Can be specified on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

string PIN_FLD_TYPE_STR

Type of the product relationship (bundles/bundledBy/tiedDiscount/tiedProduct).

Notes

  • Required on object creation
  • Can be modified
  • Maximum length is 0 bytes

Links

substruct PIN_FLD_EVENT_INFO

Event of the opcode execution.

Notes

Links



SQL Mapping

Links


PIN_FLD_VALUES
Array to store custom data or Service alias details.
PIN_FLD_ALIAS_LIST
The array of aliases for service.
PIN_FLD_VALUES
Array with the override types. PIN_FLD_PRICING_INFO Array with the unit and amount for AmountOverride or DiscountAmountOverride.
Type Field Name Table Column Name
derived-class /event/notification/product_inventory/patch/attribute_change
array PIN_FLD_RESULTS
poid
PIN_FLD_POID
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_LIFECYCLE_STATUS
enum
PIN_FLD_STATUS
timestamp
PIN_FLD_START_T
string
PIN_FLD_DESCR
timestamp
PIN_FLD_END_T
int
PIN_FLD_IS_BUNDLE
string
PIN_FLD_NAME
string
PIN_FLD_PRICE_LIST_NAME
timestamp
PIN_FLD_CREATED_T
poid
PIN_FLD_DEAL_OBJ
poid
PIN_FLD_ACCOUNT_OBJ
poid
PIN_FLD_SOURCE_OBJ
poid
PIN_FLD_PLAN_OBJ
int
PIN_FLD_BUNDLE_LEVEL
array
PIN_FLD_PRODUCT_CHARACTERISTIC
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_NAME
string
PIN_FLD_TYPE_STR
string
PIN_FLD_VALUE
substruct
string
PIN_FLD_LOGIN
string
PIN_FLD_PASSWD_CLEAR
string
PIN_FLD_SVC_TYPE
string
string
substruct
PIN_FLD_PRODUCT_OFFERING
string
PIN_FLD_CODE
string
PIN_FLD_NAME
poid
PIN_FLD_POID
array
PIN_FLD_SERVICES
poid
PIN_FLD_POID
string
PIN_FLD_NAME
string
PIN_FLD_LOGIN
string
PIN_FLD_IDENTIFICATION_CODE
string
string
substruct
PIN_FLD_ACCOUNT
poid
PIN_FLD_POID
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_FIRST_NAME
string
PIN_FLD_LAST_NAME
string
PIN_FLD_MIDDLE_NAME
string
PIN_FLD_ACCOUNT_NO
substruct
PIN_FLD_CYCLE_END_INFO
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
PIN_FLD_USAGE_END_INFO
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
PIN_FLD_PURCHASE_END_INFO
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
array
PIN_FLD_PRODUCT_PRICE
string
PIN_FLD_TYPE_STR
string
decimal
string
decimal
array
PIN_FLD_PRODUCT_RELATIONSHIP
poid
PIN_FLD_POID
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_TYPE_STR
substruct
PIN_FLD_EVENT_INFO
poid
PIN_FLD_POID
timestamp
PIN_FLD_START_T
string
PIN_FLD_TYPE_STR
string
PIN_FLD_EVENT_NO
string
PIN_FLD_INTERNAL_EVENT_NO
Column names marked with * are actually column prefixes. For poid type fields, the column prefix is used to create the columns poid_id0, poid_db and poid_type if the prefix is "poid". For PIN_FLD_POID in the base table, an additional column named poid_rev is created to hold the poid revision. For buffer fields, two columns are created - one in the containing table and one in the buffer table. For example if the prefix is "buf", then the column name in the buffer table is buffer_buf and the column name in the containing table is buffer_size.

Field Index This Class