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

Class /billing_simulation

Billing_simulation objects contain the data of the simulated bill such as billinfo, item charges, total amount, bill object simulated offer object with which the new charges are simulated

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
poid PIN_FLD_BILLINFO_OBJ
poid PIN_FLD_AR_BILLINFO_OBJ
poid PIN_FLD_BILL_OBJ
poid PIN_FLD_AR_BILL_OBJ
poid PIN_FLD_AR_BILL_SIMULATION_OBJ
poid PIN_FLD_JOB_OBJ
string PIN_FLD_IDENTIFICATION_CODE
string PIN_FLD_CORRELATION_ID
decimal PIN_FLD_CURRENT_TOTAL
decimal PIN_FLD_SUBORDS_TOTAL
array PIN_FLD_ITEMS
poid
decimal
string
decimal
array PIN_FLD_PLAN
poid
array PIN_FLD_DEALS
poid
array PIN_FLD_PRODUCTS
poid
array PIN_FLD_DISCOUNTS
poid


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 the Account Object to which this object belongs

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_BILLINFO_OBJ

Link to the billinfo Object to which this object belongs

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AR_BILLINFO_OBJ

This is a link to the A/R billinfo. For a single billinfo, there is no A/R. In this case, this field is the same as the billinfo POID. This field is used for picking up subordinate billinfos during billing.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_BILL_OBJ

Link to the bill object for which the simulation is generated.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AR_BILL_OBJ

Link to the AR bill object. For a singlebill there is no A/R. In this case, this field is the same as the bill POID. This field is used for picking up subordinate bills during billing.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_AR_BILL_SIMULATION_OBJ

Link to the AR billing simulation object. For a singlebilling simulation there is no A/R. In this case, this field is the same as the billing simulation POID. This field is used for picking up subordinate bills during billing.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_JOB_OBJ

Link to the /job/simulation object.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_IDENTIFICATION_CODE

Unique identifier to identify the billing simulation

Notes

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

Links

string PIN_FLD_CORRELATION_ID

Correlation id passed by an external system to BRM.

Notes

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

Links

decimal PIN_FLD_CURRENT_TOTAL

Total charges from items directly owned by this object

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_SUBORDS_TOTAL

Total charges from items owned by subordinate bill.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_ITEMS

Array of items impacted during billing simulation

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_ITEM_OBJ

Item object impacted in the billing simulation

Notes

Links

decimal PIN_FLD_ITEM_TOTAL

Total A/R that this item represents. Equal to the sum of all currency impacts in events that point to this item. Total field is updated in real-time, so even pending items have a running total.

Notes

Links

string PIN_FLD_TAX_DATA

This field holds tax related information of the item. It consists of the tax code, amount taxed, tax, amount tax adjusted and the tax received

Notes

Links

decimal PIN_FLD_DISCOUNT

The discount applied to this balance impact.

Notes

Links

array PIN_FLD_PLAN

Array of plans overridden during billing simulation

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PLAN_OBJ

Plan object used in the billing simulation

Notes

Links

array PIN_FLD_DEALS

Array of deals overridden during billing simulation

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_DEAL_OBJ

Deal object used in the billing simulation

Notes

Links

array PIN_FLD_PRODUCTS

Array of products overridden during billing simulation

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_PRODUCT_OBJ

Product object used in the billing simulation

Notes

Links

array PIN_FLD_DISCOUNTS

Array of discounts overridden during billing simulation

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_DISCOUNT_OBJ

Discount object used in the billing simulation

Notes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /billing_simulation billing_simulation_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*
poid PIN_FLD_AR_BILLINFO_OBJ ar_billinfo_obj*
poid PIN_FLD_BILL_OBJ bill_obj*
poid PIN_FLD_AR_BILL_OBJ ar_bill_obj*
poid PIN_FLD_AR_BILL_SIMULATION_OBJ ar_bill_simulation_obj*
poid PIN_FLD_JOB_OBJ job_obj*
string PIN_FLD_IDENTIFICATION_CODE identification_code
string PIN_FLD_CORRELATION_ID correlation_id
decimal PIN_FLD_CURRENT_TOTAL current_total
decimal PIN_FLD_SUBORDS_TOTAL subords_total
array PIN_FLD_ITEMS billing_simulation_item_t
poid
PIN_FLD_ITEM_OBJ
 		item_obj*
decimal
PIN_FLD_ITEM_TOTAL
 		item_total
string
PIN_FLD_TAX_DATA
 		tax_data
decimal
PIN_FLD_DISCOUNT
 		discount
array PIN_FLD_PLAN billing_simulation_plan_t
poid
PIN_FLD_PLAN_OBJ
 		plan_obj*
array PIN_FLD_DEALS billing_simulation_deal_t
poid
PIN_FLD_DEAL_OBJ
 		deal_obj*
array PIN_FLD_PRODUCTS billing_simulation_product_t
poid
PIN_FLD_PRODUCT_OBJ
 		product_obj*
array PIN_FLD_DISCOUNTS billing_simulation_discount_t
poid
PIN_FLD_DISCOUNT_OBJ
 		discount_obj*
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