CWB_PDINQALL_VW (SQL View)	Index Back
Promises Inquiry - All Promises Inquiry Show All

CWB_PDINQALL_VW

(SQL View)

Promises Inquiry - All

Promises Inquiry Show All

SELECT A.SETID , A.BUSINESS_UNIT , A.CUST_ID , A.PROMISE_DT , A.AR_PROMISE_STATUS , A.PAY_PROMISE_AMT , A.CURRENCY_CD , A.PROMISE_OVRIDE , A.AR_REASON_TYPE , C.COLLECTOR , B.ROLEUSER_SUPR FROM PS_CUST_CONVER_HDR A , PS_ROLEXLATOPR B , PS_CUST_OPTION C WHERE A.PROMISE_TO_PAY = 'Y' AND A.OPRID = B.OPRID AND A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND C.EFFDT = ( SELECT MAX(C_ED.EFFDT) FROM PS_CUST_OPTION C_ED WHERE C.SETID = C_ED.SETID AND C.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 PROMISE_DT Date(10) DATE Promise Date

5 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

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

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

8 PROMISE_OVRIDE Character(1) VARCHAR2(1) NOT NULL CWB Override Promise Status

9 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

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

11 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

#	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	PROMISE_DT	Date(10)	DATE	Promise Date
5	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
6	PAY_PROMISE_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Promise to Pay amount
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	PROMISE_OVRIDE	Character(1)	VARCHAR2(1) NOT NULL	CWB Override Promise Status
9	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
10	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.
11	SUPERVISOR	Character(30)	VARCHAR2(30) NOT NULL	Supervisor