1. Tables and Views for SCM
  2. CJM_CLAIM_TYPES_B

CJM_CLAIM_TYPES_B

This table contains claim types which is used to categorize the claims. In addition, information derived from claim types can act as the business driver for various integration points by defaulting transaction types on the claims.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CJM_CLAIM_TYPES_B_PK

CLAIM_TYPE_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CLAIM_TYPE_ID NUMBER 18 Yes Unique identifier for the claim type created in the system.
CLAIM_TYPE_GUID VARCHAR2 64 Yes Unique identifier for the claim type.
CLAIM_TYPE_CODE VARCHAR2 30 A unique identifier for the claim type that is specified by the user.
SET_ID NUMBER 18 Yes Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
ENABLED_FLAG VARCHAR2 1 Indicates if the claim type is enabled or disabled. Values are from the lookup code ORA_CJM_YES_NO.
BUY_SIDE_FLAG VARCHAR2 1 Indicates whether the claim type is enabled for the buy side or not.
SELL_SIDE_FLAG VARCHAR2 1 Indicates whether the claim type is enabled for the sell side or not.
CM_CUST_TRX_TYPE_ID NUMBER 18 Indicates the transaction type identifier for a Receivables credit memo. Obsolete
CM_CUST_TRX_TYPE_SEQ_ID NUMBER 18 Transaction type identifier for a Receivables credit memo.
INV_CUST_TRX_TYPE_SEQ_ID NUMBER 18 Transaction type identifier for a Receivables invoice.
CB_CUST_TRX_TYPE_SEQ_ID NUMBER 18 Transaction type identifier for a Chargeback.
ADJ_WO_CUST_TRX_TYPE_ID NUMBER 18 Unique receivable activity identifier associated with write-off adjustments.
RCPT_WO_CUST_TRX_TYPE_ID NUMBER 18 Unique receivable activity identifier associated with receipt write-offs.
START_DATE DATE Indicates the active date for the claim type.
END_DATE DATE Indicates the inactive date for the claim type.
SEEDED_FLAG VARCHAR2 1 Indicates whether this claim type is seeded. Values are from the lookup ORA_CJM_YES_NO. Obsolete
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of 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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. Obsolete

Foreign Keys

Table Foreign Table Foreign Key Column
cjm_claim_types_tl cjm_claim_types_b CLAIM_TYPE_ID
cjm_claim_type_bu_mappings_all cjm_claim_types_b CLAIM_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns
CJM_CLAIM_TYPES_B_U1 Unique Default CLAIM_TYPE_ID