CJM_CLAIM_PAYMENTS_ALL
CJM_CLAIM_PAYMENTS_ALL contains the payment related information for claims.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CJM_CLAIM_PAYMENTS_ALL_PK |
CLAIM_PAYMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| CLAIM_PAYMENT_ID | NUMBER | 18 | Yes | Unique identifier for the payment associated with the claim. | ||
| 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. | |||
| CLAIM_ID | NUMBER | 18 | Indicates the identifier of the claim. | |||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates the claim settlement method. Values are from the lookup ORA_CJM_PAYMENT_METHOD. | |||
| RA_CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Indicates the Receivables transaction type sequence identifier. | |||
| RECEIVABLES_REASON_CODE | VARCHAR2 | 30 | Indicates the credit memo or adjustment reason code defined in Receivables. Values are from Receivables lookup CREDIT_MEMO_REASON for credit memos and ADJUST_REASON for adjustments. | |||
| PAYMENT_REFERENCE_ID | NUMBER | 18 | Unique identifier for the payment reference created or passed to the integrated system, which is populated during claim settlement. Values are from the payment instrument's identifier in Payables or Receivables. | |||
| PAYMENT_REFERENCE_NUMBER | VARCHAR2 | 30 | Identifier for the payment reference number, which is populated during claim settlement. Values are from the payment instrument's number in Payables or Receivables. | |||
| PAYMENT_REFERENCE_DATE | DATE | Indicates the date of the payment reference instrument. | ||||
| PAYMENT_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code of the payment. | |||
| PAYMENT_AMOUNT | NUMBER | Indicates payment amount in the currency of the claim. | ||||
| PAYMENT_ACCTD_AMOUNT | NUMBER | Indicates payment amount in the ledger currency of the business unit. | Obsolete | |||
| PAYMENT_STATUS_CODE | VARCHAR2 | 30 | Status of the claim payment. Values are from the lookup ORA_CJM_PAYMENT_STATUS. | |||
| PAYMENT_EFFECTIVE_DATE | DATE | Effective date of the payment. This is considered as the transaction date for credit memos when the claim is settled with settlement method Credit Memo-On Account. | ||||
| WO_RECEIVABLES_TRX_ID | NUMBER | 18 | Indicates the receivables activity identifier for the Receivables settlement method Write Off. | |||
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | ||
| COMMENTS | VARCHAR2 | 2000 | Indicates settlement comments added by the user. | |||
| VENDOR_ID | NUMBER | 18 | Unique identifier for the supplier for whom the payables invoice is created. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Unique identifier for the supplier site for which the payables invoice is created. | |||
| TRX_BILL_TO_CUSTOMER_ID | NUMBER | 18 | Unique identifier for the bill-to customer account for the transaction created. | |||
| TRX_BILL_TO_SITE_USE_ID | NUMBER | 18 | Unique identifier for the bill-to site use for the transaction created. | |||
| TRX_BILL_TO_ADDRESS_ID | NUMBER | 18 | Unique identifier for the bill-to customer account site for the transaction created. This column stores the address associated to the related customer. | |||
| TRX_BILL_TO_CONTACT_ID | NUMBER | 18 | Unique identifier for the bill-to customer account contact for the transaction created. | |||
| PAY_UNRELATED_CUSTOMER_FLAG | VARCHAR2 | 1 | Indicates whether the related customer gets paid. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_CLAIM_PAYMENTS_ALL_N1 | Non Unique | Default | CLAIM_ID |
| CJM_CLAIM_PAYMENTS_ALL_U1 | Unique | Default | CLAIM_PAYMENT_ID |