CM_DEPLCOST2_VW

(SQL View)
 Index Back

Depletion cost by receipt

10/04/99 RML Modified view due to record changes in cm_deplete and cm_deplete_cost 09/20/99 RML Removed cm_seq_deplete and eff_status Created on 05/19/99 RML for CM800-9.0 Used in movement report - Sum of depletion of receipt line

SELECT business_unit , cm_book , inv_Item_id , cm_dt_timestamp , cm_seq_nbr , cm_dt_timestamp_a , cm_seq_nbr_a , %Round(SUM(%DecMult(qty_base,cm_unit_cost)),4) FROM PS_CM_DEPLETE_COST GROUP BY business_unit , cm_book , inv_Item_id , cm_dt_timestamp , cm_seq_nbr , cm_dt_timestamp_a , cm_seq_nbr_a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
5 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
7 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
8 CM_DEPLETE_COST Number(15,4) DECIMAL(14,4) NOT NULL 05/19/99 RML Created for CM800-9.0 for Movement by Receipt Line report.