ALEX_CREDIT_CARD (Staging table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| EXTERNAL_KEY** | Varchar (255) | Yes* | No | ALCO_EXTERNAL_KEY.EXTERNAL_KEY | External key – primary key |
| CCARD_ACCOUNT** | VARCHAR (255) | Yes* | Yes | ALCC_CARD.CCARD_ACCOUNT | Credit card number |
| CC_PROCESSOR_EKEY | VARCHAR (255) | Yes | Yes | ALCC_CARD.CC_PROCESSOR_ID | Credit card processor external key |
| USER_EKEY | VARCHAR (255) | No | No | ALCC_CARD.USER_ID | Credit card holder’s external key |
| CCARD_NAME1 | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_NAME1 | Credit card name line 1 |
| CCARD_NAME2 | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_NAME2 | Credit card name line 2 |
| CCARD_ADDRESS1 | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_ADDRESS1 | Credit card address line 1 |
| CCARD_ADDRESS2 | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_ADDRESS2 | Credit card address line 2 |
| CCARD_LIMIT | NUMERIC (20, 0) | No | Yes | ALCC_CARD.CCARD_LIMIT | Credit card limit amount |
| CCARD_LIMIT_CURRENCY_EKEY | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_LIMIT_ID | Currency external key for credit card limit |
| CCARD_ISSUER | VARCHAR (255) | No | Yes | ALCC_CARD.CCARD_ISSUER | Credit card issuer |
| PAYMENT_TYPE_EKEY | VARCHAR (255) | No | Yes | ALCC_CARD.PAYMENT_TYPE_ID | ER payment type external key |
| PR_PAYMENT_TYPE_EKEY | VARCHAR (255) | No | Not used | ||
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCC_CARD.CCARD_ACTIVE_STATUS | Determines whether credit card is active.
|
| CCARD_DEACTIVE_DATE | DATETIME | No | Yes | ALCC_CARD.CCARD_DEACTIVE_DATE | Expiration date |
| CARD_TYPE | VARCHAR (255) | No | Yes | ALCC_CARD.CARD_TYPE | Credit card type |
** Value must be unique
*System required field