IT_RECON_SUM (SQL Table)	Index Back
Reconciliation Summary Reconciliation Summary by OPRID & RULE_ID

IT_RECON_SUM

(SQL Table)

Reconciliation Summary

Reconciliation Summary by OPRID & RULE_ID

# 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_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
Prompt Table: IT_RULE_DEFN

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

4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

5 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.

6 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost

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

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

9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

10 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_ID	Character(20)	VARCHAR2(20) NOT NULL	Rule ID Prompt Table: IT_RULE_DEFN
3	GROUP_COUNT	Number(10,0)	DECIMAL(10) NOT NULL	Selected Count
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
5	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.
6	COST	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Cost
7	FMV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Fair (Market) Value Amount
8	NET_BK_VALUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Net Book Value
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
10	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.