OM_RCPT_DAPL_VW

(SQL View)
 Index Back

Sales Order Deposit Applied

Customer Sales Order Deposit Applied Report VW

SELECT D.BUSINESS_UNIT , O.ORDER_NO , D.CUST_DEPOSIT_ID , SUM(D.AMOUNT) , SUM(D.AMOUNT_BSE) , D.CURRENCY_CD , D.CURRENCY_CD_BASE , A.INVOICE , D.DOC_REFNUM FROM %Table(ORD_DEPOSIT) O ,%Table(ORD_DEP_APP_VW1) D , %Table(ORD_DEP_ADD_VW) A WHERE O.BUSINESS_UNIT = D.BUSINESS_UNIT AND O.CUST_DEPOSIT_ID = D.CUST_DEPOSIT_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.CUST_DEPOSIT_ID = A.CUST_DEPOSIT_ID GROUP BY D.BUSINESS_UNIT , O.ORDER_NO, D.CUST_DEPOSIT_ID , D.CURRENCY_CD , D.CURRENCY_CD_BASE , A.INVOICE , D.DOC_REFNUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 CUST_DEPOSIT_ID Character(15) VARCHAR2(15) NOT NULL Customer Deposit ID
4 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
5 AMOUNT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
8 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
9 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number