BATCH_ID_CC_VW2 (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 Messages Inquiry panel. It uses the REFUND_CC_MSGS table

BATCH_ID_CC_VW2

(SQL View)

Credit Card Batch ID view

This view is used to prompt on the Credit Card Batch ID for the Credit Card Messages Inquiry panel. It uses the REFUND_CC_MSGS table

select DISTINCT business_unit ,batch_id_cc from PS_REFUND_CC_MSGS

# 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

#	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