CM_DEPLCOST_VW

(SQL View)
 Index Back

Depletion cost by deplete line

Created on 05/19/99 RML for CM800-9.0 Used in movement report 09/20/99 RML Removed cm_seq_deplete and eff_status 05/30/00 RML Changed cm_dt_timestamp_a and cm_seq_nbr_a to key fields. Added cm_unit_cost - total cost for each depletion. Purpose is to show unit cost by depletion in report.

SELECT business_unit , inv_Item_id , cm_book , dt_timestamp , seq_nbr , cm_dt_timestamp , cm_seq_nbr , cm_dt_timestamp_a , cm_seq_nbr_a , SUM(cm_unit_cost) , %Round(SUM(%DecMult(qty_base,cm_unit_cost)),4) FROM PS_CM_DEPLETE_COST GROUP BY business_unit , inv_Item_id , cm_book , dt_timestamp , seq_nbr , 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
7 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
9 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
10 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
11 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.