AR_CRULE_DTL

(SQL Table)

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

7 DAYS_FROM Number(4,0) SMALLINT NOT NULL Days From

8 DAYS_TO Number(4,0) SMALLINT NOT NULL Days To

9 FROM_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL From Amount

10 TO_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL To Amount

11 TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Template ID
Prompt Table: AR_TMPLT_VW
Set Control Field: SETID

12 PRIORITY Number(3,0) SMALLINT NOT NULL Priority

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

#	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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
7	DAYS_FROM	Number(4,0)	SMALLINT NOT NULL	Days From
8	DAYS_TO	Number(4,0)	SMALLINT NOT NULL	Days To
9	FROM_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	From Amount
10	TO_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	To Amount
11	TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Prompt Table: AR_TMPLT_VW Set Control Field: SETID
12	PRIORITY	Number(3,0)	SMALLINT NOT NULL	Priority
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