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

This object contains details of the remittance calculation for service providers. The object is created by running the pin_remittance batch program. Note that an object is created for a provider each time when the remittance calculation is run.

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
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
decimal PIN_FLD_AMOUNT
string PIN_FLD_REMIT_TYPE
array PIN_FLD_REMITTANCE_DETAILS
poid
decimal
poid
decimal
enum


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

The service provider account poid.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_START_T

Time of previous remittance calculation.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

Time of current remittance calculation.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_AMOUNT

The amount calculated for this account in this run of remittance.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_REMIT_TYPE

The remittance type - B (Billed), U (Billed or Unbilled), P (Paid).

Notes

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

Links

array PIN_FLD_REMITTANCE_DETAILS

Details of events and amounts.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_EVENT_OBJ

The poid of the remittance event.

Notes

Links

decimal PIN_FLD_AMOUNT

The currency impact of the event.

Notes

Links

poid PIN_FLD_PRODUCT_OBJ

The product used by the above event.

Notes

Links

decimal PIN_FLD_QUANTITY

The quantity passed for the remittance event.

Notes

Links

enum PIN_FLD_UNIT

The unit of the quantity. Value can be NONE(0), SECOND(1), MINUTE(2), HOUR(3) or DAY (4), BYTE (11), KBYTE (12), MBYTE (13) or GBYTE(14) as defined in pin_rate.h

Notes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /remittance_calculation remit_calc_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*
timestamp PIN_FLD_START_T start_t
timestamp PIN_FLD_END_T end_t
decimal PIN_FLD_AMOUNT amount
string PIN_FLD_REMIT_TYPE remit_type
array PIN_FLD_REMITTANCE_DETAILS remit_calc_detail_t
poid
PIN_FLD_EVENT_OBJ
 		event_obj*
decimal
PIN_FLD_AMOUNT
 		amount
poid
PIN_FLD_PRODUCT_OBJ
 		product_obj*
decimal
PIN_FLD_QUANTITY
 		quantity
enum
PIN_FLD_UNIT
 		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