RBC_TMPLT_LYOUT

(SQL Table)
Index Back

Files attached to Templates

Files attached to Templates The record is not be used by any page.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RB_TEMPLATE_NAME Character(30) VARCHAR2(30) NOT NULL Template Name
2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
3 RB_DELV_CHANNEL Character(1) VARCHAR2(1) NOT NULL Delivery Channel. Please make sure to update the RB_DELV_CHANNEL2 field with the XLAT values in future when Fax channel is enabled. RB_DELV_CHANNEL2 field is used in the Correspondence search.
0=All
1=Email
2=Print
3=Fax
4=Print & Fax
4 RB_TEMPLATE_ID Number(10,0) DECIMAL(10) NOT NULL Template ID
5 RB_LAYOUT_TYPE Character(1) VARCHAR2(1) NOT NULL Internal Layout Type
D=DOC
I=Internal
T=TXT

Default Value: I

6 RB_ILAYOUT_NAME Character(30) VARCHAR2(30) NOT NULL Internal Layout (Template) Name
7 RB_ELAYOUT_ID Number(10,0) DECIMAL(10) NOT NULL External File Name
8 RB_ILAYOUT_ID Number(10,0) DECIMAL(10) NOT NULL Internal Layout (Template)
9 FILEDIRECTORY Character(80) VARCHAR2(80) NOT NULL File directory
10 RB_ELAYOUT_NAME Character(30) VARCHAR2(30) NOT NULL External File Name
11 ATTACHEDFILE Character(1) VARCHAR2(1) NOT NULL Attached File Name
12 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
13 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File