CM_ITEM_METHOD (SQL Table)	Index Back
Cost books and profiles 09/28/99 RML If mfg_costed_flag (mfg item) is checked, cost profile can be non-cost or standard. 06/30/99 RML Added code to add cost books to inventory item only - RowInit and SaveEdit events. 06/11/99 RML Added code to FEd and SEd to validate all profiles - they must be standard cost for mfg costed items. 01/18/99 RML CM800-9.0: Created new record to maintain cost method profile for BU, item, and book. New record created for CN# CM800-9.0 to keep track off cost type, flow, and method for each business unit.

CM_ITEM_METHOD

(SQL Table)

Cost books and profiles

09/28/99 RML If mfg_costed_flag (mfg item) is checked, cost profile can be non-cost or standard. 06/30/99 RML Added code to add cost books to inventory item only - RowInit and SaveEdit events. 06/11/99 RML Added code to FEd and SEd to validate all profiles - they must be standard cost for mfg costed items. 01/18/99 RML CM800-9.0: Created new record to maintain cost method profile for BU, item, and book. New record created for CN# CM800-9.0 to keep track off cost type, flow, and method for each business unit.

Parent record: CM_BU_BOOK_TBL

# 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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
Prompt Table: CM_BU_BOOK_TBL

4 CM_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table: CM_PROFILE_DEFN

#	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	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book Prompt Table: CM_BU_BOOK_TBL
4	CM_PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements Prompt Table: CM_PROFILE_DEFN