[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IBY_PAYMENTCARD |
|---|---|
| Object Type: | TABLE |
| Owner: | IBY |
| FND Design Data: |  IBY.IBY_PAYMENTCARD
|
| Subobject Name: | |
| Status: | VALID |
This table stores information about card number for the card programs associated with card type 'Payment Card'.IBY_PAYMENTCARD contain payment card numbers entered manually through the Payables, Credit card setup. The card number can be numeric or alpha numeric characters. The card number is fetched in the internal bank field of the payments workbench when payments are made using the Payment Process Profile with processing type as 'Payment Card
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IBY_PAYMENTCARD_INSTRID_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 INSTRID
|
| IBY_PAYMENTCARD_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_NUMBER
|
| IBY_PAYMENTCARD_OWNER | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CARD_NUMBER
CARD_OWNER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INSTRID | NUMBER | (15) | Yes | Sequence: IBY_PAYMENTCARD_S.nextval |
| CARD_NUMBER | VARCHAR2 | (30) | Yes | The Payment card number. It can be alphanumeric |
| EXPIRYDATE | DATE | Expiration date of the card | ||
| 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 | ||
| BILLING_ADDR_POSTAL_CODE | VARCHAR2 | (50) | Billing address postal code | |
| BILL_ADDR_TERRITORY_CODE | VARCHAR2 | (2) | Billing address territory code | |
| DESCRIPTION | VARCHAR2 | (240) | Description of the instrument | |
| CHNAME | VARCHAR2 | (80) | Card Holder Name | |
| FINAME | VARCHAR2 | (80) | Financial Institution Name | |
| MASKED_CARD_NUMBER | VARCHAR2 | (30) | Masked Payment card number; to be used for display purposes | |
| CARD_MASK_SETTING | VARCHAR2 | (30) | For masking feature | |
| CARD_UNMASK_LENGTH | VARCHAR2 | (2) | For masking feature | |
| CARD_OWNER_ID | NUMBER | (15) | Owner TCA Party ID | |
| INSTRUMENT_TYPE | VARCHAR2 | (30) | Yes | PAYMENTCARD |
| CARD_ISSUER_CODE | VARCHAR2 | (30) | COMCHECK | |
| CARD_NUMBER_LENGTH | NUMBER | (3) | For masking/security features | |
| ACTIVE_FLAG | VARCHAR2 | (1) | Y or N denoting the card is active or not | |
| SINGLE_USE_FLAG | VARCHAR2 | (1) | Not Used | |
| INFORMATION_ONLY_FLAG | VARCHAR2 | (1) | Not used | |
| CARD_PURPOSE | VARCHAR2 | (30) | Not used | |
| INACTIVE_DATE | DATE | Inactive date | ||
| 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 | |
| REQUEST_ID | NUMBER | (15) | Concurrent Who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Who column | |
| PROGRAM_ID | NUMBER | (15) | Concurrent Who column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is 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. The situation occurs when the HTML application is an 'stateless' application. |
Cut, paste (and edit) the following text to query this object:
SELECT INSTRID
, CARD_NUMBER
, EXPIRYDATE
, ADDRESSID
, BILLING_ADDR_POSTAL_CODE
, BILL_ADDR_TERRITORY_CODE
, DESCRIPTION
, CHNAME
, FINAME
, MASKED_CARD_NUMBER
, CARD_MASK_SETTING
, CARD_UNMASK_LENGTH
, CARD_OWNER_ID
, INSTRUMENT_TYPE
, CARD_ISSUER_CODE
, CARD_NUMBER_LENGTH
, ACTIVE_FLAG
, SINGLE_USE_FLAG
, INFORMATION_ONLY_FLAG
, CARD_PURPOSE
, INACTIVE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM IBY.IBY_PAYMENTCARD;
IBY.IBY_PAYMENTCARD does not reference any database object
IBY.IBY_PAYMENTCARD is referenced by following:
IBY
IBY_PAYMENTCARD#
|
|
|
|