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

Class /event/notification/product_inventory/post

The /event/notification/product_inventory/post is generated when a /purchased_product or /purchased_discount is purchased

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
poid
string
string
string
string
timestamp
timestamp
int
poid
poid
string
timestamp
poid
poid
decimal
int
array
string
string
string
string
substruct
array3
array
poid
string
string
string
array3
substruct
substruct
substruct
substruct
substruct
substruct
substruct
substruct
substruct
array
string
array3
array
poid
string
string
array
poid
poid
string
string
string
string
timestamp
timestamp
int
poid
poid
string
timestamp
poid
poid
decimal
int
array3
array3
substruct
substruct
substruct
substruct
substruct
substruct
substruct
substruct
substruct
array3
array3
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

poid PIN_FLD_PRODUCT_CHARACTERISTIC_OBJ

Poid of the linked product characteristic.

Notes

Links

string PIN_FLD_IDENTIFICATION_CODE

Unique identification code for the product.

Notes

Links

string PIN_FLD_DESCR

Description of the purchased product or purchased discount.

Notes

Links

string PIN_FLD_NAME

Name of the purchased product or purchased discount.

Notes

Links

string PIN_FLD_LIFECYCLE_STATUS

Lifecycle status of the product inventory.

Notes

Links

timestamp PIN_FLD_START_T

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

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

poid PIN_FLD_PLAN_OBJ

Poid of top level bundle product.

Notes

Links

poid PIN_FLD_DEAL_OBJ

Poid of immediate parent product.

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_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

decimal PIN_FLD_QUANTITY

Quantity of the 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

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_PRODUCT_OFFERING

Name and Identification code of the product offering

Notes

Links

substruct PIN_FLD_ACCOUNT

First Name, Last Name and Status for the Account Object

Notes

Links

substruct PIN_FLD_CYCLE_START_INFO

Substruct to pass offset for PIN_FLD_CYCLE_START_T.

Notes

Links

substruct PIN_FLD_CYCLE_END_INFO

Substruct to pass offset for PIN_FLD_CYCLE_END_T.

Notes

Links

substruct PIN_FLD_USAGE_START_INFO

Substruct to pass offset for PIN_FLD_USAGE_START_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_START_INFO

Substruct to pass offset for PIN_FLD_PURCHASE_START_T.

Notes

Links

substruct PIN_FLD_PURCHASE_END_INFO

Substruct to pass offset for PIN_FLD_PURCHASE_END_T.

Notes

Links

substruct PIN_FLD_GRACE_PERIOD_INFO

Substruct to pass offset for PIN_FLD_GRACE_PERIOD.

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

array PIN_FLD_PRODUCTS

Array with subproducts.

Notes

Links

poid PIN_FLD_POID

Poid of the /purchased_product or /purchased_discount object.

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_PRODUCT_CHARACTERISTIC_OBJ

Poid of the linked product characteristic.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_IDENTIFICATION_CODE

Unique identification code for the product.

Notes

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

Links

string PIN_FLD_DESCR

Description of the purchased product or purchased discount.

Notes

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

Links

string PIN_FLD_NAME

Name of the purchased product or purchased discount.

Notes

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

Links

string PIN_FLD_LIFECYCLE_STATUS

Lifecycle status of the product inventory.

Notes

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

Links

timestamp PIN_FLD_START_T

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

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

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

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_IS_BUNDLE

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

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PLAN_OBJ

Poid of top level bundle product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_DEAL_OBJ

Poid of immediate parent product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_PRICE_LIST_NAME

Price list name of the product.

Notes

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

Links

timestamp PIN_FLD_CREATED_T

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

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_ACCOUNT_OBJ

Poid of the account which has the product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_SOURCE_OBJ

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

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_QUANTITY

Quantity of the product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_BUNDLE_LEVEL

Stores the bundled product hierarchy level.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_PRODUCT_CHARACTERISTIC

Array with info about product characteristics.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_SERVICES

Array with info about Service.

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

  • 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

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_CYCLE_START_INFO

Substruct to pass offset for PIN_FLD_CYCLE_START_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_CYCLE_END_INFO

Substruct to pass offset for PIN_FLD_CYCLE_END_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_USAGE_START_INFO

Substruct to pass offset for PIN_FLD_USAGE_START_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_USAGE_END_INFO

Substruct to pass offset for PIN_FLD_USAGE_END_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_PURCHASE_START_INFO

Substruct to pass offset for PIN_FLD_PURCHASE_START_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_PURCHASE_END_INFO

Substruct to pass offset for PIN_FLD_PURCHASE_END_T.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_GRACE_PERIOD_INFO

Substruct to pass offset for PIN_FLD_GRACE_PERIOD.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_PRODUCT_PRICE

Array with info about Product Price Overrides.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_PRODUCT_RELATIONSHIP

Array with info about Product relationships.

Notes

  • Can be specified on object creation
  • Can be modified

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.
PIN_FLD_PRODUCT_CHARACTERISTIC
Array with info about product characteristics. PIN_FLD_VALUES Array to store custom data or Service alias details.
PIN_FLD_SERVICES
Array with info about Service. PIN_FLD_ALIAS_LIST The array of aliases for service.
PIN_FLD_PRODUCT_PRICE
Array with info about Product Price Overrides. PIN_FLD_VALUES Array with the override types. PIN_FLD_PRICING_INFO Array with the unit and amount for AmountOverride or DiscountAmountOverride.
PIN_FLD_PRODUCT_RELATIONSHIP
Array with info about Product relationships.
Type Field Name Table Column Name
derived-class /event/notification/product_inventory/post
array PIN_FLD_RESULTS
poid
PIN_FLD_POID
poid
PIN_FLD_PRODUCT_CHARACTERISTIC_OBJ
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_DESCR
string
PIN_FLD_NAME
string
PIN_FLD_LIFECYCLE_STATUS
timestamp
PIN_FLD_START_T
timestamp
PIN_FLD_END_T
int
PIN_FLD_IS_BUNDLE
poid
PIN_FLD_PLAN_OBJ
poid
PIN_FLD_DEAL_OBJ
string
PIN_FLD_PRICE_LIST_NAME
timestamp
PIN_FLD_CREATED_T
poid
PIN_FLD_ACCOUNT_OBJ
poid
PIN_FLD_SOURCE_OBJ
decimal
PIN_FLD_QUANTITY
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
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_PRODUCT_OFFERING
string
PIN_FLD_CODE
string
PIN_FLD_NAME
poid
PIN_FLD_POID
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_START_INFO
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
PIN_FLD_CYCLE_END_INFO
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
PIN_FLD_USAGE_START_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_START_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
substruct
PIN_FLD_GRACE_PERIOD_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
array
PIN_FLD_PRODUCTS
poid
PIN_FLD_POID
poid
PIN_FLD_PRODUCT_CHARACTERISTIC_OBJ
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_DESCR
string
PIN_FLD_NAME
string
PIN_FLD_LIFECYCLE_STATUS
timestamp
PIN_FLD_START_T
timestamp
PIN_FLD_END_T
int
PIN_FLD_IS_BUNDLE
poid
PIN_FLD_PLAN_OBJ
poid
PIN_FLD_DEAL_OBJ
string
PIN_FLD_PRICE_LIST_NAME
timestamp
PIN_FLD_CREATED_T
poid
PIN_FLD_ACCOUNT_OBJ
poid
PIN_FLD_SOURCE_OBJ
decimal
PIN_FLD_QUANTITY
int
PIN_FLD_BUNDLE_LEVEL
string
string
string
string
substruct
string
PIN_FLD_LOGIN
string
PIN_FLD_PASSWD_CLEAR
string
PIN_FLD_SVC_TYPE
string
string
poid
string
string
string
string
string
substruct
string
PIN_FLD_CODE
string
PIN_FLD_NAME
poid
PIN_FLD_POID
substruct
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
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
string
PIN_FLD_OFFSET_VALUE
string
string
decimal
string
decimal
poid
string
string
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