CJM_SETTLEMENT_DOCS_ALL
This table stores information about claim's settlement documents. For Oracle Payables related settlements, Check or Invoice related details are stored.For Oracle Receivables settlements, related receivables instrument details gets stored here.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_SETTLEMENT_DOCS_ALL_PK |
SETTLEMENT_DOC_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SETTLEMENT_DOC_ID | NUMBER | 18 | Yes | Indicates unique identifier for the settlement document. | |
| 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. | ||
| SETTLEMENT_TYPE | VARCHAR2 | 30 | Indicates the type of Receivables or Payables instrument used for claim settlement. | ||
| SETTLEMENT_TYPE_ID | NUMBER | 18 | Indicates identifier of the Settlement Type. | ||
| SETTLEMENT_ID | NUMBER | 18 | Indicates settlement identifier. Stores check or invoice identifier in case of Oracle Payables and credit memo, debit memo, Chargeback, write-off related instrument's identifier is stored in case of Oracle Receivables. | ||
| SETTLEMENT_NUMBER | VARCHAR2 | 30 | Indicates the number of settlement instrument | ||
| SETTLEMENT_DATE | DATE | Indicates the date on which settlement is made and mentioned on settlement document. | |||
| SETTLEMENT_AMOUNT | NUMBER | Indicates the settlement amount that is paid | |||
| SETTLEMENT_ACCTD_AMOUNT | NUMBER | Indicates the settlement amount in functional currency | |||
| SETTLEMENT_DOC_TYPE_CODE | VARCHAR2 | 30 | Indicates whether the settlement document line is a transaction or instrument. Values are from the lookup ORA_CJM_SETTLEMENT_DOC_TYPE. | ||
| SETTLEMENT_CURRENCY_CODE | VARCHAR2 | 15 | Indicates the currency code for the settlement document. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates Oracle Payables or Receivables payment methods used to settle the claim. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of settlement. | ||
| BU_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| CLAIM_ID | NUMBER | 18 | Indicates the claim Identifier. | ||
| CLAIM_LINE_ID | NUMBER | 18 | Indicates claim Line Identifier | ||
| PURGE_FLAG | VARCHAR2 | 1 | Purge Flag to indicate if the settlement document is valid or not. If value is N, settlement documents may be void or cancelled. | ||
| CLAIM_PAYMENT_ID | NUMBER | 18 | Unique identifier for the payment associated with the claim. | ||
| SETTLEMENT_TAX_AMOUNT | NUMBER | Indicates the tax amount in the settlement document. | |||
| INSTRUMENT_FOR | VARCHAR2 | 30 | Indicates for whom the instrument was created. Values can be CUSTOMER, SUPPLIER, or THIRD_PARTY. | ||
| INSTRUMENT_VENDOR_ID | NUMBER | 18 | Indicates the value that uniquely identifies the supplier for whom the instrument was created. | ||
| INSTRUMENT_VENDOR_SITE_ID | NUMBER | 18 | Indicates the value that uniquely identifies the supplier site for which the instrument was created. | ||
| INSTRUMENT_BILL_TO_ACCOUNT_ID | NUMBER | 18 | Indicates the value that uniquely identifies the bill-to customer account for which the instrument was created. | ||
| INSTRUMENT_BILL_TO_SITE_ID | NUMBER | 18 | Indicates the value that uniquely identifies the bill-to customer account site for which the instrument was created. | ||
| TP_INSTRUMENT_PAYEE_NAME | VARCHAR2 | 360 | Indicates the name of the third party payee for whom the instrument was created. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_SETTLEMENT_DOCS_ALL_N1 | Non Unique | Default | CLAIM_ID |
| CJM_SETTLEMENT_DOCS_ALL_N2 | Non Unique | Default | SETTLEMENT_ID |
| CJM_SETTLEMENT_DOCS_ALL_N3 | Non Unique | Default | SETTLEMENT_TYPE |
| CJM_SETTLEMENT_DOCS_ALL_U1 | Unique | Default | SETTLEMENT_DOC_ID |