SPB_EMAIL_PARM (SQL Table)	Index Back
Email parameters Store record/field information, used as tokens in email templates

SPB_EMAIL_PARM

(SQL Table)

Email parameters

Store record/field information, used as tokens in email templates

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMAILTEMPLATE Character(10) VARCHAR2(10) NOT NULL Email Template

2 ID_SEQ_ITEM Number(5,0) INTEGER NOT NULL Sequence control for ITEM

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

4 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_SUPPLIER_EC
06=ITM_SUPP_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
13=EN_REVISION_EC
14=ITEM_MFG_GPO_EC
15=ITEM_MFG_EC
16=ITEM_CAT_EC
Prompt Table: SPB_EMAIL_P_REC
Set Control Field: RECORDNAME

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: SPB_EMAIL_P_FLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMAILTEMPLATE	Character(10)	VARCHAR2(10) NOT NULL	Email Template
2	ID_SEQ_ITEM	Number(5,0)	INTEGER NOT NULL	Sequence control for ITEM
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	RECORDNAME	Character(15)	VARCHAR2(15) NOT NULL	Record Name 01=MASTER_ITEM_EC 02=INV_ITEMS_EC 03=BU_ITM_INV_EC 04=BU_ITM_WTVL_EC 05=ITEM_SUPPLIER_EC 06=ITM_SUPP_LOC_EC 07=ITM_VNDR_UOM_EC 08=ITM_VND_UMPR_EC 09=INV_ITM_UOM_EC 10=PUR_ITM_ATTR_EC 13=EN_REVISION_EC 14=ITEM_MFG_GPO_EC 15=ITEM_MFG_EC 16=ITEM_CAT_EC Prompt Table: SPB_EMAIL_P_REC Set Control Field: RECORDNAME
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: SPB_EMAIL_P_FLD