FS_CR_CARD_TYPE

(SQL Table)
Index Back

# 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