ACTLST_REASN_VW (SQL View)	Index Back
Deduction Action Table The Deduction Action Table stores many action records for each deduction.

ACTLST_REASN_VW

(SQL View)

Deduction Action Table

The Deduction Action Table stores many action records for each deduction.

SELECT A.SETID , A.CUST_ID , A.CONDITION_ID , A.CUST_HIST_ID , A.ENTRY_TYPE , A.ENTRY_REASON , A.BUSINESS_UNIT , A.SEQ_NBR , A.TMPLT_ID , A.PLAN_ID , A.COND_ROLE , A.ACTION_STATUS , A.CANCEL_REASON_CD , A.DATE_ADDED , A.PRIORITY , A.OWNER_TYPE , A.ACTION_OWNER , A.ACTION_CODE , A.ACTION_PARM , A.DELIVERY_METHOD , A.PROPOSED_AUTOMATED , A.AMOUNT , A.CURRENCY_CD , A.DATE_QUERY_VALUE , A.TRANS_COUNT , A.PERCENTAGE , A.ITEM , A.ITEM_LINE , A.ASSN_OPRID , A.NUM_PER , A.COMPLETION_DATE , A.LAST_OPRID , A.RULE_LEVEL , A.CONVER_DTTM_INIT , A.CONVER_DT , A.CONVER_SEQ_NUM , A.CONVER_DTTM , A.CONVR_QUALIFIER_CD , A.DUN_ID_NUM , A.ST_ID_NUM , A.DESCR100 , A.CRSPD_SETID , A.CRSPD_CUST_ID , A.CONTACT_ID , A.CNTCT_SEQ_NUM , A.DUE_DT , A.NOTIFY_FLAG , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.ESCAL_MGR_DT , A.ESCAL_OWNER_DT , A.ESCAL_SPSLST_DT , A.ESCAL_MGR_OPRID , A.ESCAL_OWNER_OPRID , A.ESCAL_SPSLST_OPRID , A.LAST_MAINT_DTTM , A.LAST_MAINT_OPRID , B.AR_SPECIALIST , B.CR_ANALYST , B.SALES_PERSON , B.COLLECTOR FROM PS_ACTION_LST A LEFT OUTER JOIN PS_ITEM B ON B.ITEM = A.ITEM AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.CUST_ID = A.CUST_ID AND B.ITEM_LINE = A.ITEM_LINE AND A.ACTION_STATUS IN ('NEW' , 'PND' ,'FUT')

# 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 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

4 CUST_HIST_ID Character(10) VARCHAR2(10) NOT NULL History ID

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 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."

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

8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

9 TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Template ID

10 PLAN_ID Number(15,0) DECIMAL(15) NOT NULL Plan ID

11 COND_ROLE Character(1) VARCHAR2(1) NOT NULL Condition Role
B=Bill To Customer
C=Corporate Customer
P=Correspondence Customer
R=Remit From Customer

12 ACTION_STATUS Character(3) VARCHAR2(3) NOT NULL Action Status
CAN=Cancelled
CMP=Completed
FUT=Future
NEW=New
PND=Pending
PRS=In Process
SCA=System Cancelled
SYS=System Completed

13 CANCEL_REASON_CD Character(2) VARCHAR2(2) NOT NULL Cancel Reason Code
HO=Credit Hold Exists
IC=Item Closed
NC=No Longer In Violation COLL RL
NV=No Longer in Violation
OP=Operator Cancelled
RC=Rule Owner Change
UP=Template Upgrade
ZB=Zero Balance

14 DATE_ADDED Date(10) DATE Date Added

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

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

17 ACTION_OWNER Character(30) VARCHAR2(30) NOT NULL Action Owner

18 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

19 ACTION_PARM Character(6) VARCHAR2(6) NOT NULL Action Parameter

20 DELIVERY_METHOD Character(1) VARCHAR2(1) NOT NULL Delivery Method
E=Email
F=Fax
P=Print

21 PROPOSED_AUTOMATED Character(1) VARCHAR2(1) NOT NULL Proposed/Automated
A=Automated
P=Proposed

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

23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

24 DATE_QUERY_VALUE Date(10) DATE Date Query Value

25 TRANS_COUNT Number(3,0) SMALLINT NOT NULL Transaction Count

26 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

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

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

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

30 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods

31 COMPLETION_DATE Date(10) DATE Completion Date

32 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator

33 RULE_LEVEL Character(1) VARCHAR2(1) NOT NULL Rule Level
C=Customer
G=Customer Group
S=SetID

34 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime

35 CONVER_DT Date(10) DATE Conversation Date

36 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number

37 CONVER_DTTM DateTime(26) TIMESTAMP Conversation DateTime

38 CONVR_QUALIFIER_CD Character(2) VARCHAR2(2) NOT NULL Conversation Qualifier Code
BA=Buy Agremt
BI=Invoice #
CP=Cust Pay
CT=Contract
D=Document
I=Item
L=Lading
P=PO Number
PY=Payment ID
QU=Quote
RM=RMA
SC=Case Num
SO=Sale Order

39 DUN_ID_NUM Number(8,0) INTEGER NOT NULL Dunning Number

40 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number

41 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

42 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

43 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

44 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

45 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

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

47 NOTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Recieve Notification

48 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

49 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

50 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

51 ESCAL_MGR_DT Date(10) DATE Esculate Manager Date

52 ESCAL_OWNER_DT Date(10) DATE Esculate Owner Date

53 ESCAL_SPSLST_DT Date(10) DATE Esculate Specialist Date

54 ESCAL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Date

55 ESCAL_OWNER_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Oper ID

56 ESCAL_SPSLST_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Specialist ID

57 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

58 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

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

60 CR_ANALYST Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.

61 SALES_PERSON Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.

62 COLLECTOR Character(8) VARCHAR2(8) NOT NULL Specifies the personnel code for the person who works with a customer to collect overdue payments.

#	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	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
4	CUST_HIST_ID	Character(10)	VARCHAR2(10) NOT NULL	History ID
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	ENTRY_REASON	Character(5)	VARCHAR2(5) NOT NULL	"Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."
7	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDS_NONVW
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
10	PLAN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Plan ID
11	COND_ROLE	Character(1)	VARCHAR2(1) NOT NULL	Condition Role B=Bill To Customer C=Corporate Customer P=Correspondence Customer R=Remit From Customer
12	ACTION_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Action Status CAN=Cancelled CMP=Completed FUT=Future NEW=New PND=Pending PRS=In Process SCA=System Cancelled SYS=System Completed
13	CANCEL_REASON_CD	Character(2)	VARCHAR2(2) NOT NULL	Cancel Reason Code HO=Credit Hold Exists IC=Item Closed NC=No Longer In Violation COLL RL NV=No Longer in Violation OP=Operator Cancelled RC=Rule Owner Change UP=Template Upgrade ZB=Zero Balance
14	DATE_ADDED	Date(10)	DATE	Date Added
15	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
16	OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type A=Credit Analyst C=Collector O=Other R=AR Specialist S=Sales Person
17	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner
18	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
19	ACTION_PARM	Character(6)	VARCHAR2(6) NOT NULL	Action Parameter
20	DELIVERY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Delivery Method E=Email F=Fax P=Print
21	PROPOSED_AUTOMATED	Character(1)	VARCHAR2(1) NOT NULL	Proposed/Automated A=Automated P=Proposed
22	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
23	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
24	DATE_QUERY_VALUE	Date(10)	DATE	Date Query Value
25	TRANS_COUNT	Number(3,0)	SMALLINT NOT NULL	Transaction Count
26	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
27	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.
28	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
29	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.
30	NUM_PER	Number(3,0)	SMALLINT NOT NULL	Number of Periods
31	COMPLETION_DATE	Date(10)	DATE	Completion Date
32	LAST_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Response Operator
33	RULE_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Rule Level C=Customer G=Customer Group S=SetID
34	CONVER_DTTM_INIT	DateTime(26)	TIMESTAMP	Initial Conversation DateTime
35	CONVER_DT	Date(10)	DATE	Conversation Date
36	CONVER_SEQ_NUM	Number(6,0)	INTEGER NOT NULL	Conversation Sequence Number
37	CONVER_DTTM	DateTime(26)	TIMESTAMP	Conversation DateTime
38	CONVR_QUALIFIER_CD	Character(2)	VARCHAR2(2) NOT NULL	Conversation Qualifier Code BA=Buy Agremt BI=Invoice # CP=Cust Pay CT=Contract D=Document I=Item L=Lading P=PO Number PY=Payment ID QU=Quote RM=RMA SC=Case Num SO=Sale Order
39	DUN_ID_NUM	Number(8,0)	INTEGER NOT NULL	Dunning Number
40	ST_ID_NUM	Number(8,0)	INTEGER NOT NULL	Statement Number
41	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
42	CRSPD_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
43	CRSPD_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Correspondence Customer
44	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
45	CNTCT_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Contact Sequence Number
46	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.
47	NOTIFY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Recieve Notification
48	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
49	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
50	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
51	ESCAL_MGR_DT	Date(10)	DATE	Esculate Manager Date
52	ESCAL_OWNER_DT	Date(10)	DATE	Esculate Owner Date
53	ESCAL_SPSLST_DT	Date(10)	DATE	Esculate Specialist Date
54	ESCAL_MGR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Owner Date
55	ESCAL_OWNER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Owner Oper ID
56	ESCAL_SPSLST_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Esculate Specialist ID
57	LAST_MAINT_DTTM	DateTime(26)	TIMESTAMP	A system generated value that reflects the date and time a transaction was last modified
58	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
59	AR_SPECIALIST	Character(8)	VARCHAR2(8) NOT NULL	Accounts Recievable Specialist - person responsible for an action on an item.
60	CR_ANALYST	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to establish credit limits and payment terms. This field is required for a bill-to customer.
61	SALES_PERSON	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
62	COLLECTOR	Character(8)	VARCHAR2(8) NOT NULL	Specifies the personnel code for the person who works with a customer to collect overdue payments.