DW_IBY_PAYMENTS_ALL_D
This table contains the payment details
Details
Module: Payables
Key Columns
PAYMENT_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PAYMENT_ID | NUMBER | 38 | 0 | True | System-generated primary key. | ||
| SOURCE_RECORD_ID | NUMBER | 38 | 0 | This column is for Oracle Internal use only. Source record identifier. Values are derived from PAYMENT_ID | |||
| PAYMENT_SERVICE_REQUEST_ID | NUMBER | 38 | 0 | Payment process request identifier | |||
| PAYMENT_PROCESS_REQUEST_NAME | VARCHAR2 | 256 | Denormalized from IBY_PAY_SERVICE_REQUESTS.CALL_APP_PAY_SERVICE_REQ_CODE and derived via PAYMENT_SERVICE_REQUEST_ID | ||||
| CREATED_BY_USER_ID | VARCHAR2 | 128 | Indicates the user who created the row. | ||||
| UPDATED_BY_USER_ID | VARCHAR2 | 128 | Indicates the user who last updated the row. | ||||
| CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the row. | |||||
| LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time of the last update of the row. |