SETIDPrompt Table: SP_SETID_NONVW
PROD_TYPEAGR=Service Agreement
CMT=Commitment Product
ENG=Engagement Service
PHY=Standard Product
PKG=Package Product
SUB=Subscription Product
SVC=Service Product
Prompt Table: RO_DISP_TMP_VW
PROD_DISP_TMPL(SQL Table) |
Index Back |
|---|---|
Product Display TemplateProduct Display Template. It is used for displaying the product templates |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 2 | PROD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
A new field has been introduced as Product Type to distingush the product types like, Physical Products and Service Products. It is used for PDM enhancement.
AGR=Service Agreement CMT=Commitment Product ENG=Engagement Service PHY=Standard Product PKG=Package Product SUB=Subscription Product SVC=Service Product |
| 3 | PROD_TYPE_LONG | Character(40) | VARCHAR2(40) NOT NULL | A new field has been introduced as Product Type to distingush the produc types like, Physical Product, Service Product etcs. It is used for PDM enhancement |
| 4 | PROD_DISP_TMPL_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template identifier to define the display template.
Prompt Table: RO_DISP_TMP_VW |