CM_BOOK_PROF_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID ,B.CM_BOOK , A.CM_TYPE , A.CM_FLOW , A.CM_PROFILE_ID FROM PS_CM_PROFILE_DEFN A , PS_CM_GROUP_DETAIL B WHERE A.SETID = B.SETID AND A.CM_PROFILE_ID = B.CM_PROFILE_ID AND A.CM_TYPE = '1' AND A.CM_FLOW = '5' UNION SELECT A.SETID ,B.CM_BOOK , A.CM_TYPE , A.CM_FLOW , A.CM_PROFILE_ID FROM PS_CM_PROFILE_DEFN A , PS_CM_ITEM_METHOD B , PS_SET_CNTRL_REC C WHERE A.SETID = C.SETID AND A.CM_PROFILE_ID = B.CM_PROFILE_ID AND C.RECNAME = 'LED_DEFN_TBL' AND C.SETCNTRLVALUE = B.BUSINESS_UNIT AND A.CM_TYPE = '1' AND A.CM_FLOW = '5' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 3 | CM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
07/99 GMG CN800-9.0:
0=Non Cost 1=Actual 2=Std Cost |
| 4 | CM_FLOW | Character(2) | VARCHAR2(2) NOT NULL |
01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements
0=Non Cost 2=Lot ID 3=Serial ID 4=FIFO 5=LIFO |
| 5 | CM_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | 01/18/99 RML Created for CN800-9.0 FIFO/LIFO Enhancements |