IT_UNDISC_SUMDS

(SQL View)
 Index Back

Aging Inventory


SELECT A.OPRID , A.IT_TIMESPAN_ID , A.IT_TIMESPAN_SEQ , A.IT_SUBTYPE , Z.CURRENCY_CD , Z.RT_TYPE , Z.FIN_AMT_DSPLY , A.QUANTITY , %Round(%DecDiv(%DecMult(%DecDiv(%DecMult(A.COST,1.0), F.RATE_DIV), F.RATE_MULT),Z.FIN_AMT_DSPLY),3) , %Round(%DecDiv(%DecMult(%DecDiv(%DecMult(A.FMV,1.0), F.RATE_DIV), F.RATE_MULT),Z.FIN_AMT_DSPLY),3) , %Round(%DecDiv(%DecMult(%DecDiv(%DecMult(A.NET_BK_VALUE,1.0), F.RATE_DIV), F.RATE_MULT),Z.FIN_AMT_DSPLY),3) , TSPAN.DESCRSHORT , CASE WHEN STYPE.DESCR15 IS NULL THEN (%Substring(MSG.MESSAGE_TEXT, 1, 15)) ELSE STYPE.DESCR15 END , A.DTTM_STAMP FROM %Table(IT_UNDISC_SUM) A LEFT OUTER JOIN %Table(IT_SUBTYPE) STYPE ON A.IT_SUBTYPE = STYPE.IT_SUBTYPE , %Table(IT_TSPAN_DTL) TSPAN , %Table(OPR_DEF_TBL_IT) Z , %Table(RT_DFLT_VW) F , PSMSGCATDEFN MSG WHERE %Join(Common_Keys, IT_UNDISC_SUM A,IT_TSPAN_DTL TSPAN) AND A.OPRID = Z.OPRID AND F.FROM_CUR = A.CURRENCY_CD AND F.TO_CUR = Z.CURRENCY_CD AND F.RT_TYPE = Z.RT_TYPE AND F.EFFDT = ( SELECT MAX(G.EFFDT) FROM PS_RT_DFLT_VW G WHERE G.FROM_CUR = F.FROM_CUR AND G.TO_CUR = F.TO_CUR AND G.RT_TYPE = F.RT_TYPE AND G.EFFDT <= %CurrentDateIn) AND MESSAGE_SET_NBR = 8770 AND MESSAGE_NBR = 128

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 IT_TIMESPAN_ID Character(15) VARCHAR2(15) NOT NULL Inventory Age
3 IT_TIMESPAN_SEQ Number(5,0) INTEGER NOT NULL Inventory Age Seq
4 IT_SUBTYPE Character(15) VARCHAR2(15) NOT NULL IT Subtype
5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
6 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
7 AMT_DISPLAY_IN Number(9,0) DECIMAL(9) NOT NULL Amount display in ex: 1000 or 1000000
8 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
9 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
10 FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair (Market) Value Amount
11 NET_BK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value
12 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
13 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
14 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.