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

AR_ONACT_PYMNT6

(SQL View)

On-accounts Payments Tile

SELECT I.OPRID ,I.BUSINESS_UNIT ,I.SETID ,I.RESP_PART ,I.ENTRY_TYPE ,I.BAL_CURRENCY ,I.DISPLAY_CURRENCY ,I.RESP_TOP5_FLG ,SUM(I.ITEM_COUNT) ,SUM(I.BAL_AMT) ,SUM(I.AMOUNT) FROM PS_AR_ONACT_PYMTS0 I WHERE (I.CUST_SELECT_FLG = 'A' OR (I.CUST_SELECT_FLG = 'G' AND (I.BLK_CUST_GRP = 'Y' OR EXISTS ( SELECT 'X' FROM PS_ARFO_PFON_CSTGR CUST , PS_CUST_CGRP_LNK G WHERE I.OPRID = CUST.OPRID AND I.CUSTOMER_SETID = G.SETID AND I.CUST_ID = G.CUST_ID AND G.SETID = CUST.SETID AND G.CUST_GRP_TYPE = CUST.CUST_GRP_TYPE AND G.CUSTOMER_GROUP = CUST.CUSTOMER_GROUP ) ) ) ) AND ( I.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 ( I.RESP_TOP5_FLG <> 'S' OR EXISTS( SELECT 'X' FROM PS_ARFO_PRFONA_RSP R WHERE R.OPRID = I.OPRID AND I.SETID=R.SETID AND I.RESP_PART=R.RESP_PART AND I.RESP_TOP5_FLG = 'S' )) GROUP BY I.OPRID ,I.BUSINESS_UNIT ,I.SETID ,I.RESP_PART ,I.ENTRY_TYPE ,I.BAL_CURRENCY ,I.DISPLAY_CURRENCY,I.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 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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

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

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

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

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

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

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

11 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
4	RESP_PART	Character(15)	VARCHAR2(15) NOT NULL	Responsible Party
5	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.
6	BAL_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Currency Code - Bal Amount
7	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency Prompt Table: CURRENCY_CD_TBL
8	RESP_TOP5_FLG	Character(1)	VARCHAR2(1) NOT NULL	RESP_TOP5_FLG A=All S=Specific T=Top Five Default Value: T
9	ITEM_COUNT	Number(5,0)	INTEGER NOT NULL	Item Count
10	BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Item Balance
11	DISPLAY_BAL_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Display Balance