BATCH_ID_LOG_VW (SQL View)	Index Back
Batch Id Credit Card Log View This view is used to prompt on the Batch ID for the Credit card log inquiry. It uses the SF_PAYMENT_LOG table

BATCH_ID_LOG_VW

This view is used to prompt on the Batch ID for the Credit card log inquiry. It uses the SF_PAYMENT_LOG table

SELECT DISTINCT batch_id FROM PS_SF_PAYMENT_LOG WHERE batch_id <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BATCH_ID Character(12) VARCHAR2(12) NOT NULL Batch ID