TR_WR_TMPLT_FLD (SQL Table)	Index Back
Template Field List This record will contain the field names that the Templateer determines the wire room clerk may not update (because they will be grayed).

TR_WR_TMPLT_FLD

(SQL Table)

Template Field List

This record will contain the field names that the Templateer determines the wire room clerk may not update (because they will be grayed).

Parent record: TR_WR_TEMPLATE

# 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 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: TR_WR_FLDLST_VW

4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

5 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).

#	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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: TR_WR_FLDLST_VW
4	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
5	PNLNAME	Character(30)	VARCHAR2(30) NOT NULL	Page Name (see PSPNLDEFN).