IBY_CREDITCARD
This table contains records of the credit card details of the customers entered manually or imported through IBY_FNDCPT_SETUP_PUB.Create_Card API.IBY_CREDITCARD table stores the credit card information. This is the related table for Create Credit Card UI. This table stores information like credit card number, expiry date, card holder's name, billing address, card brand, purchase card subtype, inactive date, etc.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_CREDITCARD_PK |
INSTRID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| INSTRID | NUMBER | 18 | Yes | Sequence: IBY_INSTR_S.NEXTVAL | ||
| CCNUMBER | VARCHAR2 | 100 | Yes | The credit card number. It must be numeric. | ||
| EXPIRYDATE | DATE | Expiration date of the 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 | |||
| INSTRBUF | VARCHAR2 | 80 | Instrument | |||
| CHNAME | VARCHAR2 | 80 | Card Holder Name | |||
| DESCRIPTION | VARCHAR2 | 240 | Description of the instrument | |||
| FINAME | VARCHAR2 | 80 | Financial Institution Name | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| SUBTYPE | VARCHAR2 | 80 | No longer used | |||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||||
| ENCRYPTED | VARCHAR2 | 1 | Flag indicating if the instrument is encrypted | |||
| BILLING_ADDR_POSTAL_CODE | VARCHAR2 | 50 | Billing address postal code | |||
| BILL_ADDR_TERRITORY_CODE | VARCHAR2 | 2 | Billing address territory code | |||
| MASKED_CC_NUMBER | VARCHAR2 | 100 | Masked credit card number; to be used for display purposes | |||
| CARD_MASK_SETTING | VARCHAR2 | 30 | For masking feature | |||
| CARD_UNMASK_LENGTH | NUMBER | 2 | For masking feature | |||
| CC_NUMBER_HASH1 | VARCHAR2 | 64 | Hash value 1 of the credit card number | |||
| CC_NUMBER_HASH2 | VARCHAR2 | 64 | Hash value 2 of the credit card number | |||
| CARD_OWNER_ID | NUMBER | 18 | 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 | Card Issuer Code if know. Otherwise UNKNOWN. | |||
| CC_ISSUER_RANGE_ID | NUMBER | 18 | For security features | |||
| 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 | |||
| SEC_SUBKEY_ID | NUMBER | Identifies the security sub-key used to encrypt this instrument | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Credit Cards (IBY_CREDITCARD) | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Who column | |||
| PROGRAM_ID | NUMBER | 18 | Concurrent Who column | |||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||||
| CC_NUMBER_LENGTH | NUMBER | 3 | For masking/security features | |||
| CC_NUM_SEC_SEGMENT_ID | NUMBER | 18 | For security features | |||
| UPGRADE_ADDRESSID | NUMBER | 18 | Upgrade column | |||
| START_DATE | DATE | Yes | Date from which card is available for use | |||
| END_DATE | DATE | Yes | Date until which card is available for use | |||
| ORIG_SYSTEM | VARCHAR2 | 80 | Original system from which the credit card record was imported from | |||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Unique identifier that identifies the credit card record in the original system | |||
| ENTERPRISE_ID | NUMBER | 18 | Enterprise Id to support multi-tenancy | |||
| EXPIRY_SEC_SEGMENT_ID | NUMBER | 18 | Foreign key to IBY_SECURITY_SEGMENTS table that holds all encrypted values in system. | |||
| CHNAME_SEC_SEGMENT_ID | NUMBER | 18 | Foreign key to IBY_SECURITY_SEGMENTS table that holds all encrypted values in system. | |||
| ERR_CODE | VARCHAR2 | 100 | Error message during row upgrade. | |||
| ERR_MSG | VARCHAR2 | 255 | Error message during row upgrade. | |||
| TOKEN_PROVIDER_REFERENCE | VARCHAR2 | 80 | A supplementary reference number or code to uniquely identify each tokenization request or response. | |||
| TOKEN_REQUEST_FORMAT_CODE | VARCHAR2 | 30 | Message format for creating outbound request to launch hosted payment page owned by payment gateway to create credit card token. | |||
| TOKEN_RESPONSE_FORMAT_CODE | VARCHAR2 | 30 | Message format for reading and processing inbound response received from payment gateway for credit card token creation using hosted payment page. | |||
| TOKEN_REQUEST_ERROR_MESSAGE | VARCHAR2 | 360 | Error raised while initiating outbound request for credit card token creation. | |||
| TOKEN_RESPONSE_ERROR_MESSAGE | VARCHAR2 | 360 | Error raised while reading and processing inbound response received from payment gateway for token creation request. | |||
| OAUTH_PERFORMED_FLAG | VARCHAR2 | 1 | Indicates whether the credit card token supports Oauth. | |||
| BEPID | NUMBER | 18 | The payment system identifier that issued the credit card token. | |||
| BEP_ACCOUNT_ID | NUMBER | 18 | Payment system account that contains the merchant identifier parameters of the payment system that issued the credit card token. | |||
| USER_PROFILE_CODE | VARCHAR2 | 30 | Funds capture process profile code related to credit card token. | |||
| NETWORK_TRXN_ID | VARCHAR2 | 100 | Network transaction identifier related to credit card token. | |||
| ROUTING_RULE_ID | NUMBER | 18 | Identifier of the tokenization routing rule applied while generating the credit card token. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_CREDITCARD | iby_accttype | ACCTTYPEID |
| IBY_CREDITCARD | hz_party_site_uses | ADDRESSID |
| IBY_CREDITCARD | hz_parties | CARD_OWNER_ID |
| IBY_CREDITCARD | iby_creditcard_issuers_b | CARD_ISSUER_CODE |
| IBY_CREDITCARD | iby_cc_issuer_ranges | CC_ISSUER_RANGE_ID |
| IBY_CREDITCARD | iby_security_segments | CC_NUM_SEC_SEGMENT_ID |
| IBY_CREDITCARD | hz_locations | UPGRADE_ADDRESSID |
| iby_creditcard_h | iby_creditcard | INSTRID |
| exm_cards | iby_creditcard | CARD_REFERENCE_ID |
| iby_instrholder | iby_creditcard | INSTRID |
| exm_card_usage | iby_creditcard | CARD_REFERENCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_CREDITCARD_F1 | Non Unique | Default | ADDRESSID |
| IBY_CREDITCARD_F2 | Non Unique | Default | CARD_OWNER_ID |
| IBY_CREDITCARD_F3 | Non Unique | Default | CARD_ISSUER_CODE |
| IBY_CREDITCARD_F4 | Non Unique | Default | CC_ISSUER_RANGE_ID |
| IBY_CREDITCARD_F5 | Non Unique | Default | CC_NUM_SEC_SEGMENT_ID |
| IBY_CREDITCARD_N1 | Non Unique | Default | CC_NUMBER_HASH1, CC_NUMBER_HASH2 |
| IBY_CREDITCARD_PK | Unique | Default | INSTRID |