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

Class /audit_account_products

The audit_account_products object is OBSOLETE and objects of this type are no longer created in Infranet release 6.7 and above.During upgradation from lower versions of Infranet to Infranet 6.7 and above ,the audit_account_products will have existing old data pertaining to lower release ,this data will be used for re-rating of old events . This object is used to save obsoleted account product for one account.It has most fields in the account products array in /account object except the PIN_FLD_LAST_MODIFIED_T and it has extra fields to mark the effective time of this product within the account. When re-rating an event or rating a backdated event, products which are effective at the event time will be used as the account products.

Notes

  • The system will assign poid ids above 1000 to objects of this class. The range below this is reserved for creating objects with well-known poid ids.
  • 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_EFFECTIVE_START_T
timestamp PIN_FLD_EFFECTIVE_END_T
decimal PIN_FLD_CYCLE_DISCOUNT
decimal PIN_FLD_CYCLE_DISC_AMT
decimal PIN_FLD_CYCLE_FEE_AMT
timestamp PIN_FLD_CYCLE_END_T
timestamp PIN_FLD_CYCLE_START_T
poid PIN_FLD_DEAL_OBJ
string PIN_FLD_NODE_LOCATION
string PIN_FLD_DESCR
int PIN_FLD_FLAGS
timestamp PIN_FLD_SMC_START_T
timestamp PIN_FLD_SMC_END_T
timestamp PIN_FLD_MMC_END_T
timestamp PIN_FLD_MMC_START_T
int PIN_FLD_MMC_TYPE
poid PIN_FLD_PLAN_OBJ
poid PIN_FLD_PRODUCT_OBJ
decimal PIN_FLD_PURCHASE_DISCOUNT
decimal PIN_FLD_PURCHASE_DISC_AMT
decimal PIN_FLD_PURCHASE_FEE_AMT
timestamp PIN_FLD_PURCHASE_END_T
timestamp PIN_FLD_PURCHASE_START_T
decimal PIN_FLD_QUANTITY
poid PIN_FLD_SERVICE_OBJ
poid PIN_FLD_SPONSOR_OBJ
enum PIN_FLD_STATUS
int PIN_FLD_STATUS_FLAGS
decimal PIN_FLD_USAGE_DISCOUNT
timestamp PIN_FLD_USAGE_END_T
timestamp PIN_FLD_USAGE_START_T
int PIN_FLD_CYCLE_FEE_FLAGS


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 object which owns this product.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_EFFECTIVE_START_T

Start time of all below information is valid for this account.

Notes

  • Required on object creation
  • Can be modified

Links

timestamp PIN_FLD_EFFECTIVE_END_T

End time of all below information is valid for this account.

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_CYCLE_DISCOUNT

Percentage discount for cycle fees. Stored as fractional discount between 0 and 1.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_CYCLE_DISC_AMT

Fixed amount discount for cycle fees. Amount is in primary currency of account. Amount is subtracted from cycle fee event but discount will at most reduce cost of cycle fee to zero.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_CYCLE_FEE_AMT

Cycle fee (both forward and arrears) be applied for this product. Amount specified here will override the price specified in the /rate object

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_CYCLE_END_T

Date to stop charging cycle fees for product. Product remains active in account but cycle fees are waived after this date. Zero means do not stop charging cycle fees.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_CYCLE_START_T

Date to start charging cycle fees for product. Product can be active in account but cycle fees are waived until this date.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_DEAL_OBJ

Link to deal object that was purchased containing this product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_NODE_LOCATION

Lineage information for the product. This is of the form deal-id:product-id. Refer the /products array in the account object for more details

Notes

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

Links

string PIN_FLD_DESCR

Notes

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

Links

int PIN_FLD_FLAGS

Internal state flags for tracking delayed fees that have been charged.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_SMC_START_T

Start date that single-month cycle fee should be charged.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_SMC_END_T

End date that single-month cycle fee should be charged.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_MMC_END_T

Date that current multi-month cycle ends and the multi-month cycle fee should be charged again if necessary.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_MMC_START_T

Date that current multi-month cycle started.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_MMC_TYPE

Type of multi-month cycle currently in progress. Legal values are None (0), Monthly (1), Bimonthly (2), Quarterly (3), Semiannual (6), Annual (12).

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PLAN_OBJ

Link to plan object that was purchased containing this product. NULL means product was purchased at deal level only.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PRODUCT_OBJ

Link to subscription product object that is represented by this element.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_PURCHASE_DISCOUNT

Percentage discount for purchase and cancellation fees. Stored as fractional discount between 0 and 1.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_PURCHASE_DISC_AMT

Fixed amount discount for purchase and cancellation fees. Amount is in primary currency of account. Amount is subtracted from event but discount will at most reduce cost of cycle fee to zero.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_PURCHASE_FEE_AMT

Purchase fee be applied for this product. Amount specified here will override the price specified in the /rate object

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_PURCHASE_END_T

Date when the product is no longer valid for use.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_PURCHASE_START_T

Date when the product is valid for use. Purchase fees are applied on this date.

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_QUANTITY

Quantity of product owned. Quantity is used in assessing purchase, cycle and cancellation fees.

Notes

  • Required on object creation
  • Can be modified

Links

poid PIN_FLD_SERVICE_OBJ

Link to service object that owns this subscription product. NULL means the product is owned by the account, not by a specific service object.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_SPONSOR_OBJ

Link to sponsorship group for this subscription product. NULL means product is not sponsored.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_STATUS

Status of this subscription product. Legal values are ACTIVE (10100) and INACTIVE (10102). Only active products are assessed cycle fees and participate in usage rating.

Notes

  • Required on object creation
  • Can be modified

Links

int PIN_FLD_STATUS_FLAGS

Modifier flags for product status. Used to track states of PENDING during provisioning workflow. Flags are customer-definable.

Notes

  • Required on object creation
  • Can be modified

Links

decimal PIN_FLD_USAGE_DISCOUNT

Percentage discount for usage events rated by this product. Stored as fractional discount between 0 and 1. There is no fixed amount discount for usage because different types of usage may be rated by one product.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_USAGE_END_T

Date that this product stops rating usage events. Product may remain active in account, but usage rates from this product will not be used past this date.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_USAGE_START_T

Date that this product begins rating usage events. Before this date, product may be active in account but no usage rates from the product will be used to rate usage events.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_CYCLE_FEE_FLAGS

Internal flags for tracking cycle forward fees. Each cycle forward category has its own bit. Initially all flags will be zero. As soon as some of the cycle forward category will be applied for the first time the corresponding flag will be set to 1.

Notes

  • Can be specified on object creation
  • Can be modified

Links



SQL Mapping


Type Field Name Table Column Name
base-class /audit_account_products audit_account_products_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_EFFECTIVE_START_T effective_start_t
timestamp PIN_FLD_EFFECTIVE_END_T effective_end_t
decimal PIN_FLD_CYCLE_DISCOUNT cycle_discount
decimal PIN_FLD_CYCLE_DISC_AMT cycle_disc_amt
decimal PIN_FLD_CYCLE_FEE_AMT cycle_fee_amt
timestamp PIN_FLD_CYCLE_END_T cycle_end_t
timestamp PIN_FLD_CYCLE_START_T cycle_start_t
poid PIN_FLD_DEAL_OBJ deal_obj*
string PIN_FLD_NODE_LOCATION node_location
string PIN_FLD_DESCR descr
int PIN_FLD_FLAGS flags
timestamp PIN_FLD_SMC_START_T smc_start_t
timestamp PIN_FLD_SMC_END_T smc_end_t
timestamp PIN_FLD_MMC_END_T mmc_end_t
timestamp PIN_FLD_MMC_START_T mmc_start_t
int PIN_FLD_MMC_TYPE mmc_type
poid PIN_FLD_PLAN_OBJ plan_obj*
poid PIN_FLD_PRODUCT_OBJ product_obj*
decimal PIN_FLD_PURCHASE_DISCOUNT purchase_discount
decimal PIN_FLD_PURCHASE_DISC_AMT purchase_disc_amt
decimal PIN_FLD_PURCHASE_FEE_AMT purchase_fee_amt
timestamp PIN_FLD_PURCHASE_END_T purchase_end_t
timestamp PIN_FLD_PURCHASE_START_T purchase_start_t
decimal PIN_FLD_QUANTITY quantity
poid PIN_FLD_SERVICE_OBJ service_obj*
poid PIN_FLD_SPONSOR_OBJ sponsor_obj*
enum PIN_FLD_STATUS status
int PIN_FLD_STATUS_FLAGS status_flags
decimal PIN_FLD_USAGE_DISCOUNT usage_discount
timestamp PIN_FLD_USAGE_END_T usage_end_t
timestamp PIN_FLD_USAGE_START_T usage_start_t
int PIN_FLD_CYCLE_FEE_FLAGS cycle_fee_flags
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