AR_ONACT_PYMNT3 (SQL View)	Index Back
On-accounts Payments Tile On-accounts Payments Tile

AR_ONACT_PYMNT3

(SQL View)

On-accounts Payments Tile

SELECT I.OPRID ,I.BUSINESS_UNIT ,I.CUST_ID ,I.SETID ,I.RESP_PART ,I.ENTRY_TYPE ,I.BAL_CURRENCY ,S.DISPLAY_CURRENCY ,S.RESP_TOP5_FLG ,SUM(I.ITEM_COUNT) ,SUM(I.BAL_AMT) , SUM(I.AMOUNT) FROM PS_AR_ONACT_PYMTS0 I ,PS_ARFO_PRF_ONACCT S WHERE S.OPRID = I.OPRID AND ( S.BU_SELECT_FLG = 'A' OR EXISTS( SELECT 'X' FROM PS_ARFO_PRFONAC_BU BU WHERE BU.OPRID = I.OPRID AND BU.BUSINESS_UNIT=I.BUSINESS_UNIT)) AND ( S.CUST_SELECT_FLG= 'S' AND ( S.CUST_LEVEL_QRY='N' AND EXISTS ( SELECT CUST.CUST_ID FROM PS_ARFO_PRFONA_CU2 CUST WHERE CUST.OPRID = I.OPRID AND CUST.CUSTOMER_SETID =I.CUSTOMER_SETID AND CUST.CUST_ID = I.CUST_ID ) OR S.CUST_LEVEL_QRY <> 'N' AND EXISTS ( SELECT CUST.CUST_ID FROM PS_ARFO_PRFONA_CUS CUST WHERE CUST.OPRID = I.OPRID AND ( CUST.CUSTOMER_SETID = I.CUSTOMER_SETID AND CUST.CUST_ID = I.CUST_ID )) ) ) AND ( S.RESP_TOP5_FLG <> 'S' OR EXISTS( SELECT 'X' FROM PS_ARFO_PRFONA_RSP R WHERE R.OPRID = S.OPRID AND R.OPRID = I.OPRID AND I.SETID=R.SETID AND I.RESP_PART=R.RESP_PART AND S.RESP_TOP5_FLG ='S' )) GROUP BY I.OPRID , I.BUSINESS_UNIT , I.CUST_ID , I.SETID ,I.RESP_PART ,I.ENTRY_TYPE , I.BAL_CURRENCY ,S.DISPLAY_CURRENCY,S.RESP_TOP5_FLG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDS_NONVW

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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

5 RESP_PART Character(15) VARCHAR2(15) NOT NULL Responsible Party

6 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.

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

8 DISPLAY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Display Currency
Prompt Table: CURRENCY_CD_TBL

9 RESP_TOP5_FLG Character(1) VARCHAR2(1) NOT NULL RESP_TOP5_FLG
A=All
S=Specific
T=Top Five
Default Value: T

10 ITEM_COUNT Number(5,0) INTEGER NOT NULL Item Count

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

12 DISPLAY_BAL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Display Balance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
5	RESP_PART	Character(15)	VARCHAR2(15) NOT NULL	Responsible Party
6	ENTRY_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.
7	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
8	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency Prompt Table: CURRENCY_CD_TBL
9	RESP_TOP5_FLG	Character(1)	VARCHAR2(1) NOT NULL	RESP_TOP5_FLG A=All S=Specific T=Top Five Default Value: T
10	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count
11	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
12	DISPLAY_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Display Balance