CM_CST_BHLS_VW

(SQL View)
 Index Back

Costed Trans - Issue View

10/04/00 tw: This view was split from CM_CST_BEHLS_VW to avoid the Sybase maximum limit of 31 group-by expressions.

SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , B.CM_BOOK , B.DT_TIMESTAMP , B.SEQ_NBR , E.CM_DT_TIMESTAMP , E.CM_SEQ_NBR , E.CM_DT_TIMESTAMP_A , E.CM_SEQ_NBR_A , E.COST_ELEMENT , E.CM_SEQ_COST , C.SOURCE_BUS_UNIT , C.DESTIN_BU , E.QTY_BASE , %Round(E.CM_UNIT_COST,4) , C.UNIT_MEASURE_STD , B.POSTED_FLAG , B.PROCESS_INSTANCE , C.CM_BU_SOURCE_GL , C.CM_BU_SOURCE_GL , C.CM_BU_DESTIN_GL , D.BASE_CURRENCY FROM PS_CM_SHIPONB_BOOK B , PS_CM_SHIPONBEHALF C , PS_BUS_UNIT_TBL_GL D , PS_CM_DEPLETE_COST E WHERE %Join(common_keys, cm_shiponb_book b, cm_shiponbehalf c) AND %Join(common_keys, cm_deplete_cost e, cm_shiponbehalf c) AND D.BUSINESS_UNIT = C.CM_BU_DESTIN_GL AND B.POSTED_FLAG = 'N' AND B.TRANSACTION_GROUP IN ('034') AND B.CM_COST_MODE = 'L' AND B.CM_BOOK= E.CM_BOOK

# 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 NOT NULL 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 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
11 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
12 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
13 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit
14 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
15 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost
16 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
17 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
18 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
19 BUS_UNIT_GL_IBU Character(5) VARCHAR2(5) NOT NULL GL BU for other BU for IBU xfr
20 CM_BU_SOURCE_GL Character(5) VARCHAR2(5) NOT NULL 07/99 GMG CN800-9.0:
21 CM_BU_DESTIN_GL Character(5) VARCHAR2(5) NOT NULL 07/99 GMG CN800-9.0:
22 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code