PROD_TYPEAGR=Service Agreement
CMT=Commitment Product
ENG=Engagement Service
PHY=Standard Product
PKG=Package Product
SUB=Subscription Product
SVC=Service Product
RO_PK_PRDTYP_VW(SQL View) |
Index Back |
|---|---|
Pricing key for Product typeView for pricing key based on a Product type |
| SELECT FIELDVALUE , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME = 'PROD_TYPE' AND FIELDVALUE <> 'PKG' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |