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.
  • 1 = Active
  • 0 = Inactive
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