TR_WC_TMPALL_VW (SQL View)	Index Back
Approved TR Wire Templates View over the wire template table returning only those templates which have been approved.

TR_WC_TMPALL_VW

(SQL View)

Approved TR Wire Templates

View over the wire template table returning only those templates which have been approved.

SELECT SETID , TR_WR_TEMPLATE_ID , DESCR , REPETITVE_TRNFR_SW FROM PS_TR_WR_TEMPLATE

Related Language Record: TR_WR_TMPL_VW_L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 TR_WR_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit.

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 REPETITVE_TRNFR_SW Character(1) VARCHAR2(1) NOT NULL Repetitive Transfer Switch for Transfer Templates
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	TR_WR_TEMPLATE_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Wires / Treasury Wire Templates This uniquely identifies templates within a Business Unit.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	REPETITVE_TRNFR_SW	Character(1)	VARCHAR2(1) NOT NULL	Repetitive Transfer Switch for Transfer Templates Y/N Table Edit Default Value: N