BUSINESS_UNITORDER_NOCUST_DEPOSIT_IDOM_RCPT_DCOL_VW(SQL View) |
Index Back |
|---|---|
Sales Order Deposit CollectedCustomer Sales Order Deposit Collected Report VW |
| SELECT D.BUSINESS_UNIT , O.ORDER_NO , D.CUST_DEPOSIT_ID , D.AMOUNT , D.AMOUNT_BSE , D.CURRENCY_CD , D.CURRENCY_CD_BASE , D.INVOICE , D.DOC_REFNUM FROM %Table(ORD_DEPOSIT) O , %Table(ORD_DEP_ADD_VW) D , %Table(CDR_RECEIPT) C WHERE O.BUSINESS_UNIT = D.BUSINESS_UNIT AND O.CUST_DEPOSIT_ID = D.CUST_DEPOSIT_ID AND D.DEPOSIT_BU = C.DEPOSIT_BU AND D.RECEIPT_NBR = C.RECEIPT_NBR AND C.RECEIPT_STATUS = 'NEW' |
| # | 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 |