KITCOMPSPRC_SRC

(SQL View)
 Index Back

Price by Kit Components Stagin

Product Kit Component Staging table.

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 ,STG.EFFDT ,STG.PROD_COMPONENT_ID ,STG.DATE_IN_EFFECT FROM PS_EO_EIP_CTL EO , PS_PROD_LOAD_ERR ERR , PS_KIT_COMPSPRC_MD STG WHERE EO.EIP_DTA_STATUS = '1' 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 = 'KIT_COMPSPRC_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 AND STG.PROD_COMPONENT_ID = ERR.KEY_CHAR_25_06 AND STG.EFFDT = ERR.KEY_DATE_01 AND STG.DATE_IN_EFFECT = ERR.KEY_DATE_02

# 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

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

9 EFFDT Date(10) DATE Effective Date

Default Value: %date

10 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID

Prompt Table: PROD_NOTKIT_VW

11 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label