CUSTV_CYPROM_VW (SQL View)	Index Back
Customer Current Year Promises

CUSTV_CYPROM_VW

(SQL View)

Customer Current Year Promises

SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'B' THEN 1 ELSE 0 END) AS STATUS_B , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'O' THEN 1 ELSE 0 END) AS STATUS_O , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'K' THEN 1 ELSE 0 END) AS STATUS_K FROM PS_CUSTV_CONVER_VW A GROUP BY A.SETID , A.BUSINESS_UNIT , A.CUST_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW

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

4 PROM_BROKEN_TY Number(10,0) DECIMAL(10) NOT NULL Broken Promises

5 PROM_OPEN_TY Number(10,0) DECIMAL(10) NOT NULL Open Promises

6 PROM_KEPT_TY Number(10,0) DECIMAL(10) NOT NULL Kept Promises

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
3	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.
4	PROM_BROKEN_TY	Number(10,0)	DECIMAL(10) NOT NULL	Broken Promises
5	PROM_OPEN_TY	Number(10,0)	DECIMAL(10) NOT NULL	Open Promises
6	PROM_KEPT_TY	Number(10,0)	DECIMAL(10) NOT NULL	Kept Promises