IMP_IT_PRICE_VW

(SQL View)
 Index Back

Mapper for Oracle config.

This record maps to CZ_IMP_ITEM_PROPERTY_VALUE record in eBIZ database for Price only.

SELECT SETID , ATTRIBUTE_ID , CZ_PRODUCT_ID , ATTR_ITEM_ID , ATTRIBUTE_VALUE , ATTR_ITEM_VALUE , DEFAULT_FLG , CZ_FSK_PROPERTY_1 , CZ_FSK_ITEMMASTER , ORIG_SYS_REF , CZ_RUN_ID , CZ_SRC_APPLICATION FROM PS_IMP_IT_PRO_RP_V UNION SELECT SETID , ATTRIBUTE_ID , CZ_PRODUCT_ID , ATTR_ITEM_ID , ATTRIBUTE_VALUE , ATTR_ITEM_VALUE , DEFAULT_FLG , CZ_FSK_PROPERTY_1 , CZ_FSK_ITEMMASTER , ORIG_SYS_REF , CZ_RUN_ID , CZ_SRC_APPLICATION FROM PS_IMP_IT_PRO_PR_V

# 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.
2 ATTRIBUTE_ID Character(15) VARCHAR2(15) NOT NULL Attribute Label, Name or Properties
3 CZ_PRODUCT_ID Character(35) VARCHAR2(35) NOT NULL Oracle eBIZ configurator Product Identifier field.
4 ATTR_ITEM_ID Character(15) VARCHAR2(15) NOT NULL Attribute Item ID
5 ATTRIBUTE_VALUE Character(254) VARCHAR2(254) NOT NULL Attribute value
6 ATTR_ITEM_VALUE Character(50) VARCHAR2(50) NOT NULL Attribute drop-down item value
7 DEFAULT_FLG Character(1) VARCHAR2(1) NOT NULL Default Flag

Y/N Table Edit

Default Value: N

8 CZ_FSK_PROPERTY_1 Character(30) VARCHAR2(30) NOT NULL Foreign Surrogate key for Oracle Configurator Interface tables in eBIZ database.
9 CZ_FSK_ITEMMASTER Character(30) VARCHAR2(30) NOT NULL Foreign Surrogate key for Oracle Configurator Interface tables in eBIZ database.
10 ORIG_SYS_REF Character(100) VARCHAR2(100) NOT NULL CDH INTERFACE TABLE FIELD - ORIG_SYSTEM_REFERENCE
11 CZ_RUN_ID Number(30,0) DECIMAL(30) NOT NULL Oracle Configurator field RUN_ID in Oracle eBIZ database.
12 CZ_SRC_APPLICATION Number(3,0) SMALLINT NOT NULL Oracle Configurator interface table field in eBIZ database.