EN_BOM_MSG_DFLT (SQL Table)	Index Back
BOM Msg Default Record for setting up the default values for BOM Messaging 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from record

EN_BOM_MSG_DFLT

(SQL Table)

BOM Msg Default

Record for setting up the default values for BOM Messaging 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from record

# 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 DATE_OBSOLETE Date(10) DATE Obsolete Date
Default Value: %date

3 POS_NBR Number(4,0) SMALLINT NOT NULL Position Number

4 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

5 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
Default Value: ASY

6 YIELD Number(8,4) DECIMAL(7,4) NOT NULL Component Yield
Default Value: 100

7 ECO_ID Character(10) VARCHAR2(10) NOT NULL ECO Number

8 SUB_SUPPLY_FLG Character(1) VARCHAR2(1) NOT NULL Subcontract Supply
Y/N Table Edit
Default Value: N

9 PENDING_STATUS Character(3) VARCHAR2(3) NOT NULL Status
ACT=Active
PEN=Pending
Default Value: ACT

10 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
Y/N Table Edit
Default Value: N

11 TEARDOWN_FLAG Character(1) VARCHAR2(1) NOT NULL 01/28/99 jnw (CN#SF800-13) added field
Y/N Table Edit

12 ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit
Default Value: N

13 BOM_QTY Number(7,0) INTEGER NOT NULL 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard.

#	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	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date Default Value: %date
3	POS_NBR	Number(4,0)	SMALLINT NOT NULL	Position Number
4	QTY_PER	Number(10,4)	DECIMAL(9,4) NOT NULL	Quantity
5	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order Default Value: ASY
6	YIELD	Number(8,4)	DECIMAL(7,4) NOT NULL	Component Yield Default Value: 100
7	ECO_ID	Character(10)	VARCHAR2(10) NOT NULL	ECO Number
8	SUB_SUPPLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Subcontract Supply Y/N Table Edit Default Value: N
9	PENDING_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status ACT=Active PEN=Pending Default Value: ACT
10	NON_OWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o N=No Y=Yes Y/N Table Edit Default Value: N
11	TEARDOWN_FLAG	Character(1)	VARCHAR2(1) NOT NULL	01/28/99 jnw (CN#SF800-13) added field Y/N Table Edit
12	ROLLUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. Y/N Table Edit Default Value: N
13	BOM_QTY	Number(7,0)	INTEGER NOT NULL	06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard.