BU_TBL_RO_CC_VW

(SQL View)
 Index Back

Credit cards by BU

Valid credit card type definitions by Order Capture BU

SELECT a.business_unit , a.CR_CARD_type , b.EOEC_CCI_NAME , b.EOEC_CCI_LENGTH , b.EOEC_CCI_PREFIX , b.EOEC_CCI_CHKDIGIT , b.EOEC_CCI_EXPDAYS FROM PS_BU_TBL_RO_CC a , PS_EOEC_CCI_TYPE b WHERE a.CR_CARD_type = b.EOEC_CCI_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CR_CARD_TYPE Character(2) VARCHAR2(2) NOT NULL "See OM
01=Visa
02=MasterCard
03=Diners Club/Carte Blanche
04=AMEX
05=Discover
06=EnRoute

Prompt Table: EOEC_CCI_TYPE

3 CR_CARD_NAME Character(32) VARCHAR2(32) NOT NULL Use in the Credit Card Number Capture Process
4 CR_CARD_LENGTH Number(3,0) SMALLINT NOT NULL Use in the Credit Card Number Capture Process
5 CR_CARD_PREFIX Character(60) VARCHAR2(60) NOT NULL Use in the Credit Card Number Capture Process
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 Use in the Credit Card Number Capture Process