AR_OVERDUE_RSP

(SQL View)
Index Back

Recent Overdue Charges


SELECT C.SETID , C.CUST_ID , C.CRSPD_SETID , C.CRSPD_CUST_ID , O.OC_ID_NUM , O.OC_DT , SUM(OD.BAL_AMT) , OD.BAL_CURRENCY , 0 , %CurrentDateTimeIn , %OperatorId , %CurrentDateTimeIn , %OperatorId , 0 , %CurrentDateTimeIn FROM PS_CUSTOMER C , PS_OC_CUST O , PS_OC_CUST_DTL OD WHERE O.CRSPD_SETID = C.CRSPD_SETID AND O.CRSPD_CUST_ID = C.CRSPD_CUST_ID AND OD.CRSPD_SETID = C.CRSPD_SETID AND OD.CRSPD_CUST_ID = C.CRSPD_CUST_ID AND OD.OC_ID_NUM = O.OC_ID_NUM GROUP BY C.SETID, C.CUST_ID, C.CRSPD_SETID, C.CRSPD_CUST_ID, O.OC_ID_NUM, O.OC_DT, OD.BAL_CURRENCY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
3 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer
5 OC_ID_NUM Number(8,0) INTEGER NOT NULL Overdue Charge Number
6 OC_DT Date(10) DATE Overdue Charge Date
7 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance
8 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount
9 TOTAL_ROW_COUNT Number(8,0) INTEGER NOT NULL Total Row Count
10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP Added Date/Time
11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP Last Modified Date/Time
13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By
14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time