CWB_PROMISE_DVW (SQL View)	Index Back
Promise Inquiry Promise Inquiry

CWB_PROMISE_DVW

(SQL View)

Promise Inquiry

SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.CONVER_DTTM_INIT , A.CONVER_DT , A.PROMISE_DT , A.AR_PROMISE_STATUS , A.PAY_PROMISE_AMT , A.CURRENCY_CD , A.PROMISE_OVRIDE , A.AR_REASON_TYPE , B.COLLECTOR , A.SUP_REVIEW , A.FOLLOW_UP_OPRID FROM PS_CUST_CONVER_HDR A , PS_CUST_OPTION B WHERE A.PROMISE_TO_PAY = 'Y' AND A.CUST_ID = B.CUST_ID AND B.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_CUST_OPTION C_ED WHERE B.SETID = C_ED.SETID AND B.CUST_ID = C_ED.CUST_ID AND C_ED.EFFDT <= %CurrentDateIn)

# 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 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime

5 CONVER_DT Date(10) DATE Conversation Date

6 PROMISE_DT Date(10) DATE Promise Date

7 AR_PROMISE_STATUS Character(1) VARCHAR2(1) NOT NULL Promise Status field used in Collections Workbench
B=Broken
C=Cancelled
K=Kept
N=None
O=Open

8 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount

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

10 PROMISE_OVRIDE Character(1) VARCHAR2(1) NOT NULL CWB Override Promise Status
Y/N Table Edit

11 AR_REASON_TYPE Character(4) VARCHAR2(4) NOT NULL Override Reason
CNCL=Cancelled
INVP=Invalid Payment
PDOV=Promise Date Override
WRI=Wrong Items
WRP=Wrong Payment

12 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

13 SUP_REVIEW Character(1) VARCHAR2(1) NOT NULL Supervisor Review

14 FOLLOW_UP_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

#	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	CONVER_DTTM_INIT	DateTime(26)	TIMESTAMP	Initial Conversation DateTime
5	CONVER_DT	Date(10)	DATE	Conversation Date
6	PROMISE_DT	Date(10)	DATE	Promise Date
7	AR_PROMISE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Promise Status field used in Collections Workbench B=Broken C=Cancelled K=Kept N=None O=Open
8	PAY_PROMISE_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Promise to Pay amount
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	PROMISE_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	CWB Override Promise Status Y/N Table Edit
11	AR_REASON_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Override Reason CNCL=Cancelled INVP=Invalid Payment PDOV=Promise Date Override WRI=Wrong Items WRP=Wrong Payment
12	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
13	SUP_REVIEW	Character(1)	VARCHAR2(1) NOT NULL	Supervisor Review
14	FOLLOW_UP_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID