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

Class /deposit_specification

This class holds the configurations of the deposit specifications.

Notes

  • The system will assign poid ids above 1000 to objects of this class. The range below this is reserved for creating objects with well-known poid ids.
  • 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
string PIN_FLD_CODE
int PIN_FLD_CREDIT_LIMIT_FLAG
poid PIN_FLD_DEPOSIT_SPEC_PROFILE_OBJ
string PIN_FLD_DESCR
timestamp PIN_FLD_END_T
int PIN_FLD_FLAGS
string PIN_FLD_NAME
string PIN_FLD_PERMITTED
string PIN_FLD_PERMITTED_CATEGORY
poid PIN_FLD_PRODUCT_OBJ
poid PIN_FLD_PLAN_OBJ
string PIN_FLD_PROGRAM_NAME
timestamp PIN_FLD_START_T
int PIN_FLD_DRAFT_FLAG


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

Reference to the brand account poid

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_CODE

External reference ID.

Notes

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

Links

int PIN_FLD_CREDIT_LIMIT_FLAG

PIN_DEPOSIT_CREDIT_LIMIT_INCREASE - 1 , PIN_DEPOSIT_CREDIT_LIMIT_NONE - 0

Notes

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

Links

poid PIN_FLD_DEPOSIT_SPEC_PROFILE_OBJ

Reference to deposit specification profile

Notes

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

Links

string PIN_FLD_DESCR

Description about the deposit specification

Notes

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

Links

timestamp PIN_FLD_END_T

Deposit specification Expiry date

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_FLAGS

PIN_DEPOSIT_REGULAR_BILL - 0, PIN_DEPOSIT_BILL_NOW - 1

Notes

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

Links

string PIN_FLD_NAME

Name of the Deposit specification profile

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_PERMITTED

Permitted type like /account, /service/, /plan or /device. This can be used by upstream to filter /deposit_specification

Notes

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

Links

string PIN_FLD_PERMITTED_CATEGORY

Category of deposit specification profile. This field is used to store plan_code if the permitted is /plan. This will be used by upstream to filter /deposit_specification for a plan

Notes

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

Links

poid PIN_FLD_PRODUCT_OBJ

Reference to deposit specification profile

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PLAN_OBJ

Reference to deposit Plan

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_PROGRAM_NAME

Program for which this configuration object is valid. A value of '-' indicates validity for all programs. Not enforced for Portal defined configuration objects currently.

Notes

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

Links

timestamp PIN_FLD_START_T

Deposit specification Start date

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_DRAFT_FLAG

Flag for identifing the deposit specification state (Draft - 1)

Notes

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

Links



SQL Mapping


Type Field Name Table Column Name
base-class /deposit_specification deposit_specification_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*
string PIN_FLD_CODE deposit_code
int PIN_FLD_CREDIT_LIMIT_FLAG credit_limit_flag
poid PIN_FLD_DEPOSIT_SPEC_PROFILE_OBJ deposit_spec_profile_obj*
string PIN_FLD_DESCR descr
timestamp PIN_FLD_END_T end_t
int PIN_FLD_FLAGS flags
string PIN_FLD_NAME name
string PIN_FLD_PERMITTED permitted
string PIN_FLD_PERMITTED_CATEGORY permitted_category
poid PIN_FLD_PRODUCT_OBJ product_obj*
poid PIN_FLD_PLAN_OBJ plan_obj*
string PIN_FLD_PROGRAM_NAME program_name
timestamp PIN_FLD_START_T start_t
int PIN_FLD_DRAFT_FLAG draft_flag
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