CJM_SETTLEMENT_DOC_PAYMENTS
This table stores information about claim's settlement documents for payments. 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_doc_payment_PK |
SETTLEMENT_DOC_PAYMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SETTLEMENT_DOC_PAYMENT_ID | NUMBER | 18 | Yes | Indicates the value that uniquely identifies the payment. | |
| 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. | |
| SETTLEMENT_DOC_ID | NUMBER | 18 | Indicates the value that uniquely identifies the settlement document. | ||
| PAYMENT_METHOD | VARCHAR2 | 30 | Indicates the name of the payment created upon settlement. | ||
| PAYMENT_METHOD_CODE | VARCHAR2 | 30 | Indicates the abbreviation that identifies the type of the payment. | ||
| PAYMENT_NUMBER | VARCHAR2 | 30 | Indicates the number identifying the payment that was created upon settlement. | ||
| PAYMENT_DATE | DATE | Indicates the date when the payment was created. | |||
| PAYMENT_AMOUNT | NUMBER | Indicates the amount of the payment. | |||
| PAYMENT_STATUS | VARCHAR2 | 30 | Indicates the status of the payment. | ||
| PAYEE_VENDOR_ID | NUMBER | 18 | Indicates the value that uniquely identifies the supplier who received the payment. | ||
| PAYEE_VENDOR_SITE_ID | NUMBER | 18 | Indicates the value that uniquely identifies the supplier site that received the payment. | ||
| PAYEE_PARTY_ID | NUMBER | 18 | Indicates the value that uniquely identifies the party who received the payment. | ||
| PAYEE_PARTY_SITE_ID | NUMBER | 18 | Indicates the value that uniquely identifies the party site that received the payment. | ||
| THIRD_PARTY_PAYEE_NAME | VARCHAR2 | 360 | Indicates the name of the third party payee for whom the payment was created. | ||
| PAYEE_TYPE | VARCHAR2 | 30 | Indicates the type of payee. Values can be CUSTOMER, SUPPLIER, THIRD_PARTY, or PARTY. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| cjm_settlement_doc_payment_U1 | Unique | Default | SETTLEMENT_DOC_PAYMENT_ID |