AR_CNDSYS_VW (SQL View)	Index Back
Condition Definition Condition Definition 2

AR_CNDSYS_VW

(SQL View)

Condition Definition

Condition Definition 2

SELECT SETID ,CONDITION_ID ,DESCR50 , STATUS , DEFINITION_TYPE FROM PS_AR_COND_DEF WHERE DEFINITION_TYPE = 'S'

Related Language Record: AR_CNDSYS_VW_LG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
Set Control Field: SETID

2 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
Prompt Table: AR_CNDSYS3_VW

3 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

5 DEFINITION_TYPE Character(1) VARCHAR2(1) NOT NULL Definition Type
S=System Defined
U=User Defined

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW Set Control Field: SETID
2	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 Prompt Table: AR_CNDSYS3_VW
3	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
4	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
5	DEFINITION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Definition Type S=System Defined U=User Defined