ORD_DEP_APP_VW (SQL View)	Index Back
Deposits Applied Customer Sales Order Deposits Applied

ORD_DEP_APP_VW

(SQL View)

Deposits Applied

Customer Sales Order Deposits Applied

SELECT BUSINESS_UNIT , CUST_DEPOSIT_ID , SUM(AMOUNT) ,CURRENCY_CD FROM PS_ORD_DEPOSIT_ACT WHERE DEPOSIT_ACTION = '2' GROUP BY BUSINESS_UNIT, CUST_DEPOSIT_ID, CURRENCY_CD

Parent record: ORD_DEPOSIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	CUST_DEPOSIT_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Deposit ID
3	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
4	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code