PL_PROD_SRC_TMP (SQL Table)	Index Back
Production Options 04/21/99 RAG CN#PL800-31. Planning Inquiries 12/13/01 EGS (CN#PL900-1): Can be deleted.

PL_PROD_SRC_TMP

(SQL Table)

Production Options

04/21/99 RAG CN#PL800-31. Planning Inquiries 12/13/01 EGS (CN#PL900-1): Can be deleted.

# 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: MG_ITEM_PDO_VW

3 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
Prompt Table: EN_BOM_HDRBC_VW

4 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
Prompt Table: SF_PRDN_AREA_VW

5 SEL Character(1) VARCHAR2(1) NOT NULL Select
Y/N Table Edit

6 PL_ROW_EXIST Character(1) VARCHAR2(1) NOT NULL Row Exist
Y/N Table Edit

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 PL_UNIT_COST Signed Number(19,4) DECIMAL(17,4) NOT NULL 09/27/02 EGS (CN#PL880-1): Changed to 13.4

9 PL_BATCH_COST Signed Number(17,2) DECIMAL(15,2) NOT NULL Batch Cost

10 MG_ASSOCIATED_BOM Character(18) VARCHAR2(18) NOT NULL 04/99 LAJ CN#EN800.6.0 Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).

#	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: MG_ITEM_PDO_VW
3	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database Prompt Table: EN_BOM_HDRBC_VW
4	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code Prompt Table: SF_PRDN_AREA_VW
5	SEL	Character(1)	VARCHAR2(1) NOT NULL	Select Y/N Table Edit
6	PL_ROW_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Row Exist Y/N Table Edit
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	PL_UNIT_COST	Signed Number(19,4)	DECIMAL(17,4) NOT NULL	09/27/02 EGS (CN#PL880-1): Changed to 13.4
9	PL_BATCH_COST	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Batch Cost
10	MG_ASSOCIATED_BOM	Character(18)	VARCHAR2(18) NOT NULL	04/99 LAJ CN#EN800.6.0 Necessary for new CPG functionality. It stores the assembly item that is the primary method for producing secondary co-products. This field defaults to the assembly item (itself).