WM_DISTTMPL_ADD

(SQL View)
Index Back

Distribution Template Defn


SELECT BUSINESS_UNIT , DISTR_TMPL , DESCR , DESCRSHORT FROM PS_WM_DIST_TMPL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_WM

2 DISTR_TMPL Character(10) VARCHAR2(10) NOT NULL Distribution Template Field
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description