[Home] [Help] [Dependency Information]
Object Name: | IBY_PMT_SYS_FORMATS |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_PMT_SYS_FORMATS |
Subobject Name: | |
Status: | VALID |
IBY_PMT_SYS_FORMATS links payment system to the payment formats they support. When a user creates a process profile, this table stores the formats that the payment system accepts.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_PMT_SYS_FORMATS_ID_CODE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PAYMENT_FORMAT_CODE
PAYMENT_SYSTEM_ID ZD_EDITION_NAME |
IBY_PMT_SYS_FORMATS_PSID_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PAYMENT_SYSTEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYMENT_SYSTEM_ID | NUMBER | (15) | Yes | Payment system identifier |
PAYMENT_FORMAT_CODE | VARCHAR2 | (30) | Yes | Identifier of a payment format supported by the bank |
INACTIVE_DATE | DATE | Inactive date | ||
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 | (15) | 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. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PAYMENT_SYSTEM_ID
, PAYMENT_FORMAT_CODE
, INACTIVE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ZD_EDITION_NAME
FROM IBY.IBY_PMT_SYS_FORMATS;
IBY.IBY_PMT_SYS_FORMATS does not reference any database object
IBY.IBY_PMT_SYS_FORMATS is referenced by following:
|
|
|