[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_CREDITCARD |
|---|---|
| Object Type: | TABLE |
| Owner: | IBY |
| FND Design Data: |  IBY.IBY_CREDITCARD
|
| Subobject Name: | |
| Status: | VALID |
Holds credit card details
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IBY_CREDITCARD_INSTRID_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INSTRID
|
| IBY_CREDITCARD_CCNUMBER_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CC_NUMBER_HASH1
CC_NUMBER_HASH2
|
| IBY_CREDITCARD_ENCRYPTED_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ENCRYPTED
|
| IBY_CREDITCARD_MASK_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_UNMASK_LENGTH
CARD_MASK_SETTING
|
| IBY_CREDITCARD_OWNER | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_OWNER_ID
CCNUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTRID | NUMBER | (15) | Yes | Unique internal Identifier for this record. Generated using a database sequence. Sequence used is IBY_INSTR_S.nextval |
| CCNUMBER | VARCHAR2 | (30) | Yes | The number of the credit card |
| EXPIRYDATE | DATE | Expiration date of the credit card | ||
| ACCTTYPEID | NUMBER | No longer used | ||
| ADDRESSID | NUMBER | 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 | ||
| INSTRNAME | VARCHAR2 | (80) | No longer used | |
| DESCRIPTION | VARCHAR2 | (240) | The free text entered in the Description field of the credit card setup screen | |
| CHNAME | VARCHAR2 | (80) | Name of the card holder as mentioned on the card | |
| FINAME | VARCHAR2 | (80) | The free text entered in the financial institution field of the credit card setup screen | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard who column - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table. | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Yes | Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table. | |
| LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table. | ||
| 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. This number is incremented for every update to the row through the application. | |
| SUBTYPE | VARCHAR2 | (80) | No longer used | |
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| ENCRYPTED | VARCHAR2 | (1) | Flag indicating whether the credit card number is encrypted and stored in the database | |
| CARD_OWNER_ID | NUMBER | (15) | Owner TCA Party ID | |
| BILLING_ADDR_POSTAL_CODE | VARCHAR2 | (50) | Billing address postal code | |
| BILL_ADDR_TERRITORY_CODE | VARCHAR2 | (2) | Billing address territory code | |
| MASKED_CC_NUMBER | VARCHAR2 | (30) | Masked credit card number; to be used for display purposes | |
| CARD_MASK_SETTING | VARCHAR2 | (30) | Setup value for the masking of the card holder name. The lookup used is IBY_PMT_INSTR_MASKING. The possible values are - Display Last Digits, Display First Digits, etc. | |
| CARD_UNMASK_LENGTH | NUMBER | (2) | The number of digits that can be exposed while displaying the bank account number on the UI or reports. This can be numeric values like 4, 6, etc. | |
| CC_NUMBER_HASH1 | VARCHAR2 | (64) | Hash value 1 of the credit card number. Used for the encryption of the credit card number. | |
| CC_NUMBER_HASH2 | VARCHAR2 | (64) | Hash value 1 of the credit card number. Used for the encryption of the credit card number | |
| INSTRUMENT_TYPE | VARCHAR2 | (30) | Yes | CREDITCARD |
| PURCHASECARD_FLAG | VARCHAR2 | (1) | Yes | Y or N flag indicating whether the credit card is Purchase card (company card) |
| 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) | The issuer of the card. The possible value are Visa, Amex, Mastercard, etc. The customers can also add the new credit card brands which are flown in to the credit card setup screen. | |
| CC_ISSUER_RANGE_ID | NUMBER | (15) | The reference for this column is IBY_CC_ISSUER_RANGES.CC_ISSUER_RANGE_ID and this is a system generated sequence number generated while inserting new BIN ranges into IBY_CC_ISSUER_RANGES | |
| CC_NUMBER_LENGTH | NUMBER | (3) | The length of the credit card number may be 13, 15, 16, etc. depending on the card issuer. | |
| ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Y or N flag indicating whether the credit card is active or inactive. |
| SINGLE_USE_FLAG | VARCHAR2 | (1) | Y or N flag indicating whether the credit card can be used only once. | |
| 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 whether Supplies or Education | |
| INACTIVE_DATE | DATE | Inactive date | ||
| CC_NUM_SEC_SEGMENT_ID | NUMBER | (15) | For security features | |
| 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) | Enhanced Who column Concurrent Program who column - concurrent request id of the program that last updated this row. Foreign key to the REQUEST_ID column of the FND_CONCURRENT_REQUESTS table. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Enhanced Who column Concurrent Program who column - application id of the program that last updated this row. Foreign key to the APPLICATION_ID column of the FND_APPLICATION table. | |
| PROGRAM_ID | NUMBER | (15) | Enhanced Who column Concurrent Program who column - program id of the program that last updated this row. Foreign key to the CONCURRENT_PROGRAM_ID column of the FND_CONCURRENT_PROGRAM table. | |
| PROGRAM_UPDATE_DATE | DATE | Enhanced Who column Concurrent Program who column - date when a program last updated this row). | ||
| UPGRADE_ADDRESSID | NUMBER | (15) | Upgrade column | |
| SEC_SUBKEY_ID | NUMBER | Identifies the security sub-key used to encrypt this instrument | ||
| SALT_VERSION | NUMBER | (2) | Denotes the versions of the encryption algorithm used for the credit card encryption. | |
| EXPIRY_SEC_SEGMENT_ID | NUMBER | (15) | For security purposes. | |
| CHNAME_SEC_SEGMENT_ID | NUMBER | (15) | For security purposes. | |
| EXPIRED_FLAG | VARCHAR2 | (1) | Marks if a card has already expired. This flag value is updated by the IBY_MARK_EXPIRED_CREDITCARDS Concurrent Program | |
| CHNAME_MASK_SETTING | VARCHAR2 | (30) | Setup value for the masking of the card holder name. The lookup used is IBY_PMT_INSTR_MASKING. The possible values are - Display Last Digits, Display First Digits, etc. | |
| CHNAME_UNMASK_LENGTH | NUMBER | (2) | Setup value for the masking of the card holder name. | |
| INVALID_FLAG | VARCHAR2 | (1) | Flag value to indicate if the creditcard is an invalid one | |
| INVALIDATION_REASON | VARCHAR2 | (100) | This column holds the invalidation reason for an invalid credit card |
Cut, paste (and edit) the following text to query this object:
SELECT INSTRID
, CCNUMBER
, EXPIRYDATE
, ACCTTYPEID
, ADDRESSID
, INSTRNAME
, DESCRIPTION
, CHNAME
, FINAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SUBTYPE
, SECURITY_GROUP_ID
, ENCRYPTED
, CARD_OWNER_ID
, BILLING_ADDR_POSTAL_CODE
, BILL_ADDR_TERRITORY_CODE
, MASKED_CC_NUMBER
, CARD_MASK_SETTING
, CARD_UNMASK_LENGTH
, CC_NUMBER_HASH1
, CC_NUMBER_HASH2
, INSTRUMENT_TYPE
, PURCHASECARD_FLAG
, PURCHASECARD_SUBTYPE
, CARD_ISSUER_CODE
, CC_ISSUER_RANGE_ID
, CC_NUMBER_LENGTH
, ACTIVE_FLAG
, SINGLE_USE_FLAG
, INFORMATION_ONLY_FLAG
, CARD_PURPOSE
, INACTIVE_DATE
, CC_NUM_SEC_SEGMENT_ID
, 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
, UPGRADE_ADDRESSID
, SEC_SUBKEY_ID
, SALT_VERSION
, EXPIRY_SEC_SEGMENT_ID
, CHNAME_SEC_SEGMENT_ID
, EXPIRED_FLAG
, CHNAME_MASK_SETTING
, CHNAME_UNMASK_LENGTH
, INVALID_FLAG
, INVALIDATION_REASON
FROM IBY.IBY_CREDITCARD;
IBY.IBY_CREDITCARD does not reference any database object
IBY.IBY_CREDITCARD is referenced by following:
IBY
IBY_CREDITCARD#
|
|
|
|