IBY_CREDITCARD_
IBY_CREDITCARD_ is the audit table for IBY_CREDITCARD. Table IBY_CREDITCARD contains records of the credit card details of the customers entered manually or imported through IBY_FNDCPT_SETUP_PUB.Create_Card API. 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_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, INSTRID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INSTRID | NUMBER | 18 | Yes | System generated unique primary key. | |
| CCNUMBER | VARCHAR2 | 100 | The credit card number. It must be numeric. | ||
| EXPIRYDATE | DATE | Date on which credit card expires. | |||
| ACCTTYPEID | NUMBER | Account type identifier which is 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 | Instrument name which is no longer used. | ||
| INSTRBUF | VARCHAR2 | 80 | Customer owned credit card instrument. | ||
| CHNAME | VARCHAR2 | 80 | Card holder name as displayed on credit card. | ||
| DESCRIPTION | VARCHAR2 | 240 | Additional details of credit card. | ||
| FINAME | VARCHAR2 | 80 | Financial institution issued the credit card. | ||
| 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 | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | 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 | 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 | Credit card sub type which is no longer used. | ||
| SECURITY_GROUP_ID | NUMBER | Security group identifier used in hosted environments. | |||
| ENCRYPTED | VARCHAR2 | 1 | Flag indicating if the instrument is encrypted | ||
| BILLING_ADDR_POSTAL_CODE | VARCHAR2 | 50 | Postal code of the billing address. | ||
| BILL_ADDR_TERRITORY_CODE | VARCHAR2 | 2 | Territory code of the billing address. | ||
| MASKED_CC_NUMBER | VARCHAR2 | 100 | Masked credit card number; to be used for display purposes | ||
| CARD_MASK_SETTING | VARCHAR2 | 30 | Mask setting option selected for credit card. | ||
| CARD_UNMASK_LENGTH | NUMBER | 2 | Number of digits of the credit card to be displayed in clear text. | ||
| 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 | Credit card owner party identifier. | ||
| INSTRUMENT_TYPE | VARCHAR2 | 30 | Instrument type of the credit card. | ||
| PURCHASECARD_FLAG | VARCHAR2 | 1 | Indicator to identify purchase type credit 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 | Card Issuer Code if know. Otherwise UNKNOWN. | ||
| CC_ISSUER_RANGE_ID | NUMBER | 18 | Credit card issuer range identifier. | ||
| SINGLE_USE_FLAG | VARCHAR2 | 1 | Indicator to identify single use credit card. | ||
| 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. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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 request identifier of the program name that last updated | ||
| PROGRAM_ID | NUMBER | 18 | Concurrent request identifier of the program that last updated | ||
| PROGRAM_UPDATE_DATE | DATE | Date on which concurrent request program last updated | |||
| CC_NUMBER_LENGTH | NUMBER | 3 | Number of digits of the credit card. | ||
| CC_NUM_SEC_SEGMENT_ID | NUMBER | 18 | Credit card number security segment identifier. | ||
| UPGRADE_ADDRESSID | NUMBER | 18 | Upgraded address identifier of credit card. | ||
| START_DATE | DATE | Date from which card is available for use | |||
| END_DATE | DATE | 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. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_CREDITCARD_N1_ | Non Unique | Default | INSTRID |
| IBY_CREDITCARD_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, INSTRID |