CA_RULES_WHERE (SQL Table)	Index Back
TBP Acct. Rules Where Clause Stores where clause for TBP Accounting Rules

CA_RULES_WHERE

(SQL Table)

TBP Acct. Rules Where Clause

Stores where clause for TBP Accounting Rules

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CA_TXN_SOURCE Character(3) VARCHAR2(3) NOT NULL Contracts Transaction Source
CRM=CRM Transaction
FPC=Projects Transaction
FRE=Lease Administration Trans.

2 WEIGHT Number(15,0) DECIMAL(15) NOT NULL Field used to store Weight Points.

3 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CA_TXN_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Contracts Transaction Source CRM=CRM Transaction FPC=Projects Transaction FRE=Lease Administration Trans.
2	WEIGHT	Number(15,0)	DECIMAL(15) NOT NULL	Field used to store Weight Points.
3	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause