[Home] [Help] [Dependency Information]
Object Name: | IBY_PCARD_BIN_RANGE |
---|---|
Object Type: | TABLE |
Owner: | IBY |
FND Design Data: | IBY.IBY_PCARD_BIN_RANGE |
Subobject Name: | |
Status: | VALID |
IBY_PCARD_BIN_RANGE stores the BIN ranges for all valid purchase cards.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IBY_PCARD_BIN_RANGE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LAST_UPDATED_BY
UPPERLIMIT LOWERLIMIT ZD_EDITION_NAME |
IBY_BINRANGE_LIMITS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LOWERLIMIT
UPPERLIMIT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOWERLIMIT | NUMBER | Lower limit of the BIN range | ||
UPPERLIMIT | NUMBER | Upper limit of the BIN range | ||
PCARD_SUBTYPE | VARCHAR2 | (4) | Character value giving the subtype of the purchase card. Multiple characters are used if the card belongs to more than a single subtype. | |
OBJECT_VERSION_NUMBER | NUMBER | Used for locking purposes that subsequently allows for checking if there is old data on the screen compared to what is in the database. The situation occurs when the HTML application is a stateless application. | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT LOWERLIMIT
, UPPERLIMIT
, PCARD_SUBTYPE
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM IBY.IBY_PCARD_BIN_RANGE;
IBY.IBY_PCARD_BIN_RANGE does not reference any database object
IBY.IBY_PCARD_BIN_RANGE is referenced by following:
|
|
|