LC_ID_VW (SQL View)	Index Back
Redefined L/C View View over the LC_HDR table used in order to deactivate BUSINESS_UNIT and EFFDT for the purposes of entering fees.

LC_ID_VW

(SQL View)

Redefined L/C View

View over the LC_HDR table used in order to deactivate BUSINESS_UNIT and EFFDT for the purposes of entering fees.

SELECT LC_ID, DESCR150_MIXED FROM PS_LC_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System

2 DESCR150_MIXED Character(150) VARCHAR2(150) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
2	DESCR150_MIXED	Character(150)	VARCHAR2(150) NOT NULL	Description