AR_APYMNT_MVW(SQL View) |
Index Back |
|---|---|
Payment Tile ViewPayment Tile View |
| SELECT A.DEPOSIT_BU ,COUNT(A.PAYMENT_ID) ,SUM(A.PAY_AMT) ,A.PAYMENT_CURRENCY ,SUM(A.BASE_AMT) ,A.CURRENCY_CD ,A.DAYS ,A.POST_DT ,A.ACCOUNTING_DT ,A.PAYMENT_METHOD ,COUNT(*) FROM PS_AR_PYMNT_MV_VW A ,PS_OPI_SYSCFG_TBL1 C WHERE A.PAYMENT_STATUS='C' AND A.POST_DT IS NOT NULL AND A.POST_DT >=A.ENTRY_DT AND C.PRODUCT_OE='ALL' AND A.POST_DT BETWEEN C.FROM_DT AND C.TO_DT GROUP BY A.DEPOSIT_BU,A.PAYMENT_CURRENCY,A.CURRENCY_CD ,A.DAYS ,A.POST_DT,A.ACCOUNTING_DT,A.PAYMENT_METHOD |
| # | 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.
Prompt Table: SP_BUARDE_NONVW |
| 2 | PAYMENT_CNT | Number(5,0) | INTEGER NOT NULL | Payment count |
| 3 | PAY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Payment Amount |
| 4 | PAYMENT_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
Prompt Table: AR_PAY_CUR_VW |
| 5 | BASE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents a transaction amount calculated and stored in the base currency of its associated General Ledger bus |
| 6 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | DAYS |
Number(6,0) | INTEGER NOT NULL | Days |
| 8 | POST_DT |
Date(10) | DATE | The Date a transaction was Posted. |
| 9 | ACCOUNTING_DT |
Date(10) | DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: DEPOSIT_CONTROL.ACCOUNTING_DT |
| 10 | 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 |
| 11 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |