AR_CRULE_HDR_LG

(SQL Table)
Index Back

Collection Rules Header

Collection Rules Header

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL 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
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 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
8 RULE_LEVEL Character(1) VARCHAR2(1) NOT NULL Rule Level
C=Customer
G=Customer Group
S=SetID
9 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
10 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
11 DAY_AMOUNT_CHECK Character(1) VARCHAR2(1) NOT NULL Day/Amount Check
A=Amount Check
D=Days Check
N=No Check
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
14 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID