[Home] [Help] [Dependency Information]
Object Name: | IBY_FNDCPT_PMT_CHNNLS_TL |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_FNDCPT_PMT_CHNNLS_TL |
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_TL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYMENT_CHANNEL_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_CHANNEL_CODE | VARCHAR2 | (30) | Yes | User entered primary key |
PAYMENT_CHANNEL_NAME | VARCHAR2 | (100) | Yes | Payment method name |
DESCRIPTION | VARCHAR2 | (255) | Payment method description | |
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. | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
SOURCE_LANG | VARCHAR2 | (4) | Yes | Language code of the record's current language |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_CHANNEL_CODE
, PAYMENT_CHANNEL_NAME
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, LANGUAGE
, SOURCE_LANG
FROM IBY.IBY_FNDCPT_PMT_CHNNLS_TL;
IBY.IBY_FNDCPT_PMT_CHNNLS_TL does not reference any database object
IBY.IBY_FNDCPT_PMT_CHNNLS_TL is referenced by following:
|
|
|