CRCARD_HSTA_VW(SQL View) |
Index Back |
|---|---|
View All Credit Card History |
| SELECT HIST_SEQ , 'OM' , BUSINESS_UNIT , ORDER_NO , CR_CARD_AUTH_STAT , CR_CARD_DIGITS , CR_CARD_TYPE , CURRENCY_CD , AMOUNT , CR_CARD_AUTH_CD , CR_CARD_RQST_ID , CR_CARD_A_DTTM , CR_CARD_AUTH_DT , ADD_DTTM , LAST_MAINT_OPRID FROM PS_CRCARD_HST WHERE INVOICE = ' ' UNION SELECT HIST_SEQ , 'BI' , BUSINESS_UNIT , INVOICE , CR_CARD_AUTH_STAT , CR_CARD_DIGITS , CR_CARD_TYPE , CURRENCY_CD , AMOUNT , CR_CARD_AUTH_CD , CR_CARD_RQST_ID , CR_CARD_A_DTTM , CR_CARD_AUTH_DT , ADD_DTTM , LAST_MAINT_OPRID FROM PS_CRCARD_HST WHERE INVOICE <> ' ' UNION SELECT HIST_SEQ , 'AR' , BUSINESS_UNIT , ITEM , CR_CARD_AUTH_STAT , CR_CARD_DIGITS , CR_CARD_TYPE , CURRENCY_CD , AMOUNT , CR_CARD_AUTH_CD , CR_CARD_RQST_ID , CR_CARD_A_DTTM , CR_CARD_AUTH_DT , ADD_DTTM , LAST_MAINT_OPRID FROM PS_CRCARD_AR_HST UNION SELECT HIST_SEQ , REF_SOURCE , BUSINESS_UNIT , REF_VALUE , CR_CARD_AUTH_STAT , CR_CARD_DIGITS , CR_CARD_TYPE , CURRENCY_CD , AMOUNT , CR_CARD_AUTH_CD , CR_CARD_RQST_ID , CR_CARD_A_DTTM , CR_CARD_AUTH_DT , ADD_DTTM , LAST_MAINT_OPRID FROM PS_CRCARD_HST_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HIST_SEQ | Number(9,0) | DECIMAL(9) NOT NULL | History sequence number |
| 2 | REF_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Reference Source
CDR=Cash Drawer Receipt |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | REF_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Reference |
| 5 | 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 |
| 6 | CR_CARD_DIGITS | Character(4) | VARCHAR2(4) NOT NULL | Card Number's Last Four Digits |
| 7 | 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 |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 10 | CR_CARD_AUTH_CD | Character(10) | VARCHAR2(10) NOT NULL | Credit Card Auth Code |
| 11 | CR_CARD_RQST_ID | Character(30) | VARCHAR2(30) NOT NULL | Credit Card Request ID |
| 12 | CR_CARD_A_DTTM | Character(20) | VARCHAR2(20) NOT NULL | Cr Card Auth Date/Time |
| 13 | CR_CARD_AUTH_DT | Date(10) | DATE | Credit Card Authorization Date |
| 14 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 15 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |