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

Class /purchased_deposit

Class that stores information about a purchased deposit for an account.

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
decimal PIN_FLD_AMOUNT_RELEASED
decimal PIN_FLD_BALANCE_AMOUNT
poid PIN_FLD_BILLINFO_OBJ
string PIN_FLD_CODE
decimal PIN_FLD_DEPOSIT_AMOUNT
decimal PIN_FLD_DEPOSIT_INTEREST_AMOUNT
poid PIN_FLD_DEPOSIT_SPEC_OBJ
array PIN_FLD_EVENTS
poid
enum PIN_FLD_INTEREST_ACCRUAL
timestamp PIN_FLD_LAST_INTEREST_CALC_T
timestamp PIN_FLD_NEXT_INTEREST_CALC_T
poid PIN_FLD_OFFERING_OBJ
decimal PIN_FLD_RECVD
enum PIN_FLD_RELEASE_TYPE
poid PIN_FLD_SERVICE_OBJ
timestamp PIN_FLD_VALIDITY_END_T
timestamp PIN_FLD_VALIDITY_START_T
poid PIN_FLD_PARENT
int PIN_FLD_END_DETAILS


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

/account poid

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_AMOUNT_RELEASED

Deposit amount released

Notes

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

Links

decimal PIN_FLD_BALANCE_AMOUNT

Sum of PIN_FLD_RECVD, PIN_FLD_DEPOSIT_INTEREST_AMOUNT, PIN_FLD_AMOUNT_RELEASED.

Notes

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

Links

poid PIN_FLD_BILLINFO_OBJ

/billinfo poid

Notes

  • Required on object creation
  • Can be modified

Links

string PIN_FLD_CODE

External Ref ID.

Notes

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

Links

decimal PIN_FLD_DEPOSIT_AMOUNT

Deposit Amount

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_DEPOSIT_INTEREST_AMOUNT

Interest Amount.

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_OBJ

Poid reference of deposit_spec object.

Notes

  • Required on object creation
  • Can be modified

Links

array PIN_FLD_EVENTS

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_EVENT_OBJ

Stores the event poid for deposits. Sample are 0.0.0.1 /event/billing/item/tranfer 12367 or 0.0.0.1 /event/billing/deposit_interest 12321 or /event/billing/item/refund 4356787 or /event/billing/payment/* 12321 or /event/billing/deposit/transfer 4532456

Notes

Links

enum PIN_FLD_INTEREST_ACCRUAL

PIN_DEPOSIT_INTEREST_PAYABLE - 1, PIN_DEPOSIT_INTEREST_NOT_PAYABLE - 0

Notes

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

Links

timestamp PIN_FLD_LAST_INTEREST_CALC_T

Last interest calculation date.

Notes

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

Links

timestamp PIN_FLD_NEXT_INTEREST_CALC_T

Next interest calculation date.

Notes

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

Links

poid PIN_FLD_OFFERING_OBJ

Reference to /purchased_product poid.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_RECVD

Deposit Amount Received

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_RELEASE_TYPE

Prepayment or Refund

Notes

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

Links

poid PIN_FLD_SERVICE_OBJ

/service poid

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_VALIDITY_END_T

Deposit End Date. This is the date after which deposit can be released.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_VALIDITY_START_T

Deposit Start Date

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_PARENT

Link to parent purchased deposit object. This is set when deposit amount is updated.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_END_DETAILS

This is an encoded field holding mode, unit and offset. Mode is always relative (4) occupying 8 bits starting from LSB. Unit can be months (0), days (1), weeks (2) and years (3), occupying 4 bits after mode. Offset is the value for unit, occupying 20 bits after unit.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /purchased_deposit purchased_deposit_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*
decimal PIN_FLD_AMOUNT_RELEASED amount_released
decimal PIN_FLD_BALANCE_AMOUNT balance_amount
poid PIN_FLD_BILLINFO_OBJ billinfo_obj*
string PIN_FLD_CODE code
decimal PIN_FLD_DEPOSIT_AMOUNT deposit_amount
decimal PIN_FLD_DEPOSIT_INTEREST_AMOUNT deposit_interest_amount
poid PIN_FLD_DEPOSIT_SPEC_OBJ deposit_spec_obj*
array PIN_FLD_EVENTS purchased_deposit_event_t
poid
PIN_FLD_EVENT_OBJ
 		event_obj*
enum PIN_FLD_INTEREST_ACCRUAL interest_accrual
timestamp PIN_FLD_LAST_INTEREST_CALC_T last_interest_calc_t
timestamp PIN_FLD_NEXT_INTEREST_CALC_T next_interest_calc_t
poid PIN_FLD_OFFERING_OBJ offering_obj*
decimal PIN_FLD_RECVD recvd
enum PIN_FLD_RELEASE_TYPE release_type
poid PIN_FLD_SERVICE_OBJ service_obj*
timestamp PIN_FLD_VALIDITY_END_T validity_end_t
timestamp PIN_FLD_VALIDITY_START_T validity_start_t
poid PIN_FLD_PARENT parent*
int PIN_FLD_END_DETAILS end_details
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