CM_ITMACTCST_VW(SQL View) |
Index Back |
|---|---|
Actual item cost view08/11/99 RML Translate values changed in cm_method; 2,3,4,5 is replaced with value of 1. 05/03/99 RML Renamed from CM_ACTCSTITM_VW 04/20/99 RML CM800-9.0 LIFO/FIFO Cost Method Enhancements - view to show items with actual costs; used in Movement Detail by Depletion report (CMS2016) |
| SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , B.CM_SEQ_COST , SUM(CM_UNIT_COST) FROM PS_CM_RECEIPTS A , PS_CM_ACTUAL_COST B , PS_CM_ITEM_METH_VW C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.DT_TIMESTAMP = B.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND C.CM_METHOD ='1' GROUP BY A.BUSINESS_UNIT, A.INV_ITEM_ID, A.DT_TIMESTAMP, A.SEQ_NBR, B.CM_SEQ_COST |
| # | 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 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 4 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | CM_SEQ_COST | Number(15,0) | DECIMAL(15) NOT NULL | Cost Sequence Number. Incremented each time the actual cost is updated. |
| 6 | CM_UNIT_COST | Signed Number(27,15) | DECIMAL(25,15) NOT NULL | 07/99 GMG CN800-9.0: |