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

Class /event/notification/price/products/modify

If existing product is updated then an event will be generated for the same to notify the pipeline about the change through accountsync to use the new product for rating through the business event /event/notification/price/products/modify.

Notes

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

Links



Field Index

Type Field Name
poid PIN_FLD_ACCOUNT_OBJ
array PIN_FLD_PRODUCTS
poid
int
poid
string
string
poid
enum
timestamp
timestamp
decimal
decimal
decimal
decimal
enum
decimal
string
string
string
string
array
string
string
enum
enum
decimal
int
enum
decimal
enum
enum
string
array3
array
string
string


Field Details

poid PIN_FLD_ACCOUNT_OBJ

Notes

  • Required on object creation
  • Can be modified

Links

array PIN_FLD_PRODUCTS

Array of products that are updated.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_POID

Portal object id of the product.

Notes

Links

int PIN_FLD_TAILORMADE

A value 1 indicates it is a tailor made product.

Notes

Links

poid PIN_FLD_BASE_PRODUCT_OBJ

Base product poid.

Notes

Links

string PIN_FLD_NAME

Name of the product.

Notes

Links

string PIN_FLD_DESCR

Product description.

Notes

Links

poid PIN_FLD_ACCOUNT_OBJ

Account object product.

Notes

Links

enum PIN_FLD_TYPE

Product type - item (PIN_PROD_TYPE_ITEM - 601) or subscription (PIN_PROD_TYPE_ONGOING - 602).system (PIN_PROD_TYPE_SYSTEM - 603).

Notes

Links

timestamp PIN_FLD_START_T

Valid start time - defines valid period for product object.

Notes

Links

timestamp PIN_FLD_END_T

Valid end time - defines valid period for product object. If end time is zero, valid period does not expire.

Notes

Links

decimal PIN_FLD_PURCHASE_MIN

Purchase Minimum - minimum quantity that can be purchased at a single time.

Notes

Links

decimal PIN_FLD_PURCHASE_MAX

Purchase Maximum - maximum quantity that can be purchased at a single time.

Notes

Links

decimal PIN_FLD_OWN_MIN

Ownership Minimum - minimum quantity that can be owned at any time.

Notes

Links

decimal PIN_FLD_OWN_MAX

Ownership Maximum - maximum quantity that can be owned at any time.

Notes

Links

enum PIN_FLD_PARTIAL

Partial parameter - determines if fractional quantities can be purchased and/or owned.

Notes

Links

decimal PIN_FLD_PRIORITY

Priority - used to resolve ordering of product application.

Notes

Links

string PIN_FLD_PERMITTED

Contains a single type string for account or service object types that is permitted to purchase this product. The entry is implicitly appended with a wildcard for checking, so account or service types that were inherited from a permitted type are also permitted themselves.

Notes

Links

string PIN_FLD_PROVISIONING_TAG

Provisioning tag - used with PCM_OP_BILL_POL_{PURCHASE, CANCEL}_PROD_PROVISIONING.

Notes

Links

string PIN_FLD_ZONEMAP_NAME

Zonemap name.

Notes

Links

string PIN_FLD_SUPPLIER_NAME

Tax supplier name.

Notes

Links

array PIN_FLD_USAGE_MAP

Array of usage map.

Notes

Links

string PIN_FLD_EVENT_TYPE

Event type.

Notes

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

Links

string PIN_FLD_RUM_NAME

Specifies which rum should be used to rate this event type.

Notes

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

Links

enum PIN_FLD_TOD_MODE

TOD mode defines how tod rates are applied to the event. START_TIME(0), END_TIME(1), TIMED(2).

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_TIMEZONE_MODE

It defines which timezone to use when apply TOD rates. Value can be EVENT(0), SERVER(1), ACCOUNT(2).

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_MIN_QUANTITY

Minimum value that the RUM quantity is rounded to.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_FLAGS

Specify if this usage map is valid for the product at certain status.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_MIN_UNIT

Unit min quantity is expressed in. Value can be NONE(0), SECOND(1), MINUTE(2), HOUR(3), DAY(4).

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_INCR_QUANTITY

Increment value to round RUM Quantity to.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_INCR_UNIT

Units that INCR_QUANTITY specified in.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_ROUNDING_MODE

Specifies how rum quantity is rounded.

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_RATE_PLAN_NAME

Rate plan name.

Notes

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

Links

array3 PIN_FLD_RATE_PLANS

Rate plan array.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_ATTRIBUTES

Array of offer attributes.

Notes

Links

string PIN_FLD_NAME

Name of the attribute.

Notes

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

Links

string PIN_FLD_VALUE

Value of the attribute.

Notes

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

Links


SQL Mapping

Links


PIN_FLD_RATE_PLANS
Rate plan array. PIN_FLD_RATE_TIERS Rate tier array. PIN_FLD_DATE_RANGES Array of date ranges. PIN_FLD_DAY_RANGES Day range array. PIN_FLD_TOD_RANGES Array of valid daily time ranges for the rate object. PIN_FLD_RATES Rate array. PIN_FLD_QUANTITY_TIERS Quantity tier array. PIN_FLD_BAL_IMPACTS Balance impact array.
Type Field Name Table Column Name
derived-class /event/notification/price/products/modify
poid PIN_FLD_ACCOUNT_OBJ
array PIN_FLD_PRODUCTS
poid
PIN_FLD_POID
int
PIN_FLD_TAILORMADE
poid
PIN_FLD_BASE_PRODUCT_OBJ
string
PIN_FLD_NAME
string
PIN_FLD_DESCR
poid
PIN_FLD_ACCOUNT_OBJ
enum
PIN_FLD_TYPE
timestamp
PIN_FLD_START_T
timestamp
PIN_FLD_END_T
decimal
PIN_FLD_PURCHASE_MIN
decimal
PIN_FLD_PURCHASE_MAX
decimal
PIN_FLD_OWN_MIN
decimal
PIN_FLD_OWN_MAX
enum
PIN_FLD_PARTIAL
decimal
PIN_FLD_PRIORITY
string
PIN_FLD_PERMITTED
string
PIN_FLD_PROVISIONING_TAG
string
PIN_FLD_ZONEMAP_NAME
string
PIN_FLD_SUPPLIER_NAME
array
PIN_FLD_USAGE_MAP
string
PIN_FLD_EVENT_TYPE
string
PIN_FLD_RUM_NAME
enum
PIN_FLD_TOD_MODE
enum
PIN_FLD_TIMEZONE_MODE
decimal
PIN_FLD_MIN_QUANTITY
int
PIN_FLD_FLAGS
enum
PIN_FLD_MIN_UNIT
decimal
PIN_FLD_INCR_QUANTITY
enum
PIN_FLD_INCR_UNIT
enum
PIN_FLD_ROUNDING_MODE
string
PIN_FLD_RATE_PLAN_NAME
poid
string
string
int
poid
poid
int
string
enum
int
enum
string
decimal
enum
int
poid
string
string
timestamp
timestamp
int
enum
int
enum
int
string
string
int
int
int
int
string
int
int
int
poid
string
string
enum
enum
enum
enum
int
poid
poid
decimal
decimal
string
int
int
decimal
decimal
enum
int
timestamp
timestamp
int
enum
int
enum
array
PIN_FLD_ATTRIBUTES
string
PIN_FLD_NAME
string
PIN_FLD_VALUE
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