PROD_TYPEAGR=Service Agreement
CMT=Commitment Product
ENG=Engagement Service
PHY=Standard Product
PKG=Package Product
SUB=Subscription Product
SVC=Service Product
LANGUAGE_CDRO_PK_PRTYP_VWL(SQL View) |
Index Back |
|---|---|
Pricing key for product typeLanguage table view for pricing key based on a Product type |
| SELECT A.FIELDVALUE , B.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'PROD_TYPE' AND A.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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | EOEP_CHAR | Character(254) | VARCHAR2(254) NOT NULL | Long field |