EOEC_CCI_TP_LVW(SQL View) |
Index Back |
---|---|
Credit Card TypesThis record contains the valid prefixes of credit cards for error checking before sending to CyberSource or other suppliers. |
SELECT A.EOEC_CCI_TYPE ,B.LANGUAGE_CD ,B.EOEC_CCI_NAME FROM PS_EOEC_CCI_TYPE A ,PS_EOEC_CCI_TP_LNG B WHERE A.EOEC_CCI_TYPE=B.EOEC_CCI_TYPE AND A.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 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | EOEC_CCI_NAME | Character(32) | VARCHAR2(32) NOT NULL | Use in the Credit Card Number Capture Process |