INSTALLATION_CR

(SQL Table)
Index Back

Credit Card Installation Recrd

Used to store system-wide credit card processing fields

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CR_CARD_MERCHANT Character(16) VARCHAR2(16) NOT NULL Use in the Credit Card Number Capture Process
2 CR_CARD_TRACE Character(1) VARCHAR2(1) NOT NULL Use in the Credit Card Number Capture Process
C=Vendor Trace
N=Production
P=Connect with Trace
T=No Connect with Trace

Default Value: N

3 CR_CARD_AVS Character(1) VARCHAR2(1) NOT NULL Use in the Credit Card Number Capture Process
N=Address Verification OFF
Y=Address Verification ON

Default Value: Y

4 CR_CARD_HST_BAK Number(4,0) SMALLINT NOT NULL Use in the Credit Card Number Capture Process

Default Value: 0

5 CR_CARD_SERVER Character(28) VARCHAR2(28) NOT NULL Use in the Credit Card Number Capture Process
6 CR_CARD_IP Character(15) VARCHAR2(15) NOT NULL Use in the Credit Card Number Capture Process
7 CR_TRANS_RETRY Number(1,0) SMALLINT NOT NULL On-line Transmission Retrys
8 HIST_SEQ Number(9,0) DECIMAL(9) NOT NULL History Sequence Number to be used in the History Records

Default Value: 0

9 RC_TRANSACTION_TYP Character(1) VARCHAR2(1) NOT NULL Indicator for Credit Card Transaction Type.
1=Authorize Only
2=Authorize and Bill
3=Bill Only
4=Credit Only

Default Value: 1

10 RC_CREDIT Character(1) VARCHAR2(1) NOT NULL Indicator for Credit Card Transaction Type.

Y/N Table Edit

Default Value: N