EN_MASSMNT_REQ

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Request ID
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
5	BOM_STATE	Character(2)	VARCHAR2(2) NOT NULL	BOM State EN=Engineering PR=Manufacturing Default Value: EN
6	BOM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	03/26/00 RML Added a label "Type" PR=Production RW=Rework Default Value: PR
7	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
8	EG_SLCT_PARAMETER	Character(4)	VARCHAR2(4) NOT NULL	Item Selection ECO=ECO ITEM=Assembly Item
9	EN_MASSMNT_OPT	Character(4)	VARCHAR2(4) NOT NULL	Process Option CODE=Process by Mass Maint Code ECO=Process by ECO Default Value: CODE
10	MASS_MAINT_CODE	Character(10)	VARCHAR2(10) NOT NULL	Mass Maintenance Code Prompt Table: %EDITTABLE3
11	MASS_MAINT_CODE_TO	Character(10)	VARCHAR2(10) NOT NULL	Mass Maintenance Code To Prompt Table: EN_BOM_MMC_HDR
12	EG_ECO_OPT	Character(1)	VARCHAR2(1) NOT NULL	BOM Copy ECO Options E=ECO Number Range N=None S=Scheduled Date Range
13	EG_ECO_FROM	Character(10)	VARCHAR2(10) NOT NULL	ECO Number Range Prompt Table: %EDITTABLE2
14	EG_ECO_TO	Character(10)	VARCHAR2(10) NOT NULL	BOM Copy ECO - To Prompt Table: %EDITTABLE2
15	EG_ECO_SCH_DT_FROM	Date(10)	DATE	ECO Schedule Date Range
16	EG_ECO_SCH_DT_TO	Date(10)	DATE	BOM Copy ECO To Schedule Date
17	EG_ITEM_OPT	Character(1)	VARCHAR2(1) NOT NULL	Transfer Item Option A=All Items L=List of Assembly Items N=None R=Range of Items Default Value: R
18	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE
19	TO_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID Prompt Table: %EDITTABLE
20	TRANSFER_OPT	Character(1)	VARCHAR2(1) NOT NULL	Transfer Options T=Validate and Transfer V=Validate Only Default Value: V
21	EN_MMAINT_VAL_OPT	Character(4)	VARCHAR2(4) NOT NULL	Mass Maint valid option ALL=Only if all BOMS are valid ANY=Any valid BOMs Default Value: ALL
22	EN_MMC_VALIDATION	Character(1)	VARCHAR2(1) NOT NULL	Validation Options E=Engineering validation M=Manufacturing validation Default Value: E
23	ERR_BOM_NOT_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Source BOM does not exist Y/N Table Edit Default Value: N
24	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
25	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success Default Value: N
26	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler Default Value: N
27	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
28	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
29	EN_AUTOREV_EDATE	Date(10)	DATE	02/17/2004 WHS Incident 687431001 - New field to allow user to select effective date of auto-created revision
30	EN_DELETE_TEMP	Character(1)	VARCHAR2(1) NOT NULL	02/01/00 LAJ Used by BOM Mass Maintenance process to indicate if the data should not be deleted from the intermediate processing tables when the process is completed. This will allow the user to later restart the process. D=Delete Staged Results U=Stage Results Default Value: U
31	REPORT_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Report Only Mode Y/N Table Edit Default Value: N