FS_CR_CARD_VW(SQL View) |
Index Back |
---|---|
Credit Card Type ViewThis view is used on the OM Order Entry form to find the valid Credit Card Types audits. Date Init. Issue # Description 031505 RR 1218176002 Modified SQL by using EOEC_CCI_TYPE so that credit card type on contact additional information page referred to the correct table. 080409 JJM 1905864000 Created Rel Lang View |
SELECT EOEC_CCI_TYPE , EOEC_CCI_NAME , EOEC_CCI_LENGTH , EOEC_CCI_TYPESTAT , EOEC_CCI_PREFIX , EOEC_CCI_CHKDIGIT , EOEC_CCI_EXPDAYS , EOEC_CCI_NAME FROM PS_EOEC_CCI_TYPE WHERE EOEC_CCI_TYPESTAT = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CR_CARD_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
"See OM
01=Visa 02=MasterCard 03=Diners Club/Carte Blanche 04=AMEX 05=Discover 06=EnRoute |
2 | CR_CARD_NAME | Character(32) | VARCHAR2(32) NOT NULL | Credit Card Name |
3 | CR_CARD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Credit Card Number Length |
4 | CR_CARD_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Status
A=Active Credit Card I=Inactive Credit Card |
5 | CR_CARD_PREFIX | Character(60) | VARCHAR2(60) NOT NULL | Credit Card Valid Prefixes |
6 | USE_CHECK_DIGIT | Character(1) | VARCHAR2(1) NOT NULL |
Use Check Digit Algorithm
N=No Y=Yes Default Value: N |
7 | CR_CARD_EXP_DAYS | Signed Number(4,0) | DECIMAL(3) NOT NULL | Credit Card Expiration Days |
8 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |