TD_PROMO_MER_VW (SQL View)	Index Back
Merch Activities for a promo Merch Activities for a promo and customer

TD_PROMO_MER_VW

(SQL View)

Merch Activities for a promo

Merch Activities for a promo and customer

SELECT A.SETID , A.CUST_ID , A.PPRC_PROMO_CD , A.MERCH_TYPE , B.DESCR FROM PS_TD_PRO_MERC_CUS A , PS_TD_MERCH_TYPE B , PS_SET_CNTRL_REC C WHERE C.SETID = B.SETID AND A.MERCH_TYPE = B.MERCH_TYPE AND B.EFF_STATUS = 'A' AND A.SETID = C.SETCNTRLVALUE AND C.RECNAME = 'TD_MERCH_TYPE' AND B.EFFDT <= ( SELECT MAX(EFFDT) FROM PS_TD_MERCH_TYPE B_ED WHERE B.SETID = B_ED.SETID AND B.MERCH_TYPE = B_ED.MERCH_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 PPRC_PROMO_CD Character(20) VARCHAR2(20) NOT NULL Price Promotion Code

4 MERCH_TYPE Character(10) VARCHAR2(10) NOT NULL Merchandising Type

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
4	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description