[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_PMT_CHNNLS_B |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_PMT_CHNNLS_B |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_FNDCPT_PMT_CHNNLS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAYMENT_CHANNEL_CODE
ZD_EDITION_NAME |
IBY_FNDCPT_PMT_CHNNLS_B_IT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | INSTRUMENT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 category code | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Used for locking purposes that subsequently allows for checking if there is 'dirty' or old data on the screen compared to what is in the database. The situation occurs when the HTML application is an 'stateless' application. | |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_CHANNEL_CODE
, INSTRUMENT_TYPE
, INACTIVE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SEEDED_FLAG
, FORMAT_VALUE
, ZD_EDITION_NAME
FROM IBY.IBY_FNDCPT_PMT_CHNNLS_B;
IBY.IBY_FNDCPT_PMT_CHNNLS_B does not reference any database object
IBY.IBY_FNDCPT_PMT_CHNNLS_B is referenced by following:
|
|
|