EG_ENGTRNS_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	BUSINESS_UNIT_TO	Character(5)	VARCHAR2(5) NOT NULL	04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW
6	TRANSFER_DIRECTION	Character(2)	VARCHAR2(2) NOT NULL	Transfer From/To EM=Engineering to Manufacturing ME=Manufacturing to Engineering Default Value: EM
7	EG_SLCT_PARAMETER	Character(4)	VARCHAR2(4) NOT NULL	Item Selection ECO=ECO ITEM=Assembly Item Default Value: ECO
8	EG_ECO_OPT	Character(1)	VARCHAR2(1) NOT NULL	BOM Copy ECO Options E=ECO Number Range N=None S=Scheduled Date Range Default Value: E
9	EG_ECO_FROM	Character(10)	VARCHAR2(10) NOT NULL	ECO Number Range Prompt Table: %EDITTABLE2
10	EG_ECO_TO	Character(10)	VARCHAR2(10) NOT NULL	BOM Copy ECO - To Prompt Table: %EDITTABLE2
11	EG_ECO_SCH_DT_FROM	Date(10)	DATE	ECO Schedule Date Range
12	EG_ECO_SCH_DT_TO	Date(10)	DATE	BOM Copy ECO To Schedule Date
13	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
14	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: %EDITTABLE
15	TO_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 SCC (Internet Architecture): Add label ITEM_ID Prompt Table: %EDITTABLE
16	BOM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	03/26/00 RML Added a label "Type" PR=Production RW=Rework Default Value: PR
17	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
18	RTG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Routing Type PR=Production RW=Rework TD=Teardown Default Value: PR
19	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
20	COPY_ASSY_TEXT	Character(1)	VARCHAR2(1) NOT NULL	Copy Assembly Text Y/N Table Edit Default Value: Y
21	COPY_COMP_TEXT	Character(1)	VARCHAR2(1) NOT NULL	Copy Component Text Y/N Table Edit Default Value: Y
22	COPY_ASSY_ATT	Character(1)	VARCHAR2(1) NOT NULL	Copy Assembly Att Y/N Table Edit Default Value: Y
23	COPY_ASSY_DC	Character(1)	VARCHAR2(1) NOT NULL	Copy Assembly Docs Y/N Table Edit Default Value: Y
24	COPY_COMP_ATT	Character(1)	VARCHAR2(1) NOT NULL	Copy Component Att Y/N Table Edit Default Value: Y
25	COPY_COMP_DC	Character(1)	VARCHAR2(1) NOT NULL	Copy Component Docs Y/N Table Edit Default Value: Y
26	OVERWRITE_BOM	Character(1)	VARCHAR2(1) NOT NULL	Overwrite Existing BOMs Y/N Table Edit Default Value: N
27	OVERWRITE_ROUTING	Character(1)	VARCHAR2(1) NOT NULL	Overwrite Existing Routings Y/N Table Edit Default Value: N
28	ERR_BOM_NOT_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Source BOM does not exist Y/N Table Edit Default Value: N
29	ERR_RTG_NOT_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Source routing does not exist Y/N Table Edit Default Value: N
30	TRANSFER_OPT	Character(1)	VARCHAR2(1) NOT NULL	Transfer Options T=Validate and Transfer V=Validate Only Default Value: T
31	DATA_OPTION	Character(1)	VARCHAR2(1) NOT NULL	Transfer Data Options A=BOMs and Routings B=BOMs R=Routings Default Value: B
32	TRNS_VALID_OPT	Character(3)	VARCHAR2(3) NOT NULL	Transfer valid option ALL=Only if all BOMs/Rtgs valid ANY=Any valid BOMs/Routings Default Value: ALL
33	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once Default Value: N
34	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
35	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler Default Value: N
36	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
37	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.