RB_PERSON_CARD(SQL Table) |
Index Back |
---|---|
Contact Card InformationCRm Common Object: Contact Card Information.. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL |
Person ID
Prompt Table: RD_PERSON |
2 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
3 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
4 | 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 |
5 | PRIMARY_CARD | Character(1) | VARCHAR2(1) NOT NULL |
Primary Card
Y/N Table Edit Default Value: N |
6 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
7 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
8 | CR_CARD_EXPMO | Character(2) | VARCHAR2(2) NOT NULL |
Card Expiration Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
9 | CR_CARD_EXPYR | Character(4) | VARCHAR2(4) NOT NULL | Card Expiration Year |
10 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
11 | ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
12 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
13 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
14 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
15 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
16 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
17 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |
18 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
19 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Vendor name for credit card processing |