Credit Card
Stores the details of the credit card. For example, the name of the cardholder and the credit card number.
QName: {http://xmlns.oracle.com/apps/financials/payments/fundsCapture/creditCards/creditCardServiceV2/}CreditCard
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
Accttypeid |
int |
This column is no longer in use. |
|
Addressid |
long |
Trading Community Hierarchy (TCA) identifier of the address. 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. |
|
BepAccountId |
long |
Payment System Account Identifier |
|
Bepid |
long |
Payment System Identifier |
|
BillAddrTerritoryCode |
string |
Territory code of the payer's billing address. |
|
BillAddressCity |
string |
City of the billing address. |
|
BillAddressCounty |
string |
County of the billing address. |
|
BillAddressFirstLine |
string |
First line of the billing address. |
|
BillAddressFourthLine |
string |
Fourth line of the billing address. |
|
BillAddressProvince |
string |
Province of the billing address. |
|
BillAddressSecondLine |
string |
Second line of the billing address. |
|
BillAddressState |
string |
State of the billing address. |
|
BillAddressThirdLine |
string |
Third line of the billing address. |
|
BillingAddrPostalCode |
string |
Postal code of the payer's billing address. |
|
CardIssuerCode |
string |
Card issuer code if known. Otherwise UNKNOWN. |
|
CardIssuerName |
string |
The name of the bank that issues corporate credit cards. |
|
CardMaskSetting |
string |
Credit card masking setting. Values taken from lookup IBY_PMT_INSTR_MASKING. |
|
CardOwnerId |
long |
Trading Community Hierarchy (TCA) party identifier of the payer that owns the credit card. |
|
CardPurpose |
string |
Purpose for which the credit card is used. Values are validated against lookup type IBY_CARD_PURPOSE |
|
CardUnmaskLength |
int |
Number of digits exposed for masked credit card numbers. |
|
CcIssuerRangeId |
long |
Identifier of the card issuer range. For example, the issuer ranges are provided by MasterCard and VISA. |
|
CcNumberLength |
int |
Length of the credit card number. |
|
Ccnumber |
string |
The numeric credit card number. |
|
Chname |
string |
Name of the cardholder. |
|
CreatedBy |
string |
Date and time of the creation of the record. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
User who created the record. |
|
CreditCardDffVLA |
Credit card descriptive flexfield. |
|
|
Description |
string |
Description of the instrument. |
|
EndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date to which card is available for use. |
|
EndDateDisp |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Internal end date of the credit card that is displayed to the user. |
|
ExpiredFlag |
boolean |
Indicates whether the credit card is expired. |
|
Expirydate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Expiration date of the card. |
|
ExpirydateDisp |
string |
The date of expiration that is displayed on the credit card. |
|
Finame |
string |
Name of the financial institution. |
|
FormattedBillingAddress |
string |
Formatted billing address of the credit card. |
|
InformationOnlyFlag |
boolean |
Yes or No indicates whether the credit card is registered for information use only. |
|
Instrbuf |
string |
Name of the Instrument. |
|
Instrid |
long |
Identifier of the payment instrument, which can be a credit card or a bank account.
|
|
Instrname |
string |
This column is no longer in use. |
|
InstrumentType |
string |
Type of payment instrument, such as credit card or bank account transfer. |
|
IsInvokedFromSOAP |
string |
Is invoked from SOAP. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
User who last updated the record. |
|
LastUpdateLogin |
string |
Session login associated with the user who last updated the record. |
|
LastUpdatedBy |
string |
Date and time of the last record update. |
|
MaskedCcNumber |
string |
Masked credit card number, which is used for display purposes. |
|
ObjectVersionNumber |
int |
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. |
|
PartyId |
long |
Identifier of the party on the credit card. |
|
PartyName |
string |
Name of the party who owns the credit card. |
|
PurchasecardFlag |
boolean |
Indicates whether the credit card is a purchase card. |
|
PurchasecardSubtype |
string |
Subtype of a purchase card. The values are validated against lookup IBY_PURCHASECARD_SUBTYPE and include B (Business Card), C (Corporate Card), P (Purchase Card), and U (Unknown). |
|
SingleUseFlag |
boolean |
Yes indicates whether the credit card is to be used only once. |
|
StartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date from which card is available for use. |
|
Subtype |
string |
This column is no longer in use. |
|
TokenResponseBody |
string |
This column is no longer in use. |
|
TokenResponseHeaders |
string |
This column is no longer in use. |
|
UserProfileCode |
string |
User defined Funds Capture Process Profile Code |