PL_PRDNOPT_HDR (SQL Table)	Index Back
Production Option Costing Hdr 07/09/99 WTK CN# EN800-6.0: Created for production option costing to store production option costing header data.

PL_PRDNOPT_HDR

(SQL Table)

Production Option Costing Hdr

07/09/99 WTK CN# EN800-6.0: Created for production option costing to store production option costing header data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 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).

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

5 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

6 LAST_ROLLUP_DTTM DateTime(26) TIMESTAMP Last Rollup Date/Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
3	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).
4	BOM_CODE	Number(2,0)	SMALLINT NOT NULL	CN# EN800-3.0, anna 09/21 added new field to database
5	RTG_CODE	Number(2,0)	SMALLINT NOT NULL	Routing Code
6	LAST_ROLLUP_DTTM	DateTime(26)	TIMESTAMP	Last Rollup Date/Time