REFUND_CC_VW(SQL View) |
Index Back |
|---|---|
Credit Card/eCheck Refund ViewThis view is used to interface credit card and eCheck refunds to the vendor, CYBERSOURCE. Each refund line will generate a transaction in SF_PAYMENT. It selects all Posted, Credit Card or eCheck refund lines that have not been completed and have a Web Payment reference number. |
| SELECT B.BUSINESS_UNIT , B.REFUND_NBR , B.LINE_SEQ_NBR , B.LINE_AMT , B.EMPLID , B.REFUND_FORMAT , C.SF_PMT_REF_NBR FROM PS_REFUND_HDR A , PS_REFUND_DTL B , PS_ITEM_SF C , PS_SF_PAYMENT_LOG D WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.REFUND_NBR = A.REFUND_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.ITEM_NBR = C.ITEM_NBR AND B.EMPLID = C.COMMON_ID AND C.SA_ID_TYPE = 'P' AND C.COMMON_ID = D.COMMON_ID AND C.SA_ID_TYPE = D.SA_ID_TYPE AND C.SF_PMT_REF_NBR = D.SF_PMT_REF_NBR AND ((A.REF_APPR_ACTIVE_SW = 'Y' AND A.REF_APPR_SW_1 IN ( 'A' , 'N') AND A.REF_APPR_SW_2 IN ('A' , 'N') AND A.REF_APPR_SW_3 IN ('A' , 'N') AND A.REFUND_STATUS = 'P') OR (A.REF_APPR_ACTIVE_SW = 'N' AND A.REFUND_STATUS = 'P')) AND (B.REFUND_FORMAT = 'C' OR B.REFUND_FORMAT = 'E') AND C.SF_PMT_REF_NBR <> ' ' AND D.SF_PAYMENT_STATUS = 'B' AND (D.SF_POST_STATUS = 'S' OR D.CR_CARD_TRANS_SRC = 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REFUND_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Refund Nbr |
| 3 | LINE_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Line Sequence Nbr |
| 4 | LINE_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Line Amount |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | REFUND_FORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Refund Format
A=Automatic Check C=Credit Card D=Direct Deposit E=Electronic Check P=Paper Check |
| 7 | SF_PMT_REF_NBR | Character(12) | VARCHAR2(12) NOT NULL | Reference Nbr |