RUN_TRX1001 (SQL Table)	Index Back
Substitution Rule Report Substitution Rule report run control

RUN_TRX1001

(SQL Table)

Substitution Rule Report

Substitution Rule report run control

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

4 SUB_RULE_ID Character(20) VARCHAR2(20) NOT NULL The unique key identifier for a given accounting template substitution rule.
Prompt Table: SUB_RULE_ALL_VW

5 SOURCE_TYPE Character(1) VARCHAR2(1) NOT NULL Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD. 01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires 11/20/99 - MC - Added 'H' for Hedge Accounting 06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC Fees, Facility Fees, etc. 09/08/00 - RV - Changed Treasury Wires to EFT Requests. 07/15/04 - SD - Added 'P' for Investment Pools
B=BSP
D=Deals
F=Fees
H=Hedge Accounting
I=Interest
P=Investment Pools
W=EFT Requests

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
4	SUB_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	The unique key identifier for a given accounting template substitution rule. Prompt Table: SUB_RULE_ALL_VW
5	SOURCE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Categorizes Treasury Accounting Templates according to the type of transaction they process (badly named field). Keep this field in sync with TR_SOURCE_CD and TRA_SOURCE_CD. 01/11/99 - CMH - Removed 'A' from XLAT, will use 'W' for TR Wires 11/20/99 - MC - Added 'H' for Hedge Accounting 06/29/00 - RV - Changed 'F' to Fees. Fees now cover Deal Fees, LC Fees, Facility Fees, etc. 09/08/00 - RV - Changed Treasury Wires to EFT Requests. 07/15/04 - SD - Added 'P' for Investment Pools B=BSP D=Deals F=Fees H=Hedge Accounting I=Interest P=Investment Pools W=EFT Requests