CUST_CNTCT_CARD(SQL Table) |
Index Back |
---|---|
Contact Card InformationContact Card Information |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
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.
Prompt Table: CUSTOMER |
3 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: CUST_CONTACT |
4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
5 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
6 | 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 |
7 | PRIMARY_CARD | Character(1) | VARCHAR2(1) NOT NULL |
Primary Card
Y/N Table Edit Default Value: N |
8 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
9 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
10 | 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 |
11 | 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 |
12 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
13 | ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: CUST_ADDR_EF_VW |
14 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
15 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |