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

Class /event/notification/collections_action/post_due

The /event/notification/collections_action/post_due is sent when the pending /collections_action/* after due date is to be notified.

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
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_NAME
string PIN_FLD_PROGRAM_NAME
poid PIN_FLD_USERID
poid PIN_FLD_SESSION_OBJ
string PIN_FLD_SYS_DESCR
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
array PIN_FLD_COLLECTIONS_EXPIRY_INFO
poid
poid
timestamp
string
string
int
string
decimal
string


Field Details

poid PIN_FLD_ACCOUNT_OBJ

Poid of the /account object.

Notes

  • Required on object creation
  • Cannot be modified

Links


string PIN_FLD_NAME

The name of the notification event.

Notes

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

Links


string PIN_FLD_PROGRAM_NAME

The name of the program that generated the event.

Notes

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

Links


poid PIN_FLD_USERID

The unique ID of the user who is running the program that started the event.

Notes

  • Can be specified on object creation
  • Cannot be modified

Links


poid PIN_FLD_SESSION_OBJ

Link to the event object (/event/session) that represents the session within which this event occurred.

Notes

  • Can be specified on object creation
  • Cannot be modified

Links


string PIN_FLD_SYS_DESCR

System generated description - describes event programmatically.

Notes

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

Links


timestamp PIN_FLD_START_T

The time when the notifications event started.

Notes

  • Required on object creation
  • Can be modified

Links


timestamp PIN_FLD_END_T

The time when the notifications event ended.

Notes

  • Required on object creation
  • Can be modified

Links


array PIN_FLD_COLLECTIONS_EXPIRY_INFO

collection action due information details.

Notes

  • Required on object creation
  • Can be modified

Links


poid PIN_FLD_BILLINFO_OBJ

Poid of the /billinfo object.

Notes

Links


poid PIN_FLD_ACTION_OBJ

Poid of the /collection_action object.

Notes

Links


timestamp PIN_FLD_DUE_T

The due time when the collections_action to be executed

Notes

Links


string PIN_FLD_ACCOUNT_NO

Account Number of the respective action object.

Notes

Links


string PIN_FLD_RESOURCE_NAME

Resource Name.

Notes

Links


int PIN_FLD_RESOURCE_ID

Numeric value of the resource that is impacted.

Notes

Links


string PIN_FLD_RESOURCE_SYMBOL

Resource Symbol.

Notes

Links


decimal PIN_FLD_DUE

Due amount related to this pending action.

Notes

Links


string PIN_FLD_ACTION_NAME

The name of the collections action

Notes

Links




SQL Mapping

Links


Type Field Name Table Column Name
derived-class /event/notification/collections_action/post_due
poid PIN_FLD_ACCOUNT_OBJ
string PIN_FLD_NAME
string PIN_FLD_PROGRAM_NAME
poid PIN_FLD_USERID
poid PIN_FLD_SESSION_OBJ
string PIN_FLD_SYS_DESCR
timestamp PIN_FLD_START_T
timestamp PIN_FLD_END_T
array PIN_FLD_COLLECTIONS_EXPIRY_INFO
poid
PIN_FLD_BILLINFO_OBJ
poid
PIN_FLD_ACTION_OBJ
timestamp
PIN_FLD_DUE_T
string
PIN_FLD_ACCOUNT_NO
string
PIN_FLD_RESOURCE_NAME
int
PIN_FLD_RESOURCE_ID
string
PIN_FLD_RESOURCE_SYMBOL
decimal
PIN_FLD_DUE
string
PIN_FLD_ACTION_NAME
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