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

Class /subscription_terms

Stores /subscription_terms objects

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
string PIN_FLD_NAME
string PIN_FLD_DESCR
string PIN_FLD_CODE
int PIN_FLD_TERM_LENGTH
enum PIN_FLD_TERM_UNIT
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
int PIN_FLD_EARLY_TERMINATION_ALLOWED
int PIN_FLD_TERMINATION_GRACE_LENGTH
enum PIN_FLD_TERMINATION_GRACE_UNIT
poid PIN_FLD_ACCOUNT_OBJ
poid PIN_FLD_PENALTY_OBJ
int PIN_FLD_RENEW_FLAGS
poid PIN_FLD_AUTO_RENEW_PLAN_OBJ
poid PIN_FLD_AUTO_RENEW_DEAL_OBJ
poid PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ
enum PIN_FLD_PENALTY_OPTIONS
decimal PIN_FLD_PENALTY_AMOUNT
int PIN_FLD_RESOURCE_ID
int PIN_FLD_REVENUE_GLID
int PIN_FLD_MINIMUM_TERM_LENGTH
enum PIN_FLD_MINIMUM_TERM_UNIT


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

string PIN_FLD_NAME

Name of the subscription terms.

Notes

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

Links

string PIN_FLD_DESCR

User-defined description of the subscription_terms.

Notes

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

Links

string PIN_FLD_CODE

Code of the subscription_terms object. Assumed to be unique across all subscription_terms defined by the PDC. Relevant if PDC is enabled

Notes

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

Links

int PIN_FLD_TERM_LENGTH

Length of the subscription terms

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_TERM_UNIT

Unit of the subscription terms

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_START_T

Inclusive start time of the subscription_terms

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

Non-Inclusive End time of the subscription_terms

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_EARLY_TERMINATION_ALLOWED

Specifies whether early termination allowed or not.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_TERMINATION_GRACE_LENGTH

Length along with Unit (Days/Months) tells the period during which the penalty/cancel fee would not be applied

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_TERMINATION_GRACE_UNIT

Days/Months Units along with length tells the period during which the penalty/cancel fee would not be applied

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_ACCOUNT_OBJ

Account object associated with this object (normally root account)

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_PENALTY_OBJ

Penalty Obj required if penalty charges should be applied

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_RENEW_FLAGS

Renewal flags(0=renewal disabled, 1=renewal enabled,2=evergreen)

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AUTO_RENEW_PLAN_OBJ

Auto renew /plan used when terms are associated with the package. Required if RENEW_FLAGS set to 1

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AUTO_RENEW_DEAL_OBJ

Auto renew /deal used when terms are associated with the Bundle, Required if RENEW_FLAGS set to 1

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ

Subscription_term used for auto renew.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_PENALTY_OPTIONS

penalty options. At the time of contract termination how the penalty charges should be calculatedPossible values are 0 - Apply Fixed penalty charge configured as penalty amount, 1 - Calculate proration of penalty amount based on number of FULL MONTHS completed of the contract 2 - Calculate based on remaining contract balance 3 - Calculated based on remaining contract balance and fixed penalty charge configured 4 - Calculated based on remaining contract balance and prorated penalty charge configured

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_PENALTY_AMOUNT

penalty fees. At early termination time, penalty charges are computed based on penalty options and penalty fees

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_RESOURCE_ID

Numeric value of the resource to be impacted for penalty charges.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_REVENUE_GLID

Revenue GLID associated with the penalty charges

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_MINIMUM_TERM_LENGTH

Minimum Term Length of the subscription terms

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_MINIMUM_TERM_UNIT

Unit(day, months and year) that define the minimum period duration of the subscription term.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /subscription_terms subscription_terms_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
string PIN_FLD_NAME name
string PIN_FLD_DESCR descr
string PIN_FLD_CODE code
int PIN_FLD_TERM_LENGTH term_length
enum PIN_FLD_TERM_UNIT term_unit
timestamp PIN_FLD_START_T start_t
timestamp PIN_FLD_END_T end_t
int PIN_FLD_EARLY_TERMINATION_ALLOWED early_term_allowed
int PIN_FLD_TERMINATION_GRACE_LENGTH term_grace_length
enum PIN_FLD_TERMINATION_GRACE_UNIT term_grace_unit
poid PIN_FLD_ACCOUNT_OBJ account_obj*
poid PIN_FLD_PENALTY_OBJ penalty_obj*
int PIN_FLD_RENEW_FLAGS renew_flags
poid PIN_FLD_AUTO_RENEW_PLAN_OBJ auto_renew_plan_obj*
poid PIN_FLD_AUTO_RENEW_DEAL_OBJ auto_renew_deal_obj*
poid PIN_FLD_AUTO_RENEW_SUBS_TERMS_OBJ auto_renew_subs_terms_obj*
enum PIN_FLD_PENALTY_OPTIONS penalty_options
decimal PIN_FLD_PENALTY_AMOUNT penalty_amount
int PIN_FLD_RESOURCE_ID resource_id
int PIN_FLD_REVENUE_GLID revenue_glid
int PIN_FLD_MINIMUM_TERM_LENGTH minimum_term_length
enum PIN_FLD_MINIMUM_TERM_UNIT minimum_term_unit
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