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

Class /sms_settle_report

Contains the SMS Settlement Report summary information for all SMS call detail records (CDRs).

Notes

  • The system will assign poid ids above 5000 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 anyone.
  • 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
string PIN_FLD_PROGRAM_NAME
string PIN_FLD_HOSTNAME
int PIN_FLD_TOTAL_SMS_RECORDS
int PIN_FLD_TOTAL_VOLUME
decimal PIN_FLD_TOTAL_REVENUE
timestamp PIN_FLD_SMS_DAY
string PIN_FLD_SMS_CLASS
string PIN_FLD_SMS_ORIGIN_ID
string PIN_FLD_SMS_DESTINATION_ID
string PIN_FLD_SMSC_ID


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

Poid of the Account object

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_PROGRAM_NAME

Name of the Program which is creating the audit info is generated

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 30 bytes

Links

string PIN_FLD_HOSTNAME

Process Host Name

Notes

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

Links

int PIN_FLD_TOTAL_SMS_RECORDS

Number of SMS records

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_TOTAL_VOLUME

Total volume of the SMS bytes

Notes

  • Can be specified on object creation
  • Can be modified

Links

decimal PIN_FLD_TOTAL_REVENUE

Total revenue of SMS

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_SMS_DAY

The day SMS received/send.

Notes

  • Required on object creation
  • Cannot be modified

Links

string PIN_FLD_SMS_CLASS

The class of the SMS.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 30 bytes

Links

string PIN_FLD_SMS_ORIGIN_ID

The SMS Originating Network ID.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 100 bytes

Links

string PIN_FLD_SMS_DESTINATION_ID

The SMS Destination Network ID.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 100 bytes

Links

string PIN_FLD_SMSC_ID

The SMSC Id.

Notes

  • Required on object creation
  • Cannot be modified
  • Maximum length is 30 bytes

Links



SQL Mapping


Type Field Name Table Column Name
base-class /sms_settle_report sms_settle_rpt_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*
string PIN_FLD_PROGRAM_NAME program_name
string PIN_FLD_HOSTNAME hostname
int PIN_FLD_TOTAL_SMS_RECORDS sms_records
int PIN_FLD_TOTAL_VOLUME total_volume
decimal PIN_FLD_TOTAL_REVENUE total_revenue
timestamp PIN_FLD_SMS_DAY sms_day
string PIN_FLD_SMS_CLASS sms_class
string PIN_FLD_SMS_ORIGIN_ID sms_origin_id
string PIN_FLD_SMS_DESTINATION_ID sms_destination_id
string PIN_FLD_SMSC_ID smsc_id
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