OM_CCARD_HST_VW

(SQL View)
 Index Back

Credit Card History View

Credit Card History View

SELECT H.BUSINESS_UNIT , H.INVOICE , H.ORDER_NO , H.SEQ_NUM , H.HIST_SEQ , H.CR_CARD_NBR , H.CC_PROF_TOKEN , H.CR_CARD_AUTH_STAT , H.CR_CARD_DIGITS , H.CR_CARD_VENDOR , H.CR_CARD_TYPE , H.CURRENCY_CD , H.AMOUNT , H.CR_CARD_EXPMO , H.CR_CARD_EXPYR , H.CR_CARD_FNAME , H.CR_CARD_LNAME , %subrec(ADDRESS_SBR, H) , H.PHONE , H.EMAILID , H.CR_CARD_AUTH_CD , H.CR_CARD_RQST_ID , H.CR_CARD_A_DTTM , H.CR_CARD_MSG1 , H.CR_CARD_MSG2 , H.CR_CARD_MSG3 , H.CR_CARD_AUTH_DT , H.CC_ADDR_SOURCE , H.ADD_DTTM , H.LAST_MAINT_OPRID FROM %Table(CRCARD_HST) H

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_OM_NONVW

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 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History 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_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
9 CR_CARD_DIGITS Character(4) VARCHAR2(4) NOT NULL Card Number's Last Four Digits
10 CR_CARD_VENDOR Character(16) VARCHAR2(16) NOT NULL Processor Name
11 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

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
14 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
15 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
16 CR_CARD_FNAME Character(40) VARCHAR2(40) NOT NULL Credit Card First Name
17 CR_CARD_LNAME Character(40) VARCHAR2(40) NOT NULL Credit Card Last Name
18 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

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

Prompt Table: %EDIT_STATE

32 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
33 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
34 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

35 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
36 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
37 CR_CARD_AUTH_CD Character(10) VARCHAR2(10) NOT NULL Credit Card Auth Code
38 CR_CARD_RQST_ID Character(30) VARCHAR2(30) NOT NULL Credit Card Request ID
39 CR_CARD_A_DTTM Character(20) VARCHAR2(20) NOT NULL Cr Card Auth Date/Time
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 CR_CARD_AUTH_DT Date(10) DATE Credit Card Authorization Date
44 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

Default Value: B

45 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
46 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID