IMP_IT_MASTER_V

(SQL View)
 Index Back

Mapper record for eBIZ

Mapper record for Oracle eBIZ configurator database, CZ_ITEM_MASTER is Oracle side of mapper record.

SELECT A.SETID , ('PKG' %Concat ':' %Concat A.PRODUCT_ID) , A.DESCR , B.UNIT_OF_MEASURE , A.PRODUCT_ID , 1 , C.PRODUCT_GROUP , '0' , 708 , CZ_SEQUENCE_NUM , %subrec(RB_AUDIT_SBR, A) FROM PS_PROD_ITEM A , PS_PROD_UOM B , PS_PROD_PGRP_LNK C , PS_CZ_SEQUENCE_NUM D WHERE CZ_SEQUENCE_NUM = ( SELECT MAX(CZ_SEQUENCE_NUM) FROM PS_CZ_SEQUENCE_NUM) AND A.SETID = B.SETID AND A.PRODUCT_ID = B.PRODUCT_ID AND B.DFLT_UOM = 'Y' AND A.SETID = C.SETID AND A.PRODUCT_ID = C.PRODUCT_ID AND C.PROD_GRP_TYPE='CZ'

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

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 CZ_PRODUCT_ID Character(35) VARCHAR2(35) NOT NULL Oracle eBIZ configurator Product Identifier field.
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
5 CZ_REF_PART_NBR Character(30) VARCHAR2(30) NOT NULL Mapper field for CZ eBIZ Configurator table CZ_ITEM_MASTER with field name REF_PART_NBR.
6 CZ_QUOTEABLE_FLAG Number(1,0) SMALLINT NOT NULL Mapper record field for Oracle eBIZ configurator database with thable name CZ_ITEM_MASTER and field QUOTEABLE_FLAG.
7 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.
8 CZ_DECIMAL_QTY_FLG Character(1) VARCHAR2(1) NOT NULL Decimal Quantity Flag is denotes if a decimal quantity products can be ordered on Order Line. For now this flag is hardcoded to zero.
9 CZ_SRC_APPLICATION Number(3,0) SMALLINT NOT NULL Oracle Configurator interface table field in eBIZ database.
10 CZ_RUN_ID Number(30,0) DECIMAL(30) NOT NULL Oracle Configurator field RUN_ID in Oracle eBIZ database.
11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time