CM_GROUP_DEFN (SQL Table)	Index Back
Group books and profiles 01/18/99 RML CM800-9.0: Created new record to support new cost method groups 03/19/99 RML CM800-9.0: In Use tab, changed control field from Business Unit to SetID since group tableset is used at SetID level and never at business unit level. This is necessary for Item Cost Profiles to work correctly in Item Attributes panel group.

CM_GROUP_DEFN

(SQL Table)

Group books and profiles

01/18/99 RML CM800-9.0: Created new record to support new cost method groups 03/19/99 RML CM800-9.0: In Use tab, changed control field from Business Unit to SetID since group tableset is used at SetID level and never at business unit level. This is necessary for Item Cost Profiles to work correctly in Item Attributes panel group.

Related Language Record: CM_GROUP_LANG

Parent Record Of CM_GROUP_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CM_GROUP Character(15) VARCHAR2(15) NOT NULL 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Prompt Table: CM_GROUP_DEFN

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

4 COMMENTS Long Character CLOB Comment

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CM_GROUP	Character(15)	VARCHAR2(15) NOT NULL	01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements Prompt Table: CM_GROUP_DEFN
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	COMMENTS	Long Character	CLOB	Comment