CR_CARD_OPT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CC_CVNUM_PROMPT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Security Code
Y/N Table Edit Default Value: N |
| 2 | CC_CVNUM_PURGE | Character(1) | VARCHAR2(1) NOT NULL |
Purge Security Codes
Y/N Table Edit Default Value: N |
| 3 | CC_CVNUM_HOURS | Number(5,0) | INTEGER NOT NULL | Purge After Hours |
| 4 | CC_AUTH_REV | Character(1) | VARCHAR2(1) NOT NULL |
Enable Authorization Reversals
Y/N Table Edit Default Value: N |
| 5 | CC_AUTH_REV_DEC | Character(1) | VARCHAR2(1) NOT NULL |
Enable Auth Rev for Decrements
Y/N Table Edit Default Value: N |
| 6 | CC_AUTH_REV_AMT_D | Number(17,3) | DECIMAL(16,3) NOT NULL | Authorization Reversal Amount |
| 7 | CC_AUTH_REV_AMT | Number(17,3) | DECIMAL(16,3) NOT NULL | Auth Reversal Tolerance |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 9 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 10 | CC_VALIDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Online Validation
Y/N Table Edit Default Value: N |
| 11 | CC_PROF_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Profile Option
0=No Tokenization 1=Create Profiles Before 2=Create Profiles After Default Value: 0 |
| 12 | CC_PROF_DAYS | Number(4,0) | SMALLINT NOT NULL | Days |
| 13 | SCM_CCI_GROUP | Character(15) | VARCHAR2(15) NOT NULL |
Default Credit Card Group
Prompt Table: SCM_CCI_GRP_PVW |
| 14 | CC_TYPE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Select Credit Card Type
Y/N Table Edit Default Value: N |