paymentcard
The table storing payment card details, used for processing and managing payments through credit or debit cards.
Columns
| Name | Type | References | Description |
| cardbrand | String | The brand of card (such as Visa, MasterCard, or American Express), used to identify the card type for processing. | |
| cardnumber | String | The card number associated with the payment instrument, used for processing transactions and identifying the card. | |
| cardtype | String | The type of card (such as credit, debit, or prepaid), specifying the kind of financial product being used. | |
| entity | String | The entity associated with the card (such as the customer or account holder), used for identifying the party owning the card. | |
| expirationdate | String | The expiration date of the card, typically in MM/YY format, indicating when the card is no longer valid. | |
| externalid | String | A unique identifier for the card or account as assigned by an external system, used for integration or referencing across platforms. | |
| id | Integer | A unique internal identifier assigned to the card record, used for referencing and managing the record within the system. | |
| instrumenttype | String | The type of payment instrument (such as physical card, virtual card, or digital wallet), used for processing payments. | |
| isdefault | Boolean | Indicates whether the card is the default payment method for the entity, often used for recurring payments. | |
| isinactive | Boolean | Indicates whether the card is inactive, often used to flag cards that are no longer in use or have been deactivated. | |
| issuenumber | String | The issue number associated with the card, typically used for certain card types to track specific issuances. | |
| mask | String | A masked version of the card number, displaying only the last few digits for security purposes (for example, **** **** **** 1234). | |
| memo | String | A brief note or memo attached to the card record, often used for internal tracking or providing additional details. | |
| nameoncard | String | The name of the cardholder as printed on the card, used for identification and verification during transactions. | |
| paymentmethod | String | The method used for payment (such as credit card, debit card, or bank transfer), used to specify the payment type. | |
| preserveonfile | Boolean | Indicates whether the card details are stored on file for future transactions or subscription billing. | |
| state | String | The state or province associated with the billing address for the card, used for address verification and payment processing. | |
| street | String | The street address associated with the billing address for the card, used for address verification and payment processing. | |
| validfromdate | String | The date when the card becomes valid, typically in MM/YY format, indicating the start of the card’s usage period. | |
| zipcode | String | The postal code associated with the billing address for the card, used for address verification and payment processing. |