PSA_OPPTY_DOC

(SQL Table)
Index Back

Project Documents

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID
2 DOCUMENT_REQUESTS Number(7,0) INTEGER NOT NULL Number of Requests

Default Value: 1

3 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
5 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File