1. Tables and Views for SCM
  2. CJM_CLAIMS_ALL

CJM_CLAIMS_ALL

This table contains claims header information. Each row in this table includes general claim information such as Customer, claim type, amount, claim settlement method, details of settlement and approvals.

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CJM_CLAIMS_ALL_PK

CLAIM_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CLAIM_ID NUMBER 18 Yes Unique identifier for a claim created in the system.
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.
CLAIM_NUMBER VARCHAR2 30 Indicates the customer-specified claim number . If not specified, the system creates a unique number.
CLAIM_CLASS_CODE VARCHAR2 30 Indicates the claim class ,derived from the lookup code ORA_CJM_CLAIM_CLASS.
BU_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
SOURCE_MAP_ID NUMBER 22 Unique identifier for the claim source map assigned to the claim. FK from table CJM_CLAIM_CLASS_SRC_MAP
LEGAL_ENTITY_ID NUMBER 18 Unique identifier for the legal entity. If an identifier is not specified, then the default legal entity of the business unit will be assigned by the system.
CLAIM_TYPE_ID NUMBER 18 Unique identifier for the claim type. If an identfier is not specified, then the claim type will be assigned by the system.
REASON_CODE_ID NUMBER 18 Unique Identifier for the reason code created in the system..
PARTY_ID NUMBER 18 Unique identifier of the party. This column is populated if the claim is created for a customer.
PARTY_SITE_USE_ID NUMBER 18 Unique identifier for the bill to party site use. This column value is derived from the party site if the claim is created for a customer.
PARTY_ADDRESS_ID NUMBER 18 Unique identifier of the party site, which stores the address associated to the party. This column value is derived from the customer bill to account site if the claim is created for a customer.
OWNER_ID NUMBER 18 Identifier for the system user who created the claim.
CLAIM_DATE DATE Yes Indicates the date when a claim is created. If no date is entered, the system date defaults.
CURRENCY_CODE VARCHAR2 15 Indicates the currency code for the transaction.
AMOUNT NUMBER Indicates the amount claimed in the transactional currency.
ACCTD_AMOUNT NUMBER Indicates the functional currency amount.
EXCHANGE_RATE_TYPE VARCHAR2 30 Indicates the currency exchange rate type.
EXCHANGE_RATE_DATE DATE Indicates the date of the exchange.
EXCHANGE_RATE NUMBER Indicates the exchange rate between claim and functional currency.
AMOUNT_REMAINING NUMBER Indicates the remaining amount.
ACCTD_AMOUNT_REMAINING NUMBER Indicates the remaining amount in the functional currency.
AMOUNT_SETTLED NUMBER Indicates the settled amount. This column will be populated once the claim is settled.
ACCTD_AMOUNT_SETTLED NUMBER Indicates the settled amount in the functional currency.
CLAIM_FOR_CODE VARCHAR2 30 Indicates the claim created for the party, the customer account, or the supplier. This value is derived from the lookup code ORA_CJM_CLAIM_FOR.
BILL_TO_CUSTOMER_ID NUMBER 18 Unique identifier for the bill-to customer account for the claim created in the system. This column is populated if the claim is created for a customer account.
BILL_TO_SITE_USE_ID NUMBER 18 Unique identifier for the bill-to site use for the selected customer account site. This column stores the bill-to business purpose that is assigned to the customer account site. Data is populated if the claim is created for a customer account.
BILL_TO_ADDRESS_ID NUMBER 18 Unique identifier for the bill-to customer account site for the selected customer account. This column stores the customer account addresses. Data is populated if the claim is created for a customer account.
BILL_TO_CONTACT_ID NUMBER 18 Unique identifier for the bill-to customer account contact role created in the system.
SHIP_TO_PARTY_ID NUMBER 18 Unique identifier of the ship-to party created in the system. Data is populated if the claim is created for a customer account.
SHIP_TO_PARTY_SITE_USE_ID NUMBER 18 Unique identifier for the party site use of the ship-to party site address created in the system.
SHIP_TO_PARTY_ADDRESS_ID NUMBER 18 Unique identifier of the party site, which stores the address associated to the party. Data is populated if the claim is created for a customer account.
SHIP_TO_PARTY_CONTACT_ID NUMBER 18 Unique identifier for the ship-to party contact created in the system.
VENDOR_ID NUMBER 18 Unique identifier for the Payables invoice supplier created in the system. This column is populated when the claim is created for a supplier.
VENDOR_SITE_ID NUMBER 18 Unique identifier for the Payables vendor site created in the system. This column is populated when the claim is created for a supplier.
CUSTOMER_REASON VARCHAR2 150 Indicates the codes for identifying the submitted claims which are passed to Receivables or Payables during the claim settlement.
CUSTOMER_REF_NUMBER VARCHAR2 100 Indicates the customer reference number. Upon interfacing to Receivables this value is passed as a customer reference in the Credit Memo field for Fusion Payables. The customer reference is the invoice number.
CUSTOMER_REF_DATE DATE Indicates the customer reference date is passed to Fusion Payables as a reference key for the invoice.
PROMOTIONAL_FLAG VARCHAR2 1 Indicates if the claim is promotional or non-promotional.
STATUS_CODE VARCHAR2 30 Indicates the status code of the claim. Values are from the lookup code ORA_CJM_CLAIM_STATUS.
USER_STATUS_ID NUMBER 18 Indicates a user-defined status for the claim corresponding to the status code value.
OPEN_USER_STATUS_ID NUMBER 18 Indicates the latest user-defined open status identifier for the claim.
PROGRAM_HEADER_ID NUMBER 18 Unique identifier for the program header created in the system.
PRIMARY_RESOURCE_SALESREP_ID NUMBER 18 Unique identifier for the primary sales person created in the system.
VOUCHER_NUMBER VARCHAR2 30 Indicates a voucher number , which is populated once the settlement method for the claim is closed in Payables.
APPROVED_DATE DATE Indicates the date when the claim was approved.
APPROVED_BY NUMBER 18 Indicates the user who approved the claim.
SETTLED_DATE DATE Indicates the claim settlement date.
SETTLED_BY NUMBER 18 Indicates the user who settled the claim.
PAYMENT_METHOD_CODE VARCHAR2 30 Indicates the claim settlement method. Values are from the lookup code ORA_CJM_PAYMENT_METHOD. Obsolete
PAYMENT_REFERENCE_ID NUMBER 18 Unique identifier for the payment reference created in the system, which is populated during the claim settlement. Values are from the Payables or the Receivables instrument's identifier. Obsolete
PAYMENT_REFERENCE_NUMBER VARCHAR2 30 Identifier for the payment reference number, which is populated during the claim settlement. Values are from the Payables or the Receivables instrument's number. Obsolete
PAYMENT_REFERENCE_DATE DATE Indicates the payment date reference instrument. Obsolete
PAYMENT_STATUS_CODE VARCHAR2 30 Indicates the claim payment status. Values are from the lookup code ORA_CJM_PAYMENT_STATUS, which includes the values Pending and Paid. Obsolete
PAYMENT_EFFECTIVE_DATE DATE Indicates the payment effective date. Obsolete
DUPLICATE_CLAIM_ID NUMBER 18 Unique identifier for a duplicate claim created in the system.
ROOT_CLAIM_ID NUMBER 18 Unique identifier for a claim that initiated the transaction.
GL_DATE DATE The date on which the claim settlement amount will be posted to General Ledger.
SOURCE_OBJECT_CLASS VARCHAR2 30 Indicates the source object class used during the claim creation. This column value is assigned internally based upon the claim source. Values are SD_SUPPLIER for claims created for Ship and Debit requests, and INVOICE for claims created from Receivables.
SOURCE_OBJECT_ID NUMBER 18 Indicates the internal identifier of the source object used during the claim creation.
SOURCE_OBJECT_TYPE_ID NUMBER 18 Indicates the source object type identifIer used during the claim creation.
SOURCE_OBJECT_NUMBER VARCHAR2 30 Indicates the source object number used during the claim creation.
SOURCE_OBJECT_DATE DATE Indicates the date of the source object.
COMMENTS CLOB Claim header level comments. Additional information about the claim can be provided here. Obsolete
CLAIM_COMMENTS VARCHAR2 4000 Claim header level comments. Additional information about the claim can be provided here.
RECEIPT_ID NUMBER 18 Cash Receipt identifier associated with the claim in Oracle Fusion Receivables.
RECEIPT_NUMBER VARCHAR2 30 Cash Receipt Number associated with the claim in Oracle Fusion Receivables.
AMOUNT_APPLIED NUMBER Amount applied on the receipt application line while creating the claim in Oracle Fusion Receivables.
AMOUNT_ADJUSTED NUMBER Amount adjusted from the parent claim when it is split.
ACCTD_AMOUNT_ADJUSTED NUMBER Adjusted amount in the ledger currency.
SPLIT_FROM_CLAIM_ID NUMBER 18 Unique identifier of the parent claim.
SPLIT_DATE DATE Indicates the date when the claim is split.
RESOLVED_DATE DATE Indicates the date when the claim is resolved and submitted for approval.
ORIGINAL_CLAIM_DATE DATE Indicates the claim date of the root claim.
CLAIM_SOURCE_CODE VARCHAR2 30 Indicates the predefined claim sources. Values are from the lookup ORA_CJM_CLAIM_SOURCE.
APPLIED_PAYMENT_SCHEDULE_ID NUMBER 18 Identifies the payment schedule of the payment applied on the Receivables receipt line.
INVOICE_BU_ID NUMBER 18 Business unit identifier of the Receivables invoice.
RECEIPT_BU_ID NUMBER 18 Business unit identifier of the Receivables receipt.
RECEIVABLE_APPLICATION_ID NUMBER 18 Identifies the receivables application of the claim investigation line.
WRITE_OFF_FLAG VARCHAR2 1 Indicates if the claim is eligible for an automatic write-off.
TAX_AMOUNT NUMBER Indicates the tax amount applied to the claim.
RECEIVABLES_TRX_ID NUMBER 18 Indicates the receivables activity identifier associated with the noninvoice deduction or overpayment.
EXTRACT_REQUEST_ID NUMBER 18 Indicates the Process ID of the scheduled process used to create the claim extract.
GROUP_CLAIM_ID NUMBER 18 Unique identifier for the group claim created in the application for mass settlement.
MASS_SETTLEMENT_NUMBER VARCHAR2 30 Unique number for mass settlement of claims.
WO_RECEIVABLES_ACTIVITY_ID NUMBER 18 Receivables activity identifier for the write-off activity.
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 1 Indicates whether tax is included in the line amount. Valid values: Y, NULL.
CB_CUST_TRX_TYPE_SEQ_ID NUMBER 18 Chargeback transaction type identifier associated with the claim. This column is populated when the claim is settled using the Chargeback settlement method.
CHARGEBACK_REASON_CODE VARCHAR2 30 Chargeback reason code associated with the claim. This is an optional column and is populated when the claim is settled using the Chargeback settlement method.
BROKER_ID NUMBER 18 Unique identifier of the broker associated with the customer claim.
SALESREP_ID NUMBER 18 Unique identifier of the sales person associated with the customer claim
REJECTED_BY NUMBER 18 Indicates the identifier of the user who rejected the claim.
REJECTED_DATE DATE Indicates the date when the claim was rejected.
MASS_ACTION_TYPE_CODE VARCHAR2 30 Indicates the mass action type. The value is derived from the lookup type ORA_CJM_MASS_CLM_ACTION_TYPE.
PROCESSING_MODE_CODE VARCHAR2 30 Indicates the processing mode for the mass claim. The value is derived from the lookup type ORA_CJM_MASS_CLM_MODE.
BPM_APPROVAL_INITIATED_FLAG VARCHAR2 1 Indicates if BPM approval is initiated for this claim.
COMMENTS_FOR_APPROVERS VARCHAR2 4000 Comments submitted to provide additional information to the approvers.
PAY_OVER_THRESHOLD_EXCEEDED VARCHAR2 1 Indicates that claim is associated with pay over earnings and that the associated amount exceeds the pay over threshold limit.
OWNER_USER_ID NUMBER 18 Indicates the value for the OWNER_ID before data migration. This is identifier for the system user who created the claim.
SOURCE_CLAIM_SYSTEM VARCHAR2 240 Indicates the third party system from which the claim is interfaced.
SOURCE_CLAIM_NUMBER VARCHAR2 240 Indicates the third party system claim number from which the claim is interfaced.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
ATTRIBUTE_CHAR1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CHAR20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER 22 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
CUSTOMER_ATTRIBUTE_CATEGORY VARCHAR2 30 Customer Claim Descriptive Flexfield: structure definition of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR1 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR2 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR3 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR4 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR5 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR6 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR7 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR8 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR9 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR10 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR11 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR12 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR13 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR14 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR15 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR16 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR17 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR18 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR19 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_CHAR20 VARCHAR2 150 Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER1 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER2 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER3 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER4 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER5 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER6 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER7 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER8 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER9 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_NUMBER10 NUMBER Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE1 DATE Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE2 DATE Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE3 DATE Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE4 DATE Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_DATE5 DATE Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP1 TIMESTAMP Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP2 TIMESTAMP Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP3 TIMESTAMP Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP4 TIMESTAMP Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.
CUSTOMER_ATTRIBUTE_TIMESTAMP5 TIMESTAMP Customer Claim Descriptive Flexfield: segment of the customer claim descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
cjm_claim_lines_all cjm_claims_all CLAIM_ID

Indexes

Index Uniqueness Tablespace Columns Status
CJM_CLAIMS_ALL_N1 Non Unique Default VENDOR_ID, VENDOR_SITE_ID
CJM_CLAIMS_ALL_N10 Non Unique Default UPPER("MASS_SETTLEMENT_NUMBER")
CJM_CLAIMS_ALL_N11 Non Unique Default GROUP_CLAIM_ID
CJM_CLAIMS_ALL_N2 Non Unique Default CLAIM_TYPE_ID Obsolete
CJM_CLAIMS_ALL_N3 Non Unique Default REASON_CODE_ID
CJM_CLAIMS_ALL_N4 Non Unique Default USER_STATUS_ID
CJM_CLAIMS_ALL_N5 Non Unique Default UPPER("CLAIM_NUMBER")
CJM_CLAIMS_ALL_N6 Non Unique Default BILL_TO_CUSTOMER_ID
CJM_CLAIMS_ALL_N7 Non Unique Default CLAIM_DATE
CJM_CLAIMS_ALL_N8 Non Unique Default UPPER("CUSTOMER_REF_NUMBER")
CJM_CLAIMS_ALL_N9 Non Unique Default SOURCE_OBJECT_ID
CJM_CLAIMS_ALL_U1 Unique Default CLAIM_ID