IT_RECON_SUMVW (SQL View)	Index Back
View for Portal View for Portal - Inventory Exceptions

IT_RECON_SUMVW

(SQL View)

View for Portal

View for Portal - Inventory Exceptions

SELECT A.OPRID , B.RULE_SEQ_NUM , A.RULE_ID , A.GROUP_COUNT , Z.CURRENCY_CD , Z.RT_TYPE , Z.FIN_AMT_DSPLY ,%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) , A.LASTUPDDTTM FROM %Table(IT_RECON_SUM) A , %Table(IT_RULE_DEFN) B , %Table(OPR_DEF_TBL_IT) Z , %Table(RT_DFLT_VW) F WHERE A.OPRID = Z.OPRID AND B.RULE_ID = A.RULE_ID AND B.ACTIVE_STATUS = 'A' 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)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_VW

2 RULE_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
Prompt Table: IT_RULE_DEFN

4 GROUP_COUNT Number(10,0) DECIMAL(10) NOT NULL Selected Count

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 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost

9 FMV Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair (Market) Value Amount

10 NET_BK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Book Value

11 LASTUPDDTTM 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN_VW
2	RULE_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID Prompt Table: IT_RULE_DEFN
4	GROUP_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Selected Count
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	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
9	FMV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair (Market) Value Amount
10	NET_BK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Book Value
11	LASTUPDDTTM	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.