ACTION_SS_VW

#	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. 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
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	COND_ROLE	Character(1)	VARCHAR2(1) NOT NULL	Condition Role B=Bill To Customer C=Corporate Customer P=Correspondence Customer R=Remit From Customer
10	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
11	DATE_ADDED	Date(10)	DATE	Date Added
12	ACTION_DT	Date(10)	DATE	Action Date
13	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
14	OWNER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Collection Owner Type A=Credit Analyst C=Collector O=Other R=AR Specialist S=Sales Person
15	ACTION_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Action Owner
16	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
17	ACTION_PARM	Character(6)	VARCHAR2(6) NOT NULL	Action Parameter
18	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.
19	ITEM_LINE	Number(6,0)	INTEGER NOT NULL	Item Line
20	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.
21	COMPLETION_DATE	Date(10)	DATE	Completion Date
22	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.
23	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50