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

Class /event/notification/account_management/billing_account/state_change

The /event/notification/account_management/billing_account/state_change is generated when a billing_account resource is changed in database

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
array PIN_FLD_RESULTS
poid
timestamp
string
int
enum
string
string
string
string
enum
string
enum
string
string
string
string
array
string
string
string
string
string
string
string
string
string
array3
array
poid
string
string
string
string
string
array
string
substruct
substruct
array
poid
poid
poid
string
string
array3
array3
array3
int
enum
poid
enum
enum
enum
int
array3
array
string
string
string
timestamp
timestamp
string
array3
substruct


Field Details

array PIN_FLD_RESULTS

Stores the billing_account related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_POID

Unique identifier of the billing account whose details are being modified or notified in this event.

Notes

Links

timestamp PIN_FLD_MOD_T

Timestamp indicating when the billing account was last modified and the event was generated.

Notes

Links

string PIN_FLD_ACCOUNT_NO

Account number associated with the billing account for which the event notification is triggered.

Notes

Links

int PIN_FLD_ATTRIBUTE

Attribute field to determine if this is a remittance account or not.

Notes

Links

enum PIN_FLD_ACCOUNT_TYPE

Specifies the type of the billing account.

Notes

Links

string PIN_FLD_GL_SEGMENT

Indicates the General Ledger segment associated with the billing account.

Notes

Links

string PIN_FLD_CUSTOMER_SEGMENT_LIST

Specifies the customer segment or grouping assigned to the billing account.

Notes

Links

string PIN_FLD_LOCALE

Preferred locale for account. This field is used by Billing system applications. This may be used to drive UI in self-care web pages. The format is based on ISO 639 which is a 3 letter locale code, first two letters indicate the language and the third letter indicates the sub-language. For example, the locale code for US English is ENU.

Notes

Links

string PIN_FLD_NAME

Stores the display name or label assigned to the billing account for identification.

Notes

Links

enum PIN_FLD_STATUS

Indicates the current status of the billing account

Notes

Links

string PIN_FLD_VAT_CERT

Stores the VAT certificate number or reference associated with the billing account.

Notes

Links

enum PIN_FLD_BUSINESS_TYPE

Enumeration used to identify the type of account. Currently there are two business types, consumer (1) or business (2). This allows for the policy validation decisions to be based on the account type.

Notes

Links

string PIN_FLD_DESCR

Provides a descriptive text or remarks associated with the billing account.

Notes

Links

string PIN_FLD_IDENTIFICATION_CODE

Identification code

Notes

Links

string PIN_FLD_CURRENCY_NAME

Primary currency of the account

Notes

Links

string PIN_FLD_CURRENCY_SECONDARY_NAME

Secondary currency of the account

Notes

Links

array PIN_FLD_NAMEINFO

Stores account holder identification and contact-related information for the billing account.

Notes

Links

string PIN_FLD_CONTACT_TYPE

Defines the type of contact

Notes

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

Links

string PIN_FLD_FIRST_CANON

Stores the standardized or canonicalized version of the customer's first name for consistent billing records.

Notes

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

Links

string PIN_FLD_FIRST_NAME

Stores the customer's first name as provided for the billing account.

Notes

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

Links

string PIN_FLD_LAST_CANON

Stores the standardized or canonicalized version of the customer's last name for consistent billing records.

Notes

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

Links

string PIN_FLD_LAST_NAME

Stores the customer's last name as provided for the billing account.

Notes

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

Links

string PIN_FLD_MIDDLE_CANON

Stores the canonicalized or standardized version of the customer’s middle name for consistent billing processing.

Notes

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

Links

string PIN_FLD_MIDDLE_NAME

Stores the customer’s middle name as provided for the billing account.

Notes

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

Links

string PIN_FLD_SALUTATION

Stores the customer’s salutation or title (e.g., Mr., Ms., Dr.) associated with the billing account holder.

Notes

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

Links

string PIN_FLD_TITLE

Stores the customer's title or designation (e.g., Manager, Director) as part of the billing account information.

Notes

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

Links

array3 PIN_FLD_DATA_ARRAY

Stores the billing_account related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_RELATED_PARTY

Stores the bill structure related information.

Notes

Links

poid PIN_FLD_POID

Stores the unique identifier (POID) of the related party record linked to the billing account.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_ROLE_STR

Stores the role of the related party in relation to the billing account (e.g., owner, payer, contact person).

Notes

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

Links

string PIN_FLD_IDENTIFICATION_CODE

Stores the identification code associated with the related party (e.g., customer ID, partner ID).

Notes

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

Links

string PIN_FLD_NAME

Stores the name of the related party connected to the billing account.

Notes

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

Links

string PIN_FLD_REF_PARTY_ID_CODE

Stores the identification code of the reference party associated with the billing account.

Notes

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

Links

string PIN_FLD_REF_PARTY

Stores the name or identifier of the reference party linked to the billing account.

Notes

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

Links

array PIN_FLD_ACCOUNT_RELATIONSHIP

Stores the Account relationship related information.

Notes

Links

string PIN_FLD_TYPE_STR

Stores the type of relationship between the bill structure of current account and the related account (supported values, AR, Parent).

Notes

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

Links

substruct PIN_FLD_BILL_STRUCTURE

Bill structure related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_ACCOUNT

billing_account related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_BILL_STRUCTURE_INFO

Stores the bill structure related information.

Notes

Links

poid PIN_FLD_POID

Stores the unique identifier (POID) of the bill structure record associated with the billing account.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_ACCOUNT_OBJ

Stores the POID of the account object linked to this bill structure information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_BILLINFO_OBJ

Stores the POID of the billinfo object associated with this bill structure entry.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_IDENTIFICATION_CODE

Stores the identification code associated with the bill structure entry.

Notes

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

Links

string PIN_FLD_NAME

Stores the name or label assigned to this bill structure entry.

Notes

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

Links

array3 PIN_FLD_BILL_PRESENTATION_MEDIA

Stores the bill presentation media related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_BILL_FORMAT

Stores the bill format related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_CYCLE_INFO

Stores the bill cycle related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_BILLING_STATUS_FLAGS

Reason for changing of BILLING_STATUS. Legal values are PIN_BILL_FLAGS_DUE_TO_STOP_BILL_CLOSE_ACCT (0x01), PIN_BILL_FLAGS_DUE_TO_RESUME_BILLING (0x02), PIN_BILL_FLAGS_DUE_TO_STOP_BILL_CLOSE_ACCT_SUBORD (0x04), PIN_BILL_FLAGS_DUE_TO_BILLING (0x08), PIN_BILL_FLAGS_DUE_TO_SUBORD_BILLING (0x10), PIN_BILL_FLAGS_DUE_TO_SPONSOREE_BILLING (0x20), PIN_BILL_FLAGS_DUE_TO_MIGRATION (0x40), PIN_BILL_FLAGS_DUE_TO_CUSTOMER_REQUEST (0x80), PIN_BILL_FLAGS_CF_ERROR (0x100), PIN_BILL_FLAGS_DEF_CF_ERROR (0x200), PIN_BILL_FLAGS_DEF_PURCHASE_ERROR (0x400), PIN_BILL_FLAGS_DEF_CANCEL_ERROR (0x800), PIN_BILL_FLAGS_CF_NOT_APPLIED (0x1000), PIN_BILL_FLAGS_UPDATE_JOURNALS_ERROR (0x2000), PIN_BILL_FLAGS_UPDATE_ITEMS_ERROR (0x4000), PIN_BILL_FLAGS_STOP_BILLING_PATCH_ONHOLD_STATE (0x10000), PIN_BILL_FLAGS_RESUME_BILLING_PATCH_INPROGRESS_STATE (0x20000).

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_BILLING_STATUS

Used to track the billing status of a billinfo. Legal values are PIN_BILL_ACTIVE - indicates that billing should be provided for the account in a standard (regular) way. This is a default value. PIN_BILL_INACTIVE - indicates that billing should be suspended for the billinfo. PIN_BILL_ERROR - indicates that an error occurred when the billing application tried to bill this billinfo. If an error occurs for a subordinate billinfo, the parent billinfo's status will also be set to PIN_BILL_ERROR.

Notes

  • Can be specified on object creation
  • Can be modified

Links

poid PIN_FLD_BUSINESS_PROFILE_OBJ

Stores the POID of the business profile object associated with this billing account.

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_ACTG_TYPE

Accounting type for this billinfo. The legal values are PIN_ACTG_TYPE_OPEN_ITEMS (1) and PIN_ACTG_TYPE_BALANCE_FORWARD (2).

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_PAY_TYPE

Stores the payment type associated with the account (e.g., credit card, cash, direct debit).

Notes

  • Can be specified on object creation
  • Can be modified

Links

enum PIN_FLD_BILLING_SEGMENT

A billing segment ID for the billinfo. This is a user-defined category, such as wholesale, retail, or senior citizen, that controls the accounting DOMs to which a billinfo can be assigned, and allows to load-balance billing operations more effectively.

Notes

  • Can be specified on object creation
  • Can be modified

Links

int PIN_FLD_ACCT_SUPPRESSED

Used for manual account suppresion.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array3 PIN_FLD_BALANCE_GROUPS

Stores the billing_account related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

array PIN_FLD_EXEMPTIONS

List of tax exemptions

Notes

Links

string PIN_FLD_IDENTIFICATION_CODE

Stores the identification code associated with the exemption being applied to the account.

Notes

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

Links

string PIN_FLD_ISSUING_JURISDICTION

Stores the jurisdiction or authority under which the exemption is issued (e.g., state, region, tax authority).

Notes

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

Links

string PIN_FLD_REASON_CODE

Stores the reason code indicating why the exemption was granted.

Notes

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

Links

timestamp PIN_FLD_START_T

Stores the timestamp indicating when the exemption becomes effective.

Notes

  • Can be specified on object creation
  • Can be modified

Links

timestamp PIN_FLD_END_T

Stores the timestamp indicating when the exemption expires or becomes inactive.

Notes

  • Can be specified on object creation
  • Can be modified

Links

string PIN_FLD_CERTIFICATE_NUM

Stores the certificate or document number used to authorize or validate the exemption.

Notes

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

Links

array3 PIN_FLD_TAX_DEFINITION

Stores the Tax related information.

Notes

  • Can be specified on object creation
  • Can be modified

Links

substruct PIN_FLD_EVENT_INFO

Stores the billing_account related information.

Notes

Links



SQL Mapping

Links


PIN_FLD_DATA_ARRAY
Stores the billing_account related information.
PIN_FLD_BILL_PRESENTATION_MEDIA
Stores the bill presentation media related information.
PIN_FLD_BILL_FORMAT
Stores the bill format related information.
PIN_FLD_CYCLE_INFO
Stores the bill cycle related information.
PIN_FLD_BALANCE_GROUPS
Stores the billing_account related information. PIN_FLD_LIMIT Stores the billing_account related information. PIN_FLD_TEMP_LIMIT Stores the billing_account related information. PIN_FLD_RULES Stores rules that define how credit is consumed or applied for the balance group.
PIN_FLD_TAX_DEFINITION
Stores the Tax related information.
Type Field Name Table Column Name
derived-class /event/notification/account_management/billing_account/state_change
array PIN_FLD_RESULTS
poid
PIN_FLD_POID
timestamp
PIN_FLD_MOD_T
string
PIN_FLD_ACCOUNT_NO
int
PIN_FLD_ATTRIBUTE
enum
PIN_FLD_ACCOUNT_TYPE
string
PIN_FLD_GL_SEGMENT
string
PIN_FLD_CUSTOMER_SEGMENT_LIST
string
PIN_FLD_LOCALE
string
PIN_FLD_NAME
enum
PIN_FLD_STATUS
string
PIN_FLD_VAT_CERT
enum
PIN_FLD_BUSINESS_TYPE
string
PIN_FLD_DESCR
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_CURRENCY_NAME
string
PIN_FLD_CURRENCY_SECONDARY_NAME
array
PIN_FLD_NAMEINFO
string
PIN_FLD_CONTACT_TYPE
string
PIN_FLD_FIRST_CANON
string
PIN_FLD_FIRST_NAME
string
PIN_FLD_LAST_CANON
string
PIN_FLD_LAST_NAME
string
PIN_FLD_MIDDLE_CANON
string
PIN_FLD_MIDDLE_NAME
string
PIN_FLD_SALUTATION
string
PIN_FLD_TITLE
string
string
string
string
string
string
string
string
string
enum
string
string
string
array
PIN_FLD_RELATED_PARTY
poid
PIN_FLD_POID
string
PIN_FLD_ROLE_STR
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_NAME
string
PIN_FLD_REF_PARTY_ID_CODE
string
PIN_FLD_REF_PARTY
array
PIN_FLD_ACCOUNT_RELATIONSHIP
string
PIN_FLD_TYPE_STR
substruct
string
PIN_FLD_NAME
string
PIN_FLD_IDENTIFICATION_CODE
poid
PIN_FLD_POID
substruct
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_ACCOUNT_NO
poid
PIN_FLD_POID
substruct
PIN_FLD_BILL_STRUCTURE
string
PIN_FLD_NAME
string
PIN_FLD_IDENTIFICATION_CODE
poid
PIN_FLD_POID
array
PIN_FLD_BILL_STRUCTURE_INFO
poid
PIN_FLD_POID
poid
PIN_FLD_ACCOUNT_OBJ
poid
PIN_FLD_BILLINFO_OBJ
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_NAME
string
string
string
poid
string
string
string
poid
int
int
int
string
string
string
poid
int
PIN_FLD_BILLING_STATUS_FLAGS
enum
PIN_FLD_BILLING_STATUS
poid
PIN_FLD_BUSINESS_PROFILE_OBJ
enum
PIN_FLD_ACTG_TYPE
enum
PIN_FLD_PAY_TYPE
enum
PIN_FLD_BILLING_SEGMENT
int
PIN_FLD_ACCT_SUPPRESSED
poid
int
decimal
decimal
decimal
decimal
decimal
int
enum
decimal
decimal
decimal
decimal
decimal
decimal
int
string
int
int
string
int
decimal
decimal
string
decimal
string
string
string
substruct
string
PIN_FLD_UNIT_STR
int
PIN_FLD_OFFSET_VALUE
substruct
string
PIN_FLD_UNIT_STR
int
PIN_FLD_OFFSET_VALUE
string
int
array
PIN_FLD_EXEMPTIONS
string
PIN_FLD_IDENTIFICATION_CODE
string
PIN_FLD_ISSUING_JURISDICTION
string
PIN_FLD_REASON_CODE
timestamp
PIN_FLD_START_T
timestamp
PIN_FLD_END_T
string
PIN_FLD_CERTIFICATE_NUM
decimal
enum
substruct
PIN_FLD_EVENT_INFO
timestamp
PIN_FLD_START_T
string
PIN_FLD_TYPE_STR
string
PIN_FLD_EVENT_NO
string
PIN_FLD_INTERNAL_EVENT_NO
poid
PIN_FLD_POID
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