ACT_LST_HIS_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	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	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
6	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
7	COND_ROLE	Character(1)	VARCHAR2(1) NOT NULL	Condition Role B=Bill To Customer C=Corporate Customer P=Correspondence Customer R=Remit From Customer
8	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
9	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner
10	ACTION_PARM	Character(6)	VARCHAR2(6) NOT NULL	Action Parameter
11	PROPOSED_AUTOMATED	Character(1)	VARCHAR2(1) NOT NULL	Proposed/Automated A=Automated P=Proposed
12	DELIVERY_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Delivery Method E=Email F=Fax P=Print
13	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.
14	COMPLETE_DATE	Date(10)	DATE	To save the task execution complete date
15	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description