BUSINESS_UNITINV_ITEM_IDCM_BOOKPrompt Table: CM_BU_BOOK_TBL
Prompt Table: CM_PROFILE_DEFN
CM_ITEM_MTHD_VW(SQL View) |
Index Back |
|---|
| select business_unit, inv_item_id, cm_book, cm_profile_id from PS_CM_ITEM_METHOD |
| # | 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 |