AR_ACTN_FLTR_VW (SQL View)	Index Back
Action List filter Used for AR Workcenter

AR_ACTN_FLTR_VW

(SQL View)

Action List filter

Used for AR Workcenter

SELECT A.SETID , A.CUST_ID , A.BUSINESS_UNIT , A.CONDITION_ID , A.ASSN_OPRID , A.OWNER_TYPE , A.ACTION_CODE , A.ACTION_STATUS , D.ROLEUSER_SUPR , E.AR_SPECIALIST ,C.SUPPORT_TEAM_CD , C.COUNTRY , C.STATE , A.ANCHOR_AMOUNT , A.AMOUNT , E.BAL_AMT_BASE , A.PAY_PROMISE_AMT , A.PRIORITY , C.RISK_SCORE , A.DUE_DT , A.PROMISE_DT , A.DATE_ADDED , ' ' ,' ' ,' ' , ' ' FROM PS_ACT_CUST1_WCVW C , PS_ROLEXLATOPR D , PS_ACTION_LST A LEFT OUTER JOIN PS_ITEM_SPCLST_VW E ON A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.CUST_ID = E.CUST_ID AND A.ITEM = E.ITEM AND A.ITEM_LINE = E.ITEM_LINE WHERE A.SETID = C.SETID AND A.CUST_ID = C.CUST_ID AND A.ASSN_OPRID = D.OPRID AND A.ACTION_STATUS NOT IN ('SCA','SYS','CAN','CMP')

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 CONDITION_ID Character(4) VARCHAR2(4) NOT NULL Condition ID
ACLA=Approaching Credit Limit
ACLD=Approaching Credit Limit Exp
CCEX=Approaching CC expiration date
CCHD=Cancel Credit Hold
CFLU=Conversation Follow Up
CHLD=Credit Hold Code Exists
COLL=Collection
CPDB=Customer Promise Date Broken
CPDR=Customer Promise Date Review
DEDN=Deduction Item
DISP=Disputed Item
EBIL=eBill selection by user
ECLA=Exceeded Credit Limit
ECLD=Exceed CR Limit Expiration Dt
ETRC=Entry Type / Reason Code
KSTE=Key Statistics Exceeded
LACD=Large Amount Coming Due
ONLN=Online selection by user
RISK=Risk Score
WBDC=Welcome Back Dormant Customer
WCNC=Welcome New Customer

5 ASSN_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.

6 OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person

7 ACTION_CODE Character(4) VARCHAR2(4) NOT NULL Action Code
ALRT=Alert
CALL=Call the Customer
CRDT=Review Customer Credit Limit
DLTR=Dunning Letter
DNGD=Downgrade Credit Rating
FEBN=Follow up eBill Note
HOLD=Place Customer on Hold
OLTR=Send Other Letter
POD=Proof of Delivery
PRBK=Review Broken Promise Date
PRFO=Review Promise Date
REFR=Refer to Collection Agency
STMT=Send Statement of Account
WOFF=Write off Customer Balance

8 WC_ACTION_STATUS Character(3) VARCHAR2(3) NOT NULL Action Status
FUT=Future
NEW=New
PND=Pending
PRS=In Process

9 ROLEUSER_SUPR Character(30) VARCHAR2(30) NOT NULL Supervisor Role User

10 AR_SPECIALIST Character(8) VARCHAR2(8) NOT NULL Accounts Recievable Specialist - person responsible for an action on an item.

11 SUPPORT_TEAM_CD Character(6) VARCHAR2(6) NOT NULL Support Team Code

12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

13 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

14 ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.

15 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

16 BAL_AMT_BASE Signed Number(28,3) DECIMAL(26,3) NOT NULL Balance - Base Currency

17 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount

18 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

19 RISK_SCORE Number(3,0) SMALLINT NOT NULL Risk Score used in Receivables Collections Workbench

20 DUE_DT Date(10) DATE NOT NULL 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.

21 PROMISE_DT Date(10) DATE Promise Date

22 DATE_ADDED Date(10) DATE Date Added

23 REGION_CD_TYPE Character(4) VARCHAR2(4) NOT NULL Region Code Type
ACCT=Accounting
BO=Backorder/Reservation
CDOM=Contract Domain
CNTR=Contracts
FRT=Freight
MBR=Team Member
PRC=Pricing
RPT=Reporting
RS=Resource Management
SPRS=Procurement
SSRC=Alternate Sources Of Supply
TRPT=Transportation

24 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

25 CUST_GRP_TYPE Character(4) VARCHAR2(4) NOT NULL Customer Group Type
ACCT=Accounting
ALOC=Allocation Group
BO=Backorder/Reservations
CDT=Canceled Debt Reporting
CLMB=Claimback Contract
COLL=Collection
DD=Direct Debit
DRFT=Draft
FCST=Forecasting
FRT=Freight
PBIL=Pay/Bill Management
PRC=Pricing
PRUL=Pricing Arbitration Plan
RPT=Reporting
SCON=Buying Agreement
SSRC=Alternate Sources Of Supply
TAX=Tax
TRPT=Transportation

26 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

#	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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	CONDITION_ID	Character(4)	VARCHAR2(4) NOT NULL	Condition ID ACLA=Approaching Credit Limit ACLD=Approaching Credit Limit Exp CCEX=Approaching CC expiration date CCHD=Cancel Credit Hold CFLU=Conversation Follow Up CHLD=Credit Hold Code Exists COLL=Collection CPDB=Customer Promise Date Broken CPDR=Customer Promise Date Review DEDN=Deduction Item DISP=Disputed Item EBIL=eBill selection by user ECLA=Exceeded Credit Limit ECLD=Exceed CR Limit Expiration Dt ETRC=Entry Type / Reason Code KSTE=Key Statistics Exceeded LACD=Large Amount Coming Due ONLN=Online selection by user RISK=Risk Score WBDC=Welcome Back Dormant Customer WCNC=Welcome New Customer
5	ASSN_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
6	OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type A=Credit Analyst C=Collector O=Other R=AR Specialist S=Sales Person
7	ACTION_CODE	Character(4)	VARCHAR2(4) NOT NULL	Action Code ALRT=Alert CALL=Call the Customer CRDT=Review Customer Credit Limit DLTR=Dunning Letter DNGD=Downgrade Credit Rating FEBN=Follow up eBill Note HOLD=Place Customer on Hold OLTR=Send Other Letter POD=Proof of Delivery PRBK=Review Broken Promise Date PRFO=Review Promise Date REFR=Refer to Collection Agency STMT=Send Statement of Account WOFF=Write off Customer Balance
8	WC_ACTION_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Action Status FUT=Future NEW=New PND=Pending PRS=In Process
9	ROLEUSER_SUPR	Character(30)	VARCHAR2(30) NOT NULL	Supervisor Role User
10	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
11	SUPPORT_TEAM_CD	Character(6)	VARCHAR2(6) NOT NULL	Support Team Code
12	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
13	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
14	ANCHOR_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Principal amount of a given deal transaction denominated in the anchor currency.
15	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
16	BAL_AMT_BASE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Balance - Base Currency
17	PAY_PROMISE_AMT	Number(27,3)	DECIMAL(26,3) NOT NULL	Promise to Pay amount
18	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
19	RISK_SCORE	Number(3,0)	SMALLINT NOT NULL	Risk Score used in Receivables Collections Workbench
20	DUE_DT	Date(10)	DATE NOT NULL	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.
21	PROMISE_DT	Date(10)	DATE	Promise Date
22	DATE_ADDED	Date(10)	DATE	Date Added
23	REGION_CD_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Region Code Type ACCT=Accounting BO=Backorder/Reservation CDOM=Contract Domain CNTR=Contracts FRT=Freight MBR=Team Member PRC=Pricing RPT=Reporting RS=Resource Management SPRS=Procurement SSRC=Alternate Sources Of Supply TRPT=Transportation
24	REGION_CD	Character(10)	VARCHAR2(10) NOT NULL	Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
25	CUST_GRP_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Customer Group Type ACCT=Accounting ALOC=Allocation Group BO=Backorder/Reservations CDT=Canceled Debt Reporting CLMB=Claimback Contract COLL=Collection DD=Direct Debit DRFT=Draft FCST=Forecasting FRT=Freight PBIL=Pay/Bill Management PRC=Pricing PRUL=Pricing Arbitration Plan RPT=Reporting SCON=Buying Agreement SSRC=Alternate Sources Of Supply TAX=Tax TRPT=Transportation
26	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group