CM_UNDEPLETE_VW

(SQL View)
 Index Back

Depleted Undepletions View

Created to avoid Sybase group by limit of > 16.

SELECT BUSINESS_UNIT , INV_ITEM_ID , CM_BOOK , DT_TIMESTAMP , SEQ_NBR , MIN(CM_DT_TIMESTAMP_D) , MIN(CM_SEQ_NBR_D) , MIN(CM_DT_TIMESTAMP) , MIN(CM_SEQ_NBR) , CM_DT_TIMESTAMP_A , CM_SEQ_NBR_A , SUM(QTY_BASE) FROM PS_CM_UNDEPLETE GROUP BY BUSINESS_UNIT , INV_ITEM_ID , CM_BOOK , DT_TIMESTAMP , SEQ_NBR , CM_DT_TIMESTAMP_A , CM_SEQ_NBR_A

  • Parent record: CM_DEPLETION

    • # 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_D DateTime(26) TIMESTAMP Deplete Date Timestamp
    7 CM_SEQ_NBR_D Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
    9 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    10 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
    11 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
    12 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity