ACTION_LST

(SQL Table)
Index Back

Action List Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW
Set Control Field: 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.

Prompt Table: CUST_SRCH_VW

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

Default Value: .

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.

Default Value: .

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

Default Value: .

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

Default Value: OPR_DEF_TBL_FS.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 ACTION_DT Date(10) DATE Action Date
16 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
17 OWNER_TYPE Character(1) VARCHAR2(1) NOT NULL Collection Owner Type
A=Credit Analyst
C=Collector
O=Other
R=AR Specialist
S=Sales Person
18 ACTION_OWNER Character(30) VARCHAR2(30) NOT NULL Action Owner
19 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

Prompt Table: AR_ACTN_CD3_VW

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

Prompt Table: %EDITTABLE11

21 DELIVERY_METHOD Character(1) VARCHAR2(1) NOT NULL Delivery Method
E=Email
F=Fax
P=Print
22 PROPOSED_AUTOMATED Character(1) VARCHAR2(1) NOT NULL Proposed/Automated
A=Automated
P=Proposed
23 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
24 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 DATE_QUERY_VALUE Date(10) DATE Date Query Value
27 TRANS_COUNT Number(3,0) SMALLINT NOT NULL Transaction Count
28 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
29 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.
30 ITEM_LINE Number(6,0) INTEGER NOT NULL Item Line
31 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.

Prompt Table: %EDITTABLE10

32 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods
33 COMPLETION_DATE Date(10) DATE Completion Date
34 LAST_OPRID Character(30) VARCHAR2(30) NOT NULL Last Response Operator
35 RULE_LEVEL Character(1) VARCHAR2(1) NOT NULL Rule Level
C=Customer
G=Customer Group
S=SetID
36 CONVER_DTTM_INIT DateTime(26) TIMESTAMP Initial Conversation DateTime
37 CONVER_DT Date(10) DATE Conversation Date
38 CONVER_SEQ_NUM Number(6,0) INTEGER NOT NULL Conversation Sequence Number
39 CONVER_DTTM DateTime(26) TIMESTAMP Conversation DateTime
40 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
41 DUN_ID_NUM Number(8,0) INTEGER NOT NULL Dunning Number
42 ST_ID_NUM Number(8,0) INTEGER NOT NULL Statement Number
43 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
44 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID
45 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer
46 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
47 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number
48 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.
49 NOTIFY_FLAG Character(1) VARCHAR2(1) NOT NULL Recieve Notification
50 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
51 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
52 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
53 ESCAL_MGR_DT Date(10) DATE Esculate Manager Date
54 ESCAL_OWNER_DT Date(10) DATE Esculate Owner Date
55 ESCAL_SPSLST_DT Date(10) DATE Esculate Specialist Date
56 ESCAL_MGR_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Date
57 ESCAL_OWNER_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Owner Oper ID
58 ESCAL_SPSLST_OPRID Character(30) VARCHAR2(30) NOT NULL Esculate Specialist ID
59 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
60 ITEM_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.
61 CR_LIMIT_DT Date(10) DATE Credit Limit Date
62 ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.
63 RULE_ANCHOR_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Principal amount of a given deal transaction denominated in the anchor currency.
64 ANCHOR_CURRENCY Character(3) VARCHAR2(3) NOT NULL The base currency of the business unit that generates a given deal transaction.
65 ANCHOR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
66 ANCHOR_DATE Date(10) DATE Anchor Date
67 ANCHOR_CR_LIMIT Signed Number(28,3) DECIMAL(26,3) NOT NULL Credit Limit
68 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With
69 RULE_NUM_DAYS Number(3,0) SMALLINT NOT NULL Number of Days
70 ITEM_NUM_DAYS Number(3,0) SMALLINT NOT NULL Number of Days
71 ITEM_PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
72 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified

Default Value: %datetime

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

Default Value: PPLSFT

74 PROMISE_CURRENCY Character(3) VARCHAR2(3) NOT NULL Promise Currency Code
75 PROMISE_DT Date(10) DATE Promise Date
76 PAY_PROMISE_AMT Number(27,3) DECIMAL(26,3) NOT NULL Promise to Pay amount
77 ENTERED_DTTM DateTime(26) TIMESTAMP Entered Datetime

Default Value: %DATETIME