PRC_ORD_HDR_VW

(SQL View)
Index Back

Processing Order Template Hdr

Processing Order Template Header Add View.

SELECT PRC_ORD_TMPL_ID ,PRC_ORD_TMPL_TYPE ,PRC_ORD_TMPL_DESCR FROM PS_PRC_ORD_TMPL_HD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PRC_ORD_TMPL_ID Character(25) VARCHAR2(25) NOT NULL Processsing Order Template ID
2 PRC_ORD_TMPL_TYPE Character(2) VARCHAR2(2) NOT NULL Processing Order Template Type.
01=Contracts Limits

Default Value: 01

3 PRC_ORD_TMPL_DESCR Character(30) VARCHAR2(30) NOT NULL Processing Order Template Descirption