AR_CRULE_HDR_LG(SQL Table) |
Index Back |
---|---|
Collection Rules HeaderCollection 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 |