RBC_TMPLT_LYOUT(SQL Table) |
Index Back |
---|---|
Files attached to TemplatesFiles 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 |