EOEC_CCI_TP_VW(SQL View) |
Index Back |
---|---|
Credit Card TypesThis record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other vendors. |
SELECT EOEC_CCI_TYPE , EOEC_CCI_NAME , EOEC_CCI_LENGTH FROM PS_EOEC_CCI_TYPE WHERE EOEC_CCI_TYPESTAT = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOEC_CCI_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Credit Card Name |
2 | EOEC_CCI_NAME | Character(32) | VARCHAR2(32) NOT NULL | Use in the Credit Card Number Capture Process |
3 | EOEC_CCI_LENGTH | Number(3,0) | SMALLINT NOT NULL | Use in the Credit Card Number Capture Process |