CR_CUST_CRD_VW(SQL View) |
Index Back |
|---|---|
Cust Contact Credit Card VwDate Init. Issue # Description 10/09/01 JJM F-CJORGENS-6 Updated SQL to use "new" tables |
| SELECT CS.CUSTOMER_SETID , CS.CUST_ID , CS.CNTCT_SEQ_NUM , GR.SCM_CCI_GROUP , CC.SEQ_NBR , CC.CR_CARD_NBR , CC.CC_PROF_TOKEN , GR.CR_CARD_VENDOR , CC.CR_CARD_TYPE , CC.CR_CARD_FNAME , CC.CR_CARD_LNAME , CC.CR_CARD_EXPMO , CC.CR_CARD_EXPYR , CC.CR_CARD_DIGITS , CC.PRIMARY_CARD , 'C' FROM PS_CONTACT_CUST CS , PS_CONTACT_CARD CC , PS_SCM_CCI_GROUP GR WHERE %Join(COMMON_KEYS, CONTACT_CUST CS, CONTACT_CARD CC) AND %EffdtCheck(CONTACT_CUST CS2, CS, %CurrentDateIn) AND CC.CR_CARD_TYPE = GR.CR_CARD_TYPE AND CS.EFF_STATUS = 'A' AND CC.STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 4 | SCM_CCI_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Credit Card Group |
| 5 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 7 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 8 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Processor Name |
| 9 | 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 Prompt Table: ORDENT_CCTYP_VW |
| 10 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 11 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 12 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=January 02=February 03=March 04=April 05=May 06=June 07=July 08=August 09=September 10=October 11=November 12=December |
| 13 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL |
Card Expiration Year
2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020 |
| 14 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 15 | PRIMARY_CARD | Character(1) | VARCHAR2(1) NOT NULL | Primary Card |
| 16 | CC_PROF_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
"See OM
C=Contact Component P=Profile Table |