SETIDPrompt Table: SP_SETID_NONVW
CM_GROUPPrompt Table: CM_GROUP_DEFN
CM_BOOKPrompt Table: CM_BOOK_DEFN
Prompt Table: CM_PROFILE_DEFN
Y/N Table Edit
Default Value: N
CM_GROUP_DETAIL(SQL Table) |
Index Back |
|---|---|
Group books and profiles01/18/99 RML CN800-9.0: Created new record to maintain group details for cost methods 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. 05/10/99 RML PeopleCode in CM_BOOK, SPr - removed winmessage code. 07/08/99 RML Changed PC - RIn - cm_diff_prof_vw to cm_overrides_vw |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
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 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table: CM_BOOK_DEFN |
| 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 |
| 5 | CM_OVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
Y/N Table Edit Default Value: N |