EN_REV_ATT

(SQL Table)
Index Back

Item/Revision Attachments

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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITEMS_INV

3 DATE_IN_EFFECT Date(10) DATE NOT NULL 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
4 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension

Prompt Table: FILE_DIR_BU_VW

5 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description