PROD_PRICE_EFF (SQL View)	Index Back
Product Prices by IBU Eff This record stores the list price by Unit of Measure for each Inventory Business Unit. It is a child of the PROD_PRICE_BU record. This is used for PRODUCT_FULLSYNC_EFF message.

PROD_PRICE_EFF

(SQL View)

Product Prices by IBU Eff

This record stores the list price by Unit of Measure for each Inventory Business Unit. It is a child of the PROD_PRICE_BU record. This is used for PRODUCT_FULLSYNC_EFF message.

SELECT SETID ,PRODUCT_ID ,UNIT_OF_MEASURE ,BUSINESS_UNIT_IN ,CURRENCY_CD ,EFFDT ,EFF_STATUS ,LIST_PRICE ,UNIT_COST ,SERVICE_COST ,REPAIR_COST ,MFG_SUG_RTL_PRC ,PRICING_FLAG ,DATETIME_ADDED ,LASTUPDDTTM ,LAST_MAINT_OPRID FROM PS_PROD_PRICE X WHERE EFF_STATUS = 'A' AND %EffdtCheck(PROD_PRICE Y, X, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Prompt Table: SP_SETID_NONVW

2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: PROD_BU_ITM_VW

3 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

4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
Prompt Table: SP_BUOMIP_NONVW

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

6 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

8 LIST_PRICE Signed Number(17,4) DECIMAL(15,4) NOT NULL List Price

9 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost

10 SERVICE_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Service Cost

11 REPAIR_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Repair Cost

12 MFG_SUG_RTL_PRC Number(16,4) DECIMAL(15,4) NOT NULL Manufactures's Suggested Retai

13 PRICING_FLAG Character(1) VARCHAR2(1) NOT NULL Pricing Flag
C=Cost
L=List Price

14 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

15 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

16 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: PROD_BU_ITM_VW
3	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
4	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit Prompt Table: SP_BUOMIP_NONVW
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
7	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
8	LIST_PRICE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	List Price
9	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
10	SERVICE_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Service Cost
11	REPAIR_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Repair Cost
12	MFG_SUG_RTL_PRC	Number(16,4)	DECIMAL(15,4) NOT NULL	Manufactures's Suggested Retai
13	PRICING_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Pricing Flag C=Cost L=List Price
14	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID