CN_TP_1001_CREDIT_UMATCHES

This table uses to store credit unique matches transaction for transaction processing

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
TRANS_OBJECT_ID NUMBER Yes PK of the source object row
WORKER_ID NUMBER Worker Number that will process this row
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
RULE_ID NUMBER FK to cn_rs_rules_all_b
ABSOLUTE_RANK NUMBER Absolute rank of the rule
EVENT_DATE DATE Event date

Foreign Keys

Table Foreign Table Foreign Key Column
CN_TP_1001_CREDIT_UMATCHES cn_rs_rules_all_b RULE_ID