EG_ECO_ATT

(SQL Table)
Index Back

ECO Header Attachments

Created on 04/06/00 RML New feature in 8.0 04/21/2006 PWF Change field from DOCUMENT to DOCUMENT_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number
3 ECO_STATE Character(2) VARCHAR2(2) NOT NULL ECR / ECO Flag
CO=Engineering Change Order
CR=Engineering Chg Request

Default Value: CO

4 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
5 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension

Prompt Table: FILE_DIR_BU_VW

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
8 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File