TD_RETINCUR_VW (SQL View)	Index Back
Incurred Amount View Incurred Amount View

TD_RETINCUR_VW

(SQL View)

Incurred Amount View

SELECT DISTINCT A.SETID , A.PPRC_PROMO_CD , A.MERCH_TYPE , A.CUST_ID , SUM(A.AMOUNT) FROM PS_TD_FIN_DATA A WHERE (A.TD_CHECK_COL_CUST = 'IB' OR A.TD_CHECK_COL_CUST = 'II' OR A.TD_CHECK_COL_CUST = 'IL' OR A.TD_CHECK_COL_CUST = 'IH' OR A.TD_CHECK_COL_CUST = 'IV') GROUP BY A.SETID, A.PPRC_PROMO_CD, A.MERCH_TYPE, A.CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	PPRC_PROMO_CD	Character(20)	VARCHAR2(20) NOT NULL	Price Promotion Code
3	MERCH_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Merchandising Type
4	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.
5	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount