AR_UNPYT_SUM_V1(SQL View) |
Index Back |
|---|---|
Summary Outstanding PaymentsSummary of Outstanding Payments |
| SELECT A.DEPOSIT_BU ,A.PAYMENT_METHOD ,A.PAYMENT_STATUS ,A.PAYMENT_CURRENCY ,COUNT(A.PAYMENT_ID) ,SUM(A.PAYMENT_AMT ) FROM PS_AR_AUNPYT_MVW A GROUP BY A.DEPOSIT_BU ,A.PAYMENT_METHOD ,A.PAYMENT_STATUS ,A.PAYMENT_CURRENCY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  DEPOSIT_BU |
Character(5) | VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW |
| 2 | PAYMENT_METHOD |
Character(3) | VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH CC=Credit Card CHK=Check CSH=Cash DD=Direct Debit DR=Draft EC=Electronic Check EFT=Electronic Fund Transfer GE=Giro - EFT PL=PayPal WIR=Wire Report |
| 3 | PAYMENT_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Payment Status
A=Applied B=Bounced C=Complete E=Identified - Express I=Identified J=Directly Journalled R=Unposted Direct Journal U=Unidentified W=Worksheet |
| 4 | TRANS_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 5 | PAYMENT_CNT | Number(5,0) | INTEGER NOT NULL | Payment count |
| 6 | TRANSACTION_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | The nominal or actual deal transaction amount. |