IMP_IT_PRO_RP_V

(SQL View)
 Index Back

Mapper for Oracle config.

This record gets the Recurring Price from Pricing record and passes it as attribute to Oracle's eBIZ CZ table.

SELECT A.SETID , 'RECURPRICE' , ('PKG' %Concat ':' %Concat A.CZ_REF_PART_NBR) , 'N' , 'RECURPRICE' , %Sql(TO_CHAR,B.LIST_PRICE) , 'Y' , 'RECURPRICE' , A.CZ_REF_PART_NBR , ('RECURPRICE' %Concat ':' %Concat A.CZ_REF_PART_NBR) , CZ_SEQUENCE_NUM , 708 FROM PS_IMP_IT_MASTER_V A , PS_EOEP_PRICE_LIST B , PS_CZ_SEQUENCE_NUM C WHERE B.RECURRING_FLG = 'Y' AND CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM) AND A.CZ_REF_PART_NBR = B.PRODUCT_ID AND A.SETID = B.SETID AND A.UNIT_OF_MEASURE = B.UNIT_OF_MEASURE

# 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.