BATCH_ID_CC_VW

(SQL View)
 Index Back

Credit Card Batch ID view

This view is used to prompt on the Credit Card Batch ID for the Credit Card Detail report. It uses the REFUND_HDR table

SELECT DISTINCT BUSINESS_UNIT , BATCH_ID_CC FROM PS_REFUND_HDR WHERE BATCH_ID_CC <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BATCH_ID_CC Character(12) VARCHAR2(12) NOT NULL Batch ID used for processing refunds via the CyberSource Credit Card Interface