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

Class /best_pricing

Data for Best Pricing. Best Pricing defines a relationship between a deal and a set of alternate deals. It also allows definition of events for Best Pricing approximation.

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
poid PIN_FLD_DEAL_OBJ
enum PIN_FLD_APPLY_MODE
array PIN_FLD_DEALS
poid
decimal
array
int
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

Link to account object for which this object was created.

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_DEAL_OBJ

Base deal for Best Pricing consideration.

Notes

  • Required on object creation
  • Can be modified

Links

enum PIN_FLD_APPLY_MODE

Mode of Best Pricing application - full rerate (0x0), one time adjustment (0x1).

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_DEALS

Array of alternate deals for Best Pricing consideration.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_DEAL_OBJ

An alternate deal for Best Pricing consideration.

Notes

Links

decimal PIN_FLD_MINIMUM

Minimum charge for the alternate deal.

Notes

Links

array PIN_FLD_CONDITIONS

Conditions for Best Pricing consideration. If the conditions are met the deal will be considered by Best Pricing.

Notes

Links

int PIN_FLD_RESOURCE_ID

ID of resource used for the Best Pricing condition.

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_AMOUNT

Amount against which the condition will be compared.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_OPERATOR

Conditional operator -- (0x0) equal to, (0x1) not equal to, (0x2) less than, (0x3) greater than, (0x4) less than or equal to, (0x5) greater than or equal to.

Notes

  • Can be specified on object creation
  • Can be modified

Links


SQL Mapping


Type Field Name Table Column Name
base-class /best_pricing best_pricing_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_DEAL_OBJ deal_obj*
enum PIN_FLD_APPLY_MODE apply_mode
array PIN_FLD_DEALS best_pricing_deals_t
poid
PIN_FLD_DEAL_OBJ
 		deal_obj*
decimal
PIN_FLD_MINIMUM
 		minimum
array
PIN_FLD_CONDITIONS
 		best_pricing_conditions_t
int
PIN_FLD_RESOURCE_ID
resource_id
decimal
PIN_FLD_AMOUNT
amount
enum
PIN_FLD_OPERATOR
operator
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