AGING_IDAGING_CATEGORYCSTAGING_SUM_VW(SQL View) |
Index Back |
|---|---|
Customer Aging FOCustomer Aging Financial Operation |
| SELECT D.AGING_ID , D.AGING_CATEGORY , C.DESCRSHORT , D.CURRENCY_CD , SUM(D.DISPLAY_AGING_AMT) , MAX(D.AGED_DT) FROM PS_CUST_AGINGFO_VW D , PS_AGING_CATEG_TBL C , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = D.BUSINESS_UNIT AND S.RECNAME = 'AGING_TBL' AND C.SETID = S.SETID AND C.AGING_ID = D.AGING_ID AND C.AGING_CATEGORY = D.AGING_CATEGORY AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_AGING_TBL C1 WHERE C1.SETID = C.SETID AND C1.AGING_ID = C.AGING_ID AND C1.EFFDT <= %CurrentDateIn ) GROUP BY D.AGING_ID, D.AGING_CATEGORY, C.DESCRSHORT, D.CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGING_ID |
Character(5) | VARCHAR2(5) NOT NULL | Aging ID |
| 2 | AGING_CATEGORY |
Character(2) | VARCHAR2(2) NOT NULL | Aging Category |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Item Balance |
| 6 | MAX_DATE | Date(10) | DATE | 10/09/01 EGS (CN#PL900-1): Added. |