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

Class /tmp_sharing_rollup_imp

storable class to store sub-balance data which will be rolled up during billing.

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
poid PIN_FLD_POID
timestamp PIN_FLD_CREATED_T
timestamp PIN_FLD_MOD_T
string PIN_FLD_READ_ACCESS
string PIN_FLD_WRITE_ACCESS
string PIN_FLD_CREATE_ACCESS
poid PIN_FLD_ACCOUNT_OBJ
poid PIN_FLD_BAL_GRP_OBJ
poid PIN_FLD_BILLINFO_OBJ
int PIN_FLD_RESOURCE_ID
array PIN_FLD_SUB_BALANCES
enum
decimal
timestamp
int
timestamp
int
string
int
poid
decimal


Field Details

poid PIN_FLD_POID

Object Identifier for an instance of this class. Portal object ids have four pieces of information: database number, class type, sequence id, revision.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_CREATED_T

Time the object was created.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

timestamp PIN_FLD_MOD_T

Time the object was last modified.

Notes

  • System defined on object creation
  • Can be modified only by System

Links

string PIN_FLD_READ_ACCESS

Read Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_WRITE_ACCESS

Write Access level for object. Valid values are S(Self), G(Global), L(BrandLineage), B(BrandGroup), A(Ancestral).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

string PIN_FLD_CREATE_ACCESS

Create Access level for object. Valid values are O(BrandOwner), R(Root), N(Any).

Notes

  • System defined on object creation
  • Can be modified only by System
  • Maximum length is 255 bytes

Links

poid PIN_FLD_ACCOUNT_OBJ

Points to the member account.

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_BAL_GRP_OBJ

The balance group object these sub balance impact belongs to.

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_BILLINFO_OBJ

The billinfo object these sub balance impact belongs to.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_RESOURCE_ID

Numeric value of the resource that is impacted.

Notes

  • Required on object creation
  • Can be modified

Links

array PIN_FLD_SUB_BALANCES

Array to hold the sub_balances impacts.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_SUBTYPE

This field represents the type of sub balance.Possible values are PIN_SUB_BAL_TYPE_DEFAULT(0), PIN_SUB_BAL_TYPE_LOAN(1).

Notes

Links

decimal PIN_FLD_AMOUNT

This field represents the amount impacted for this sub_balance entry.

Notes

Links

timestamp PIN_FLD_VALID_FROM

The start date of this validity based balance, 0 indicate infinity.

Notes

Links

int PIN_FLD_VALID_FROM_DETAILS

Detail of field PIN_FLD_VALID_FROM mode, offset and unit.

Notes

Links

timestamp PIN_FLD_VALID_TO

The end date of this validity based balance, 0 indicate infinity.

Notes

Links

int PIN_FLD_VALID_TO_DETAILS

Detail of field PIN_FLD_VALID_TO mode, offset and unit.

Notes

Links

string PIN_FLD_CONTRIBUTOR_STR

The contributor for this sub-balance counter.

Notes

Links

int PIN_FLD_ROLLOVER_DATA

Have rollover information stored, rollover type and rollover date.

Notes

Links

poid PIN_FLD_GRANTOR_OBJ

This field will contain the poid of /purchased_product or /purchased_discount or /product that was responsible creation of these sub-balances.

Notes

Links

decimal PIN_FLD_GRANTED_BAL

This field represents the granted amount impacted for this sub_balance entry.

Notes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /tmp_sharing_rollup_imp tmp_sharing_rollup_imp_t
poid PIN_FLD_POID poid*
timestamp PIN_FLD_CREATED_T created_t
timestamp PIN_FLD_MOD_T mod_t
string PIN_FLD_READ_ACCESS read_access
string PIN_FLD_WRITE_ACCESS wrtie_access
string PIN_FLD_CREATE_ACCESS create_access
poid PIN_FLD_ACCOUNT_OBJ account_obj*
poid PIN_FLD_BAL_GRP_OBJ bal_grp_obj*
poid PIN_FLD_BILLINFO_OBJ billinfo_obj*
int PIN_FLD_RESOURCE_ID resource_id
array PIN_FLD_SUB_BALANCES tmp_sharing_rollup_imp_bal_t
enum
PIN_FLD_SUBTYPE
 		subtype
decimal
PIN_FLD_AMOUNT
 		amount
timestamp
PIN_FLD_VALID_FROM
 		valid_from
int
PIN_FLD_VALID_FROM_DETAILS
 		valid_from_details
timestamp
PIN_FLD_VALID_TO
 		valid_to
int
PIN_FLD_VALID_TO_DETAILS
 		valid_to_details
string
PIN_FLD_CONTRIBUTOR_STR
 		contributor
int
PIN_FLD_ROLLOVER_DATA
 		rollover_data
poid
PIN_FLD_GRANTOR_OBJ
 		grantor_obj*
decimal
PIN_FLD_GRANTED_BAL
 		granted_bal
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