[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#;
|
|
|