AR_ARULE_SQL

(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.
Prompt Table: CUSTOMER

4 CUSTOMER_GROUP Character(10) VARCHAR2(10) NOT NULL Customer Group

5 CUST_HIST_ID Character(10) VARCHAR2(10) NOT NULL History ID
Prompt Table: CUST_HIST_TBL

6 EFFDT Date(10) DATE Effective Date
Default Value: %date

7 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

8 SEQ_NUMBER Number(3,0) SMALLINT NOT NULL Expense Sequence Number

9 RULE_LEVEL Character(1) VARCHAR2(1) NOT NULL Rule Level
C=Customer
G=Customer Group
S=SetID

10 WHERE_TYPE Character(2) VARCHAR2(2) NOT NULL An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p
01=Bin Impact
02=Deal Conditions

11 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

12 FORMAT Number(2,0) SMALLINT NOT NULL Field Format
0=
If Fieldtype=0 (Character) then Upper Case
If Fieldtype=6 (DateTime) then HH:MM
1=Name
2=Phone Number North American (mandatory length 12 characters)
3=Zip/Postal Code North American (mandatory length 10 characters)
4=US Social Security Number (mandatory length 9 characters)
5=
6=Mixed Case
7=Raw/Binary
8=Numbers only
9=SIN (mandatory length 9 characters)
10=International Phone Number
11=Zip/Postal Code International
12=Time HH:MM:SS
13=Time HH:MM:SS.999999
14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)

13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Default Value: ITEM
Prompt Table: AR_SQLREC_VW

14 RECORD_ALIAS_CD Character(2) VARCHAR2(2) NOT NULL Record Alias Code
01=Item
02=Item Distribution
03=Item Activity
11=Customer
12=Customer Option

15 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

16 ALIAS_NAME_LONG Character(30) VARCHAR2(30) NOT NULL Alias Name
Prompt Table: AR_SQLFLD_VW

17 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du
Prompt Table: %EDITTABLE

18 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
Default Value: 0

19 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b

20 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days
Y/N Table Edit

21 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
<=<
<==<=
<>=<>
===
>=>
>==>=
B=Begins With
C=Contains
E=Ends With
NB=Doesn't Begins With
NC=Doesn't Contains
NE=Doesn't Ends With

22 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
01=(
02=((
03=(((
04=((((

23 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
01=)
02=))
03=)))
04=))))

24 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR

25 SQL_TEXT Character(254) VARCHAR2(254) NOT NULL SQL Text

26 FIELD_VALUE_STR1 Character(30) VARCHAR2(30) NOT NULL Field Value

#	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. Prompt Table: CUSTOMER
4	CUSTOMER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Customer Group
5	CUST_HIST_ID	Character(10)	VARCHAR2(10) NOT NULL	History ID Prompt Table: CUST_HIST_TBL
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
8	SEQ_NUMBER	Number(3,0)	SMALLINT NOT NULL	Expense Sequence Number
9	RULE_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Rule Level C=Customer G=Customer Group S=SetID
10	WHERE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p 01=Bin Impact 02=Deal Conditions
11	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
12	FORMAT	Number(2,0)	SMALLINT NOT NULL	Field Format 0= If Fieldtype=0 (Character) then Upper Case If Fieldtype=6 (DateTime) then HH:MM 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)
13	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Default Value: ITEM Prompt Table: AR_SQLREC_VW
14	RECORD_ALIAS_CD	Character(2)	VARCHAR2(2) NOT NULL	Record Alias Code 01=Item 02=Item Distribution 03=Item Activity 11=Customer 12=Customer Option
15	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
16	ALIAS_NAME_LONG	Character(30)	VARCHAR2(30) NOT NULL	Alias Name Prompt Table: AR_SQLFLD_VW
17	FIELD_VALUE_STR	Character(30)	VARCHAR2(30) NOT NULL	An accounting template field designated to support the substitution of desired character field values du Prompt Table: %EDITTABLE
18	FIELD_VALUE_NBR	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	An accounting template field designated to support the substitution of desired monetary amounts during a Default Value: 0
19	FIELD_VALUE_DATE	Date(10)	DATE	An accounting template field designated to support the substitution of desired dates during accounting b
20	RELATIVE_DATE	Character(1)	VARCHAR2(1) NOT NULL	"Represents the number of days Y/N Table Edit
21	COMP_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL field comparison syntax when the user is creating node specific data selection criteria <=< <==<= <>=<> === >=> >==>= B=Begins With C=Contains E=Ends With NB=Doesn't Begins With NC=Doesn't Contains NE=Doesn't Ends With
22	OPEN_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data 01=( 02=(( 03=((( 04=((((
23	CLOSE_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat 01=) 02=)) 03=))) 04=))))
24	AND_OR_TXT	Character(3)	VARCHAR2(3) NOT NULL	Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi AND=AND OR=OR
25	SQL_TEXT	Character(254)	VARCHAR2(254) NOT NULL	SQL Text
26	FIELD_VALUE_STR1	Character(30)	VARCHAR2(30) NOT NULL	Field Value