CRDMEM_ACCT_NBRUPG_PO_CCU1_T(SQL Table) |
Index Back |
|---|---|
CC_UPG - Card Number SetCRDMEM_ACCT_NBR contains clear card number. CRDMEM_ACCT_MSK contains masked card number. CR_CARD_NBR contains encrypted card number. It is the union between CC_CARD_DATA_EX and CC_TRANS_LINE. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CRDMEM_ACCT_NBR |
Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 2 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 3 | CRDMEM_ACCT_MSK | Character(20) | VARCHAR2(20) NOT NULL | Cardmember Number |