Copyright (c) 1996, 2015, Oracle and/or its affiliates. All rights reserved.
This material is the confidential property of Oracle Corporation or its licensors and may be used, reproduced, stored or transmitted only in accordance with a valid Oracle license or sublicense agreement.

Field Index SQL Mapping

Class /rollover

Unused resources from one cycle that are credited to an account resource balance in succeeding cycles.

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_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_PRODUCT_OBJ
string PIN_FLD_NAME
string PIN_FLD_CODE
string PIN_FLD_DESCR
enum PIN_FLD_DATE_RANGE_TYPE
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
int PIN_FLD_RELATIVE_START_OFFSET
int PIN_FLD_RELATIVE_END_OFFSET
enum PIN_FLD_RELATIVE_START_UNIT
enum PIN_FLD_RELATIVE_END_UNIT
array PIN_FLD_BAL_IMPACTS
int
int
string
decimal
decimal
enum
int
enum
enum


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

Link to account object for which this object was created.

Notes

  • Required on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

poid PIN_FLD_PRODUCT_OBJ

Link to product object this object is linked to.

Notes

  • Required on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

string PIN_FLD_NAME

Name of the rollover object.

Notes

  • Required on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

string PIN_FLD_CODE

Codee of the rollover object.

Notes

  • Required on object creation
  • Cannot be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

string PIN_FLD_DESCR

Rollover description.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.
  • Maximum length is 255 bytes

Links

enum PIN_FLD_DATE_RANGE_TYPE

Specify which type of the date ranges are used in this object. Value can be ABSOLUTE(0), RELATIVE(1).

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

timestamp PIN_FLD_START_T

Inclusive start time of the validity period for the rollover. If the value is 0, the validity starts immediately.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

timestamp PIN_FLD_END_T

Non-inclusive end time of the validity period for the rollover. If the value is 0, the rollover does not expire.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

int PIN_FLD_RELATIVE_START_OFFSET

Offset value from start date.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

int PIN_FLD_RELATIVE_END_OFFSET

Offset value from end date.

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

enum PIN_FLD_RELATIVE_START_UNIT

Unit PIN_FLD_RELATIVE_START_OFFSET is expressed in. Value can be SECOND(1), MINUTE(2), HOUR(3) or DAY(4).

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

enum PIN_FLD_RELATIVE_END_UNIT

Unit PIN_FLD_RELATIVE_END_OFFSET is expressed in. Value can be SECOND(1), MINUTE(2), HOUR(3) or DAY(4).

Notes

  • Can be specified on object creation
  • Can be modified
  • Audit trail is created automatically when this field is modified.

Links

array PIN_FLD_BAL_IMPACTS

Array of balance operations. Multiple impacts can be defined on the same resource. Array element id is not significant.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_RESOURCE_ID

Numeric value of the resource to be impacted.

Notes

Links

int PIN_FLD_GL_ID

GLID associated with this balance impact. Don't care if 0.

Notes

Links

string PIN_FLD_IMPACT_CATEGORY

Impact category determines which rate to apply with in a balance impact.

Notes

Links

decimal PIN_FLD_ROLLOVER_MAX_UNITS

Maximum quantity that can be rolled over.

Notes

Links

decimal PIN_FLD_ROLLOVER_UNITS

Quantity of resource to rollover per period.

Notes

Links

enum PIN_FLD_ROLLOVER_UOM

Specifies the unit of measure (days or months) of the field PIN_FLD_ROLLOVER_UNITS.

Notes

Links

int PIN_FLD_ROLLOVER_COUNT

Maximum no. of period to rollover.

Notes

Links

enum PIN_FLD_PRORATE_FIRST

Prorating option for the first cycle the rollover is owned. You can charge for a whole month (701), prorate the charge based on the days left in the month (702), or not charge for the partial month (703).

Notes

Links

enum PIN_FLD_PRORATE_LAST

Prorating option for the last cycle the rollover is owned. You can charge for a whole month (701), prorate the charge based on the days left in the month (702), or not charge for the partial month (703).

Notes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /rollover rollover_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_PRODUCT_OBJ product_obj*
string PIN_FLD_NAME name
string PIN_FLD_CODE code
string PIN_FLD_DESCR descr
enum PIN_FLD_DATE_RANGE_TYPE date_range_type
timestamp PIN_FLD_START_T start_t
timestamp PIN_FLD_END_T end_t
int PIN_FLD_RELATIVE_START_OFFSET start_offset
int PIN_FLD_RELATIVE_END_OFFSET end_offset
enum PIN_FLD_RELATIVE_START_UNIT rel_start_unit
enum PIN_FLD_RELATIVE_END_UNIT rel_end_unit
array PIN_FLD_BAL_IMPACTS rollover_bal_impacts_t
int
PIN_FLD_RESOURCE_ID
 		resource_id
int
PIN_FLD_GL_ID
 		gl_id
string
PIN_FLD_IMPACT_CATEGORY
 		impact_category
decimal
PIN_FLD_ROLLOVER_MAX_UNITS
 		rollover_max_units
decimal
PIN_FLD_ROLLOVER_UNITS
 		rollover_units
enum
PIN_FLD_ROLLOVER_UOM
 		uom
int
PIN_FLD_ROLLOVER_COUNT
 		rollover_count
enum
PIN_FLD_PRORATE_FIRST
 		prorate_first
enum
PIN_FLD_PRORATE_LAST
 		prorate_last
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