CWB_PDINQGRP_VW

(SQL View)
Index Back

Promises Inquiry - Grouping

Promises Inquiry Grouping Data populated from CWB_PDINQALL_VW called from CWB_CONVR_PROMISES:Promises App Package SelectPromises method ================================= SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.COLLECTOR , A.SUPERVISOR , COUNT(CASE WHEN A.AR_PROMISE_STATUS = 'B' THEN A.AR_PROMISE_STATUS ELSE NULL END) , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'B' THEN A.PAY_PROMISE_AMT ELSE 0 END) , COUNT(CASE WHEN A.AR_PROMISE_STATUS = 'K' THEN A.AR_PROMISE_STATUS ELSE NULL END) , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'K' THEN A.PAY_PROMISE_AMT ELSE 0 END) , COUNT(CASE WHEN A.AR_PROMISE_STATUS = 'O' THEN A.AR_PROMISE_STATUS ELSE NULL END) , SUM(CASE WHEN A.AR_PROMISE_STATUS = 'O' THEN A.PAY_PROMISE_AMT ELSE 0 END) , A.CURRENCY_CD FROM PS_CWB_PDINQALL_VW A WHERE A.AR_PROMISE_STATUS <> 'C'

SELECT SETID , 'BU' , 'CUST' , 'COLL' , 'SUP' , 0 , 0 , 0 , 0 , 0 , 0 , CURRENCY_CD FROM PS_CWB_PDINQALL_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.
5 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor
6 BROKEN_COUNT Number(6,0) INTEGER NOT NULL Count for Broken Promises
7 BROKEN_SUM Number(15,2) DECIMAL(14,2) NOT NULL Sum of Broken Promises
8 KEPT_COUNT Number(6,0) INTEGER NOT NULL Count for Kept Promises
9 KEPT_SUM Number(15,2) DECIMAL(14,2) NOT NULL Sum of Kept Promises
10 OPEN_COUNT Number(6,0) INTEGER NOT NULL Count for Open Promises
11 OPEN_SUM Number(15,2) DECIMAL(14,2) NOT NULL Sum of Open Promises
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code