IBY_FNDCPT_PMT_CHNNLS_TL_
IBY_FNDCPT_PMT_CHNNLS_TL_ is the audit table for IBY_FNDCPT_PMT_CHNNLS_TL. Table IBY_FNDCPT_PMT_CHNNLS_TL contains translated payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are bank account, credit card and debit card. Each payment method includes the attribute-level applicability settings of the payment attributes on documents receivable.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
IBY_FNDCPT_PMT_CHNNLS_TL_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, PAYMENT_CHANNEL_CODE, LANGUAGE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_CHANNEL_CODE | VARCHAR2 | 30 | Yes | Translatable funds capture process profile code. | |
| PAYMENT_CHANNEL_NAME | VARCHAR2 | 100 | Translatable funds capture process profile name. | ||
| DESCRIPTION | VARCHAR2 | 255 | Translatable funds capture process profile description. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| LANGUAGE | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. | |
| SOURCE_LANG | VARCHAR2 | 4 | Indicates the code of the language in which the contents of the translatable columns were originally created. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_FNDCPT_PMT_CHNNLS_TL_N1_ | Non Unique | Default | PAYMENT_CHANNEL_CODE, LANGUAGE |
| IBY_FNDCPT_PMT_CHNNLS_TL_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, PAYMENT_CHANNEL_CODE, LANGUAGE |