AR_ITEM_AMT_VW

(SQL View)

SELECT SETID , BUSINESS_UNIT , CUST_ID , ITEM , ITEM_LINE , BAL_CURRENCY , ITEM_STATUS , BAL_AMT , DUE_DT , CASE WHEN DUE_DT < %CurrentDateIn THEN BAL_AMT ELSE 0 END , DOUBTFUL , CASE WHEN DOUBTFUL = 'Y' THEN BAL_AMT ELSE 0 END FROM PS_ITEM_DSP_VW WHERE ITEM_STATUS = 'O'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 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.

4 ITEM Character(30) VARCHAR2(30) NOT NULL Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.

5 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line

6 BAL_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code - Bal Amount

7 ITEM_STATUS Character(1) VARCHAR2(1) NOT NULL Item Status
C=Closed
O=Open

8 BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Item Balance

9 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

10 PASTDUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Past Due

11 DOUBTFUL Character(1) VARCHAR2(1) NOT NULL Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.

12 DOUBTFUL_AMOUNT Signed Number(17,2) DECIMAL(15,2) NOT NULL Doubtful Amount

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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.
4	ITEM	Character(30)	VARCHAR2(30) NOT NULL	Uniquely identifies an invoice credit memo or debit memo. The item ID is also called the invoice number.
5	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
6	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
7	ITEM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Item Status C=Closed O=Open
8	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
9	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
10	PASTDUE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Past Due
11	DOUBTFUL	Character(1)	VARCHAR2(1) NOT NULL	Identifies items ( or invoices ) which probably will not be paid by the customer. This status is used for items whose balances have been moved from the receivables account to the doubtful account using the transfer worksheet.
12	DOUBTFUL_AMOUNT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Doubtful Amount