MARKETDefault Value: OPR_DEF_TBL_RB.MARKET
ATTRIBUTE_IDIMP_IT_TY_PR_VW(SQL View) |
Index Back |
|---|---|
Attribute mapper recordeCRM Attribute mapper record maps to CZ_IMP_ITEM_TYPE_PROPERTY record in eBIZ db. |
| SELECT DISTINCT A.MARKET , B.ATTRIBUTE_ID , A.PRODUCT_GROUP , B.ATTRIBUTE_ID , (A.PRODUCT_GROUP %Concat ':' %Concat B.ATTRIBUTE_ID) , 708 , CZ_SEQUENCE_NUM FROM PS_PROD_PGRP_LNK A , PS_PROD_ATTR B , PS_CZ_SEQUENCE_NUM C WHERE A.PROD_GRP_TYPE='CZ' AND A.SETID= B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MARKET |
Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: OPR_DEF_TBL_RB.MARKET |
| 2 | ATTRIBUTE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Attribute Label, Name or Properties |
| 3 | CZ_FSK_ITEMTYPE_1 | Character(30) | VARCHAR2(30) NOT NULL | Foreign Surrogate Key in CZ eBIZ database pointing to IMP_ITEM_TYPE_PROPERTY table with FSK_ITEMTYPE_1_1 field. |
| 4 | CZ_FSK_PROPERTY_2 | Character(30) | VARCHAR2(30) NOT NULL | Foreign Surrogate Key in CZ eBIZ database pointing to IMP_ITEM_TYPE_PROPERTY table with FSK_PROPERTY_2_1 field. |
| 5 | ORIG_SYS_REF | Character(100) | VARCHAR2(100) NOT NULL | CDH INTERFACE TABLE FIELD - ORIG_SYSTEM_REFERENCE |
| 6 | CZ_SRC_APPLICATION | Number(3,0) | SMALLINT NOT NULL | Oracle Configurator interface table field in eBIZ database. |
| 7 | CZ_RUN_ID | Number(30,0) | DECIMAL(30) NOT NULL | Oracle Configurator field RUN_ID in Oracle eBIZ database. |