IBY_FNDCPT_PMT_CHNNLS_B
IBY_FNDCPT_PMT_CHNNLS defines all payment methods for the funds capture flow. Payment methods are categorized by instrument types. The instrument types are BANKACCOUNT, CREDITCARD, and DEBITCARD. 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_B_PK |
PAYMENT_CHANNEL_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| PAYMENT_CHANNEL_CODE | VARCHAR2 | 30 | Yes | User entered primary key | ||
| INSTRUMENT_TYPE | VARCHAR2 | 30 | Instrument type. Values, from the IBY_INSTRUMENT_TYPES lookup, include BANKACCOUNT, CREDITCARD, and DEBITCARD | |||
| INACTIVE_DATE | DATE | Inactive date | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Funds Capture Payment Methods (IBY_FNDCPT_PMT_CHNNLS) | ||
| 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. | |||
| 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. | ||
| SEEDED_FLAG | VARCHAR2 | 1 | Y or N flag indicating that the data is seeded record | |||
| FORMAT_VALUE | VARCHAR2 | 80 | Value used in the formatted settlement batch | |||
| START_DATE | DATE | Yes | Start date | |||
| END_DATE | DATE | Yes | End date | |||
| 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. | |||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ar_receipt_methods | iby_fndcpt_pmt_chnnls_b | PAYMENT_CHANNEL_CODE |
| iby_fndcpt_pmt_chnnls_tl | iby_fndcpt_pmt_chnnls_b | PAYMENT_CHANNEL_CODE |
| iby_fndcpt_tx_extensions | iby_fndcpt_pmt_chnnls_b | PAYMENT_CHANNEL_CODE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_FNDCPT_PMT_CHNNLS_B_IT_N1 | Non Unique | Default | INSTRUMENT_TYPE |
| IBY_FNDCPT_PMT_CHNNLS_B_U1 | Unique | Default | PAYMENT_CHANNEL_CODE, ORA_SEED_SET1 |
| IBY_FNDCPT_PMT_CHNNLS_B_U11 | Unique | Default | PAYMENT_CHANNEL_CODE, ORA_SEED_SET2 |