OM_CC_PURGE_AET(SQL Table) |
Index Back |
|---|---|
State record for OMCRC000Date Init Issue Description ; 012103 JJM F-KHANSEN-31 Use new SCM_CR_CARD application pkg |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | CURRENT_DATE1 | Date(10) | DATE | 12/20/01 EGS (CN#PL900-1): Added 10/07/02 JC (CN#PL880-1): Added FROM_DATE label |
| 6 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |
| 7 | NULLDATE | Date(10) | DATE | Select a platform independent date with a null value |
| 8 | ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag
A=Action |
| 9 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
OM Work Flag
Default Value: N |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | BUSINESS_UNIT_OLD | Character(5) | VARCHAR2(5) NOT NULL | Old Business Unit |
| 12 | CR_CARD_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Run Option
A=All Business Units S=Single Business Unit |
| 13 | 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 |
| 14 | RETURN_CD | Character(1) | VARCHAR2(1) NOT NULL |
Return Code
0=Return OK 1=Return error |
| 15 | RETURN_STATUS | Character(10) | VARCHAR2(10) NOT NULL | statetax |
| 16 | AUTHORIZATION_DT | Date(10) | DATE | Date Authorized |
| 17 | CR_CARD_A_DTTM | Character(20) | VARCHAR2(20) NOT NULL | Cr Card Auth Date/Time |
| 18 | CR_CARD_AUTH_CD | Character(10) | VARCHAR2(10) NOT NULL | Credit Card Auth Code |
| 19 | CR_CARD_AUTH_DT | Date(10) | DATE | Credit Card Authorization Date |
| 20 | CR_CARD_AUTH_DTTM | DateTime(26) | TIMESTAMP | Credit Card Auth Datetime |
| 21 | 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 |
| 22 | CR_CARD_AVS | Character(1) | VARCHAR2(1) NOT NULL |
Address Verification Flag
N=Address Verification OFF Y=Address Verification ON |
| 23 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 24 | 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 |
| 25 | 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 |
| 26 | CR_CARD_FNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card First Name |
| 27 | CR_CARD_LNAME | Character(40) | VARCHAR2(40) NOT NULL | Credit Card Last Name |
| 28 | CR_CARD_IP | Character(15) | VARCHAR2(15) NOT NULL | Credit Card IP Override |
| 29 | CR_CARD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Credit Card Number Length |
| 30 | CR_CARD_MERCHANT | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Merchant ID |
| 31 | CR_CARD_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Processor Name |
| 32 | PRIOR_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Supplier Name |
| 33 | CC_PROF_TOKEN | Character(44) | VARCHAR2(44) NOT NULL | Profile Token ID |
| 34 | CR_CARD_NAME | Character(32) | VARCHAR2(32) NOT NULL | Credit Card Name |
| 35 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 36 | CR_CARD_OPT | Character(1) | VARCHAR2(1) NOT NULL | Credit Card Batch Option |
| 37 | CR_CARD_MSG1 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 1 |
| 38 | CR_CARD_MSG2 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 2 |
| 39 | CR_CARD_MSG3 | Character(50) | VARCHAR2(50) NOT NULL | Credit Card Message 3 |
| 40 | CR_CARD_RQST_ID | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Request ID |
| 41 | CR_CARD_SERVER | Character(28) | VARCHAR2(28) NOT NULL | Credit Card Processing Server |
| 42 | CR_CARD_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Status
A=Active Credit Card I=Inactive Credit Card |
| 43 | CR_CARD_TRACE | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Tracing
C=Supplier Trace N=Production P=Connect with Trace T=No Connect with Trace |
| 44 | EOEC_CCI_RETRY | Number(1,0) | SMALLINT NOT NULL | On-line Transmission Retries |
| 45 | EOEC_CCI_VENDOR | Character(16) | VARCHAR2(16) NOT NULL | Payment Processor Name |
| 46 | CC_REAUTH_STALE | Character(1) | VARCHAR2(1) NOT NULL |
Reauthorize Stale Transactions
Y/N Table Edit Default Value: N |
| 47 | CC_CVNUM_PURGE | Character(1) | VARCHAR2(1) NOT NULL |
Purge Security Codes
Y/N Table Edit Default Value: N |
| 48 | CC_CVNUM_HOURS | Number(5,0) | INTEGER NOT NULL | Purge After Hours |
| 49 | CC_CVNUM_MINS | Number(7,0) | INTEGER NOT NULL | Purge After Minutes |
| 50 | CC_AUTH_REV | Character(1) | VARCHAR2(1) NOT NULL | Enable Authorization Reversals |
| 51 | CC_AUTH_REV_DEC | Character(1) | VARCHAR2(1) NOT NULL | Enable Auth Rev for Decrements |
| 52 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 53 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 54 | CC_AUTH_REV_AMT_D | Number(17,3) | DECIMAL(16,3) NOT NULL | Authorization Reversal Amount |
| 55 | CC_AUTH_REV_AMT | Number(17,3) | DECIMAL(16,3) NOT NULL | Auth Reversal Tolerance |
| 56 | CC_PROF_DAYS | Number(4,0) | SMALLINT NOT NULL | Days |
| 57 | CC_PROF_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Profile Option
0=No Tokenization 1=Create Profiles Before 2=Create Profiles After |
| 58 | CC_PROF_PURGE | Character(1) | VARCHAR2(1) NOT NULL |
Profile Purging Option
0=Do Not Purge Profiles 1=�After Settlement 2=�After |
| 59 | SCM_CCI_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Credit Card Group |
| 60 | CR_CARD_CVNUM | Character(44) | VARCHAR2(44) NOT NULL | Card Verification Number |
| 61 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 62 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 63 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 64 | HOLD_CREDIT_CRD | Character(6) | VARCHAR2(6) NOT NULL | Credit Card Hold |
| 65 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 66 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 67 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 68 | MAX_SEQ | Number(3,0) | SMALLINT NOT NULL | Max Sequence Number |
| 69 | MESSAGE_TEXT | Character(100) | VARCHAR2(100) NOT NULL | Message Text This field refers to the Text for a particular Message Number in the Message Catalog. |
| 70 | 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 |
| 71 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 72 | PROCESS_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 73 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 74 | 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 |
| 75 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 76 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 77 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 78 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 79 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 80 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 81 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 82 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 83 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 84 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 85 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 86 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 87 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 88 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 89 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 90 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 91 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 92 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 93 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 94 | SQL_WHERE_001 | Character(254) | VARCHAR2(254) NOT NULL | |
| 95 | SQL_WHERE_002 | Character(254) | VARCHAR2(254) NOT NULL | |
| 96 | SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | SQL Text |
| 97 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 98 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 99 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |