INSTALLATION_CR(SQL Table) |
Index Back |
---|---|
Credit Card Installation RecrdUsed 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 |