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

A fold is a special type of rate used usually at the end of the accounting cycle. Typical uses are: 1. Removing remaining free hours (Define a fold that removes any free hours from the customer's balance at the end of the month). 2. Converting currencies (Create folds to convert the Infranet system currency to the customer's currency). Note that currency conversion is done real-time. 3. Exchanging one resource for another. For example, you can track the amount charged for a usage fee, and give the customer 10 free hours for every $100 of usage fees. 4. Calculating charges based on volume usage. In this case, the rate serves as a counter to tabulate usage data. The fold then applies a charge to that amount at the end of the accounting cycle. 5. Transferring resources directly from one account to another in sponsorship scenarios.

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
array PIN_FLD_BAL_IMPACTS
int
decimal
int
decimal
int
decimal
int PIN_FLD_CURRENCY
string PIN_FLD_DESCR
int PIN_FLD_ELEMENT_ID
timestamp PIN_FLD_END_T
int PIN_FLD_FLAGS
string PIN_FLD_NAME
decimal PIN_FLD_OWN_MAX
decimal PIN_FLD_OWN_MIN
decimal PIN_FLD_PRIORITY
poid PIN_FLD_PRODUCT_OBJ
timestamp PIN_FLD_RELATIVE_END_T
timestamp PIN_FLD_RELATIVE_START_T
timestamp PIN_FLD_START_T
enum PIN_FLD_ZONE


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
  • Cannot be 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_ELEMENT_ID

Numeric value of the resource to be impacted.

Notes

Links

decimal PIN_FLD_FIXED_OPERAND

Fixed Balance operand - amount to increment independent of quantity.

Notes

Links

int PIN_FLD_FLAGS

Reserved for future use.

Notes

Links

decimal PIN_FLD_FREE_QUANTITY

Free quantity - subtracted from quantity before scaled impact is applied.

Notes

Links

int PIN_FLD_GL_ID

GLID to be used when impacting the resource associated with this balance operation.

Notes

Links

decimal PIN_FLD_SCALED_OPERAND

Scaled Balance operand - amount to imcrement per unit of quantity.

Notes

Links

int PIN_FLD_CURRENCY

Numeric value of a currency resource. A value of 0 implies that this is a non-currency fold. This fold is picked if this field matches the currency of the account to which the event belongs.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_DESCR

Fold description.

Notes

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

Links

int PIN_FLD_ELEMENT_ID

Numeric value of the resource id being folded. For currency conversion folds, this would be the system currency.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

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

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_FLAGS

Balance Impact Flags. Specifies whether the impact is sponsorable (0x4).

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_NAME

Name of the fold object.

Notes

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

Links

decimal PIN_FLD_OWN_MAX

Ownership Maximum - maximum quantity owned to use this fold. Test is inclusive - quantity must be <= max. A value of PIN_NUM_MAX means no maximum limit.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_OWN_MIN

Ownership Minimum - minimum quantity owned to use this fold. Test is non-inclusive - quantity must be > min. A value of PIN_NUM_MIN means no minimum limit.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_PRIORITY

Priority - used to resolve ordering of fold application.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PRODUCT_OBJ

Link to the product object to which this rate belongs to.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_RELATIVE_END_T

Non-inclusive end time of the validity period for the fold relative to the product purchase time. If the value is 0, the fold is always valid.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_RELATIVE_START_T

Inclusive start time of the validity period for the fold relative to the product purchase time. If zero, the fold is valid immediately.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_START_T

Inclusive start time of the validity period for the fold. If zero, the fold is valid immediately.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_ZONE

Reserved for future use.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /fold fold_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*
array PIN_FLD_BAL_IMPACTS fold_bal_impacts_t
int
PIN_FLD_ELEMENT_ID
 		element_id
decimal
PIN_FLD_FIXED_OPERAND
 		fixed_operand
int
PIN_FLD_FLAGS
 		flags
decimal
PIN_FLD_FREE_QUANTITY
 		free_quantity
int
PIN_FLD_GL_ID
 		gl_id
decimal
PIN_FLD_SCALED_OPERAND
 		scaled_operand
int PIN_FLD_CURRENCY currency
string PIN_FLD_DESCR descr
int PIN_FLD_ELEMENT_ID element_id
timestamp PIN_FLD_END_T end_t
int PIN_FLD_FLAGS flags
string PIN_FLD_NAME name
decimal PIN_FLD_OWN_MAX own_max
decimal PIN_FLD_OWN_MIN own_min
decimal PIN_FLD_PRIORITY priority
poid PIN_FLD_PRODUCT_OBJ product_obj*
timestamp PIN_FLD_RELATIVE_END_T relative_end_t
timestamp PIN_FLD_RELATIVE_START_T relative_start_t
timestamp PIN_FLD_START_T start_t
enum PIN_FLD_ZONE zone
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