BI_LC_RPR_VW (SQL View)	Index Back
Letter of Credit Temp Table Letter of Credit Temporary table for report processing

BI_LC_RPR_VW

(SQL View)

Letter of Credit Temp Table

Letter of Credit Temporary table for report processing

SELECT DISTINCT PROCESS_INSTANCE ,RUN_DTTM FROM PS_BI_LC_EXT_SUM WHERE INVOICE_ACTION = 'I' GROUP BY PROCESS_INSTANCE ,RUN_DTTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_DTTM	DateTime(26)	TIMESTAMP	Run Date and Time