| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 APPLICATION_OWNER |
Character(4) |
VARCHAR2(4) NOT NULL |
Describes the Card or Chart Owner (i.e. RC, RO etc.)
This field was originally designed to be used for Electronic Cards, but has been expanded to include other applications, such as Charts.
RC=Call Center
RF=FieldService
RO=Order Capture
RY=Online Marketing
|
| 2 |
APPLICATION_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines the Application ID for the given Card Application (e.g. stores CASE_ID for Support or EXTERNAL_ID for Order Capture)
|
| 3 |
HIST_SEQ |
Number(9,0) |
DECIMAL(9) NOT NULL |
History Sequence Number to be used in the History Records
|
| 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 |
CR_CARD_NBR |
Character(44) |
VARCHAR2(44) NOT NULL |
"See OM
|
| 6 |
CR_CARD_DIGITS |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Number's Last Four Digits
|
| 7 |
CR_CARD_VENDOR |
Character(16) |
VARCHAR2(16) NOT NULL |
Vendor name for credit card processing
Prompt Table:
EOEC_CCI_SRCH
|
| 8 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the Currency Code value.
|
| 10 |
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
|
| 11 |
CR_CARD_EXPYR |
Character(4) |
VARCHAR2(4) NOT NULL |
Card Expiration Year
|
| 12 |
CR_CARD_LNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card Last Name
|
| 13 |
CR_CARD_FNAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Credit Card First Name
|
| 14 |
CR_NAME_APPEARS |
Character(80) |
VARCHAR2(80) NOT NULL |
Hold Credit Card Name as it appears in the Card
|
| 15 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
This field stores the Telephone number.
|
| 16 |
EMAILID |
Character(70) |
VARCHAR2(70) NOT NULL |
A user's E-mail address
|
| 17 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 18 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 19 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 20 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 21 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 22 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 23 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 24 |
NUM2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Number 2
|
| 25 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 26 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 27 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 28 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 29 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 30 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
%EDIT_STATE
|
| 31 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 32 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 33 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
Default Value: Y
|
| 34 |
CR_CARD_AUTH_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Credit Card Auth Code
|
| 35 |
CR_CARD_TRN |
Character(16) |
VARCHAR2(16) NOT NULL |
Transaction Reference Number being returned from CyberSource on Authorization
|
| 36 |
CR_CARD_RQST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Credit Card Request ID
|
| 37 |
CR_CARD_AUTH_DT |
Date(10) |
DATE |
Use in the Credit Card Number Capture Process
|
| 38 |
CR_CARD_AUTH_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Auth Status
A=Authorized
B=Billed
C=Credited
D=Declined
M=Manually Approved/Settled
N=Change to Terms
P=Authorized and Billed
R=Processing
T=Cancel Order
U=Unprocessed/Retry
|
| 39 |
CR_CARD_MSG0 |
Character(50) |
VARCHAR2(50) NOT NULL |
This field hold the Return Message form the Cyber Vendor.
|
| 40 |
CR_CARD_MSG1 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 1
|
| 41 |
CR_CARD_MSG2 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 2
|
| 42 |
CR_CARD_MSG3 |
Character(50) |
VARCHAR2(50) NOT NULL |
Credit Card Message 3
|
| 43 |
RC_CARD_AVS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Address Verification Service
A=Street is OK but Postal Wrong
E=AVS Data is Invalid
N=Street and Postal No Match
R=System Unavailable
S=Issuer does not offer AVS
U=Address Info. Unavailable
W=Street Wrong - Postal is OK
X=Exact Address Match
Y=Both Street # and Postal Match
Z=Postal Code Matches
|
| 44 |
CR_CARD_A_DTTM |
Character(20) |
VARCHAR2(20) NOT NULL |
Cr Card Auth Date/Time
|
| 45 |
CR_CARD_CCV_SENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Verification Number Sent? - Indicator as to whether the CCV was included in the Credit Card authorization message.
|
| 46 |
CC_PROF_TOKEN |
Character(44) |
VARCHAR2(44) NOT NULL |
Profile Token ID
|
| 47 |
CR_CARD_TOKEN |
Long Character |
CLOB |
Credit Card Token: SyberSource retuen token length up to 256.
Use this field store the charachter 1 to 250
|
| 48 |
ROW_ADDED_DTTM |
DateTime(26) |
TIMESTAMP |
This is a datetime field for record creation.
|
| 49 |
ROW_ADDED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who added the row.
|
| 50 |
ROW_LASTMANT_DTTM |
DateTime(26) |
TIMESTAMP |
The date and time that the row was last updated.
|
| 51 |
ROW_LASTMANT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
ID of user who last modified the row.
|
| 52 |
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.
|
| 53 |
SYNCDTTM |
DateTime(26) |
TIMESTAMP |
Synchronization Last Update Date Time
|