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 /installment_schedule

This class holds the installment plan details.

Notes

  • This object can be read by anyone.
  • 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_BILLINFO_OBJ
array PIN_FLD_CHARGES
poid
string PIN_FLD_CODE
string PIN_FLD_DESCR
decimal PIN_FLD_DUE
timestamp PIN_FLD_END_T
int PIN_FLD_FLAGS
array PIN_FLD_INSTALLMENTS
decimal
timestamp
poid
timestamp
string
enum
timestamp
poid PIN_FLD_INSTALLMENT_SPEC_OBJ
enum PIN_FLD_INSTALLMENT_TYPE
timestamp PIN_FLD_LAST_NOTIFICATION_T
string PIN_FLD_LAST_NOTIFICATION_OFFSET
string PIN_FLD_NAME
timestamp PIN_FLD_START_T
enum PIN_FLD_STATUS
int PIN_FLD_TERM
decimal PIN_FLD_TOTAL_AMOUNT


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

poid PIN_FLD_BILLINFO_OBJ

Billinfo poid.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_CHARGES

Array to hold the bills converted to installments.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_CHARGE_OBJ

This can have either bill poid or item poid.

Notes

Links

string PIN_FLD_CODE

Place holder to keep external code.

Notes

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

Links

string PIN_FLD_DESCR

Description of the Installment name.

Notes

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

Links

decimal PIN_FLD_DUE

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

End date of installment.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_FLAGS

Flags to indicate if the installment charge shall go to regular bill i.e 0 or a bill now bill i.e 1

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_INSTALLMENTS

Array to hold the installment details. This array repeats for number of installments.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_AMOUNT

Installment amount

Notes

Links

timestamp PIN_FLD_EFFECTIVE_T

Date on which the installment charge needs to be applied.

Notes

Links

poid PIN_FLD_ITEM_OBJ

Item poid of the /item/installment/credit or /item/installment/debit type

Notes

Links

timestamp PIN_FLD_LAST_NOTIFICATION_T

Date on which the due date notification is sent

Notes

Links

string PIN_FLD_LAST_NOTIFICATION_OFFSET

The offset with which the last time this object was processed/checked for installment due notification.

Notes

Links

enum PIN_FLD_STATUS

Status of installment (open/charged/paid/broken/cancel/finished)

Notes

Links

timestamp PIN_FLD_NOTIFICATION_DUE_T

Notification due date of installment.

Notes

Links

poid PIN_FLD_INSTALLMENT_SPEC_OBJ

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_INSTALLMENT_TYPE

Installment Type (equal/unequal)

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_LAST_NOTIFICATION_T

Date on which the end date notification is sent

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_LAST_NOTIFICATION_OFFSET

The offset with which the last time this object was processed/checked for end date notification.

Notes

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

Links

string PIN_FLD_NAME

Installment name.

Notes

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

Links

timestamp PIN_FLD_START_T

Start date of installment.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_STATUS

Status of the installment object (open/broken/cancel/finished)

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_TERM

Installment term

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_TOTAL_AMOUNT

Total Installment amount

Notes

  • Required on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /installment_schedule installment_schedule_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_BILLINFO_OBJ billinfo_obj*
array PIN_FLD_CHARGES installment_source_t
poid
PIN_FLD_CHARGE_OBJ
 		charge_obj*
string PIN_FLD_CODE code
string PIN_FLD_DESCR descr
decimal PIN_FLD_DUE due
timestamp PIN_FLD_END_T end_t
int PIN_FLD_FLAGS flags
array PIN_FLD_INSTALLMENTS installment_sch_installment_t
decimal
PIN_FLD_AMOUNT
 		amount
timestamp
PIN_FLD_EFFECTIVE_T
 		effective_t
poid
PIN_FLD_ITEM_OBJ
 		item_obj*
timestamp
PIN_FLD_LAST_NOTIFICATION_T
 		last_notification_t
string
PIN_FLD_LAST_NOTIFICATION_OFFSET
 		last_notification_offset
enum
PIN_FLD_STATUS
 		status
timestamp
PIN_FLD_NOTIFICATION_DUE_T
 		notification_due_t
poid PIN_FLD_INSTALLMENT_SPEC_OBJ installment_spec_obj*
enum PIN_FLD_INSTALLMENT_TYPE installment_type
timestamp PIN_FLD_LAST_NOTIFICATION_T last_notification_t
string PIN_FLD_LAST_NOTIFICATION_OFFSET last_notification_offset
string PIN_FLD_NAME name
timestamp PIN_FLD_START_T start_t
enum PIN_FLD_STATUS status
int PIN_FLD_TERM term
decimal PIN_FLD_TOTAL_AMOUNT amount
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