AR_OVERDUE_VW

(SQL View)

SELECT SETID , CUST_ID , ' ' , SUM(BAL_AMT) , MAX(BAL_CURRENCY) , MAX(ACCOUNTING_DT) , 3 , 'Y' , MAX(BAL_CURRENCY) , MIN(BAL_CURRENCY) , SUM(BAL_AMT) , 0 FROM PS_ITEM_OP_DSP_VW WHERE DUE_DT < %CurrentDateIn AND ITEM_STATUS = 'O' GROUP BY SETID, CUST_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

3 AR_AMTDESC_TITLE Character(30) VARCHAR2(30) NOT NULL Amount Description

4 AR_AMOUNT_TITLE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

5 AR_CURRENCY_TITLE Character(3) VARCHAR2(3) NOT NULL Currency

6 AR_ASOFDATE_TITLE Date(10) DATE As of Date

7 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number

8 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes

9 MAX_CUR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 MIN_CUR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

11 TRAN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a transaction amount in bank reconciliation processing.

12 CONV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3	AR_AMTDESC_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Amount Description
4	AR_AMOUNT_TITLE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
5	AR_CURRENCY_TITLE	Character(3)	VARCHAR2(3) NOT NULL	Currency
6	AR_ASOFDATE_TITLE	Date(10)	DATE	As of Date
7	SEQUENCE_NBR	Number(2,0)	SMALLINT NOT NULL	Sequence Number
8	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag N=No Y=Yes
9	MAX_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	MIN_CUR_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
11	TRAN_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a transaction amount in bank reconciliation processing.
12	CONV_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount