PRODPRICEBU_SRC

(SQL View)
 Index Back

Product Price IBU header stag

Staging table for messaging.

SELECT DISTINCT STG.EIP_PROGRAM ,STG.EIP_CTL_ID ,ERR.FIELDNAME ,STG.SETID ,STG.PRODUCT_ID ,STG.UNIT_OF_MEASURE ,STG.BUSINESS_UNIT_IN ,STG.CURRENCY_CD FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR , PS_PROD_PRICEBU_MD STG WHERE EO.EIP_DTA_STATUS = '1' AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND ERR.EIP_PROGRAM = STG.EIP_PROGRAM AND ERR.EIP_CTL_ID = STG.EIP_CTL_ID AND ERR.RECNAME = 'PROD_PRICEBU_MD' AND EO.EIP_PROGRAM = ERR.EIP_PROGRAM AND EO.EIP_CTL_ID = ERR.EIP_CTL_ID AND ERR.EIP_PROGRAM = STG.EIP_PROGRAM AND ERR.EIP_CTL_ID = STG.EIP_CTL_ID AND ERR.RECNAME = 'PROD_PRICEBU_MD' AND STG.SETID = ERR.KEY_CHAR_25_01 AND STG.PRODUCT_ID = ERR.KEY_CHAR_25_02 AND STG.UNIT_OF_MEASURE = ERR.KEY_CHAR_25_03 AND STG.BUSINESS_UNIT_IN = ERR.KEY_CHAR_25_04 AND STG.CURRENCY_CD = ERR.KEY_CHAR_25_05

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_PROGRAM Character(10) VARCHAR2(10) NOT NULL Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync
701=BOM Sync
801=Item Revision
901=Item Bus Unit Sync
902=Item Sync

Default Value: OM_EIP_PRD_VW.EIP_PROGRAM

Prompt Table: OM_EIP_PRD_VW

2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

Prompt Table: OM_EIP_PRD2_VW

3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_ITEM

6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: PROD_UOM

7 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

Prompt Table: SP_BUOMIP_NONVW

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL