CM_RMATCH_S_VW

(SQL View)
 Index Back

RTV Matched Cost Summary Costs

RTV Matched Cost summed to Cost Element level.

SELECT BUSINESS_UNIT_RECV , RTV_ID , RTV_LN_NBR , RTV_DISTRIB_NUM , COST_ELEMENT , CM_SEQ_COST , CM_DTTM_IN_EFFECT , CM_DTTM_STAMP , BUSINESS_UNIT_IN , POSTED_FLAG , SUM(CM_UNIT_COST_PO) , SUM(CM_UNIT_COST_POVO) , SUM(CM_UNIT_COST_VO) FROM PS_CM_RMATCH_COST WHERE EFF_STATUS = 'A' GROUP BY BUSINESS_UNIT_RECV,RTV_ID, RTV_LN_NBR, RTV_DISTRIB_NUM, COST_ELEMENT, CM_SEQ_COST, CM_DTTM_IN_EFFECT , CM_DTTM_STAMP, BUSINESS_UNIT_IN, POSTED_FLAG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line
4 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
7 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
8 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
10 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
11 CM_UNIT_COST_PO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
12 CM_UNIT_COST_POVO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
13 CM_UNIT_COST_VO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0: