CC_HIST_REV_VW

(SQL View)
 Index Back

SELECT HST.BUSINESS_UNIT , HST.INVOICE , HST.ORDER_NO , HST.SEQ_NUM , HST.CR_CARD_NBR , HST.CR_CARD_DIGITS , HST.CC_PROF_TOKEN , HST.CR_CARD_TYPE , HST.CR_CARD_AUTH_STAT , HST.CR_CARD_VENDOR , HST.AMOUNT , HST.CURRENCY_CD , HST.CR_CARD_EXPMO , HST.CR_CARD_EXPYR , HST.CR_CARD_FNAME , HST.CR_CARD_LNAME , HST.PHONE , HST.EMAILID , HST.CR_CARD_RQST_ID , HST.CC_ADDR_SOURCE , %subrec(ADDRESS_SBR, HST) , CC_RQST_TOKEN FROM PS_CRCARD_HST HST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
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 CC_PROF_TOKEN Character(44) VARCHAR2(44) NOT NULL Profile Token ID
8 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
9 CR_CARD_AUTH_STAT Character(1) VARCHAR2(1) NOT NULL Credit Card Auth Status
A=Authorized
B=Billed
C=Credited
D=Denied
E=Validation Errors
F=Auth Reversal
G=Validated
H=Auth Reversal Denied
J=Reauthorize
K=No Action
L=Credit Card Not In Group
M=Manually Approved/Settled
N=Change to Terms
P=Authorized and Billed
R=Processing
T=Cancel Order
U=Unprocessed/Retry
V=Pending Approval
W=Deleted after Settlement
X=Deleted
Y=Cancelled
Z=Zero Payment for Maintenance
10 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
11 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 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
14 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
15 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
16 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
17 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
18 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
19 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
20 CC_ADDR_SOURCE Character(1) VARCHAR2(1) NOT NULL Credit card address source
B=Bill To Address
C=Credit Card Override
H=Ship To Address
O=Ship To Address Override
21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

22 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
23 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
24 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
25 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
26 CITY Character(30) VARCHAR2(30) NOT NULL City
27 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
28 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
29 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
30 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
31 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
32 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
33 COUNTY Character(30) VARCHAR2(30) NOT NULL County
34 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: %EDIT_STATE

35 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
36 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
37 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

38 CC_RQST_TOKEN Long Character(256) VARCHAR2(256) Request Token