IMP_LN_PDESCR_V(SQL View) |
Index Back |
|---|---|
Localization record for eBIZLocalization record for eBIZ and eCRM product data model mapping. |
| SELECT A.CZ_RUN_ID , C.CZ_LOCALE_ID , B.DESCR , C.CZ_ISO_LANGUAGE , C.CZ_ISO_LANGUAGE , A.CZ_PRODUCT_ID FROM PS_IMP_IT_MASTER_V A , PS_PROD_ITEM_LNG B , PS_CZ_FND_LANGUAGE C WHERE A.CZ_REF_PART_NBR = B.PRODUCT_ID AND A.SETID = B.SETID AND B.LANGUAGE_CD = C.CZ_ISO_LANGUAGE_3 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CZ_RUN_ID | Number(30,0) | DECIMAL(30) NOT NULL | Oracle Configurator field RUN_ID in Oracle eBIZ database. |
| 2 | CZ_LOCALE_ID | Number(3,0) | SMALLINT NOT NULL | Stores Locale Id mapped from Oracle eBIZ Configurator table. |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | CZ_ISO_LANGUAGE | Character(2) | VARCHAR2(2) NOT NULL | Language code field for eBIZ Oracle Configurator. |
| 5 | CZ_ISO_LANGUAGE2 | Character(2) | VARCHAR2(2) NOT NULL | Language code field for eBIZ Oracle Configurator. |
| 6 | CZ_PRODUCT_ID | Character(35) | VARCHAR2(35) NOT NULL | Oracle eBIZ configurator Product Identifier field. |