DBA Data[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_CREDITCARD_H

Object Details
Object Name: IBY_CREDITCARD_H
Object Type: TABLE
Owner: IBY
FND Design Data: TableIBY.IBY_CREDITCARD_H
Subobject Name:
Status: VALID


Holds historical data for credit cards


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IBY_CREDITCARD_H_CHID_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCARD_HISTORY_CHANGE_ID
IBY_CREDITCARD_H_INSTRID_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTRID
Columns
Name Datatype Length Mandatory Comments
CARD_HISTORY_CHANGE_ID NUMBER (15) Yes Credit card history change identifier
INSTRID NUMBER (15) Yes Sequence: IBY_INSTR_S.nextval
EXPIRYDATE DATE

Expiration date of the card
ADDRESSID NUMBER (15)
Will become a foreign key to HZ_PARTY_SITE_USES.PARTY_SITE_USE_ID instead of HZ_LOCATIONS.LOCATION_ID ; changes to existing customer data will be implemented in an upgrade script
DESCRIPTION VARCHAR2 (240)
Description of payment instrument
CHNAME VARCHAR2 (80)
Card holder name
FINAME VARCHAR2 (80)
Financial institution name
SECURITY_GROUP_ID NUMBER (15)
Used in hosted environments
ENCRYPTED VARCHAR2 (1)
Flag indicating if the instrument is encrypted
MASKED_CC_NUMBER VARCHAR2 (30)
Masked credit card number; to be used for display purposes
CARD_OWNER_ID NUMBER (15)
Owner TCA Party ID
INSTRUMENT_TYPE VARCHAR2 (30) Yes CREDITCARD
PURCHASECARD_FLAG VARCHAR2 (1) Yes N
PURCHASECARD_SUBTYPE VARCHAR2 (30)
IBY_PURCHASECARD_SUBTYPE include B (Business Card), C (Corporate Card), P (Purchase Card) and U (Unknown).
CARD_ISSUER_CODE VARCHAR2 (30) Yes Card Issuer Code if know. Otherwise UNKNOWN.
SINGLE_USE_FLAG VARCHAR2 (1)
Y
INFORMATION_ONLY_FLAG VARCHAR2 (1)
Y or N flag indicating whether the credit card is registered for information use only
CARD_PURPOSE VARCHAR2 (30)
Purpose of the credit card from lookup type IBY_CARD_PURPOSE
ACTIVE_FLAG VARCHAR2 (1) Yes Y
INACTIVE_DATE DATE

Inactive date
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive Flexfield structure defining column
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
ATTRIBUTE16 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield segment
REQUEST_ID NUMBER (15)
Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Who column
PROGRAM_ID NUMBER (15)
Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
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 Object version number
EFFECTIVE_START_DATE DATE

Active date
EFFECTIVE_END_DATE DATE

Inactive date
EXPIRY_SEC_SEGMENT_ID NUMBER (15)
For Securrity purposes
CHNAME_SEC_SEGMENT_ID NUMBER (15)
For Security purposes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CARD_HISTORY_CHANGE_ID
,      INSTRID
,      EXPIRYDATE
,      ADDRESSID
,      DESCRIPTION
,      CHNAME
,      FINAME
,      SECURITY_GROUP_ID
,      ENCRYPTED
,      MASKED_CC_NUMBER
,      CARD_OWNER_ID
,      INSTRUMENT_TYPE
,      PURCHASECARD_FLAG
,      PURCHASECARD_SUBTYPE
,      CARD_ISSUER_CODE
,      SINGLE_USE_FLAG
,      INFORMATION_ONLY_FLAG
,      CARD_PURPOSE
,      ACTIVE_FLAG
,      INACTIVE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      EXPIRY_SEC_SEGMENT_ID
,      CHNAME_SEC_SEGMENT_ID
FROM IBY.IBY_CREDITCARD_H;

Dependencies

[top of page]

IBY.IBY_CREDITCARD_H does not reference any database object

IBY.IBY_CREDITCARD_H is referenced by following:

SchemaIBY
ViewIBY_CREDITCARD_H#