[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_CREDITCARD# |
|---|---|
| Object Type: | VIEW |
| Owner: | IBY |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTRID | NUMBER | (15) | Yes | |
| CCNUMBER | VARCHAR2 | (30) | Yes | |
| EXPIRYDATE | DATE | |||
| ACCTTYPEID | NUMBER | |||
| ADDRESSID | NUMBER | |||
| INSTRNAME | VARCHAR2 | (80) | ||
| DESCRIPTION | VARCHAR2 | (240) | ||
| CHNAME | VARCHAR2 | (80) | ||
| FINAME | VARCHAR2 | (80) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| SUBTYPE | VARCHAR2 | (80) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| ENCRYPTED | VARCHAR2 | (1) | ||
| CARD_OWNER_ID | NUMBER | (15) | ||
| BILLING_ADDR_POSTAL_CODE | VARCHAR2 | (50) | ||
| BILL_ADDR_TERRITORY_CODE | VARCHAR2 | (2) | ||
| MASKED_CC_NUMBER | VARCHAR2 | (30) | ||
| CARD_MASK_SETTING | VARCHAR2 | (30) | ||
| CARD_UNMASK_LENGTH | NUMBER | (2) | ||
| CC_NUMBER_HASH1 | VARCHAR2 | (64) | ||
| CC_NUMBER_HASH2 | VARCHAR2 | (64) | ||
| INSTRUMENT_TYPE | VARCHAR2 | (30) | Yes | |
| PURCHASECARD_FLAG | VARCHAR2 | (1) | Yes | |
| PURCHASECARD_SUBTYPE | VARCHAR2 | (30) | ||
| CARD_ISSUER_CODE | VARCHAR2 | (30) | ||
| CC_ISSUER_RANGE_ID | NUMBER | (15) | ||
| CC_NUMBER_LENGTH | NUMBER | (3) | ||
| ACTIVE_FLAG | VARCHAR2 | (1) | Yes | |
| SINGLE_USE_FLAG | VARCHAR2 | (1) | ||
| INFORMATION_ONLY_FLAG | VARCHAR2 | (1) | ||
| CARD_PURPOSE | VARCHAR2 | (30) | ||
| INACTIVE_DATE | DATE | |||
| CC_NUM_SEC_SEGMENT_ID | NUMBER | (15) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| ATTRIBUTE16 | VARCHAR2 | (150) | ||
| ATTRIBUTE17 | VARCHAR2 | (150) | ||
| ATTRIBUTE18 | VARCHAR2 | (150) | ||
| ATTRIBUTE19 | VARCHAR2 | (150) | ||
| ATTRIBUTE20 | VARCHAR2 | (150) | ||
| ATTRIBUTE21 | VARCHAR2 | (150) | ||
| ATTRIBUTE22 | VARCHAR2 | (150) | ||
| ATTRIBUTE23 | VARCHAR2 | (150) | ||
| ATTRIBUTE24 | VARCHAR2 | (150) | ||
| ATTRIBUTE25 | VARCHAR2 | (150) | ||
| ATTRIBUTE26 | VARCHAR2 | (150) | ||
| ATTRIBUTE27 | VARCHAR2 | (150) | ||
| ATTRIBUTE28 | VARCHAR2 | (150) | ||
| ATTRIBUTE29 | VARCHAR2 | (150) | ||
| ATTRIBUTE30 | VARCHAR2 | (150) | ||
| REQUEST_ID | NUMBER | (15) | ||
| PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
| PROGRAM_ID | NUMBER | (15) | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| UPGRADE_ADDRESSID | NUMBER | (15) | ||
| SEC_SUBKEY_ID | NUMBER | |||
| SALT_VERSION | NUMBER | (2) | ||
| EXPIRY_SEC_SEGMENT_ID | NUMBER | (15) | ||
| CHNAME_SEC_SEGMENT_ID | NUMBER | (15) | ||
| EXPIRED_FLAG | VARCHAR2 | (1) | ||
| CHNAME_MASK_SETTING | VARCHAR2 | (30) | ||
| CHNAME_UNMASK_LENGTH | NUMBER | (2) | ||
| INVALID_FLAG | VARCHAR2 | (1) | ||
| INVALIDATION_REASON | VARCHAR2 | (100) |
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
APPS
IBY_CREDITCARD
|
|
|
|