EO_CCR_EXCP (SQL Table)	Index Back
CurrCnv Rule Exceptions

EO_CCR_EXCP

(SQL Table)

CurrCnv Rule Exceptions

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Uniquely identifies a Currency Conversion Process Group

2 PROD_ID Character(2) VARCHAR2(2) NOT NULL This is an XLAT field listing all PeopleSoft 7.5 Product codes.
AM=Asset Management
AP=Payables
AR=Receivables
BD=Budgets
BI=Billing
CA=Contracts
CE=Cost Management
CP=Product Configurator
DM=Deduction Management
DP=Demand Planning
EN=Manufactuing Bills and Routing
EO=Enterprise Components
EP=Enterprise Planning
EX=Expenses
FG=Federal Government
GF=Global Financials
GL=General Ledger
HP=HRMS Education & Government
IN=Inventory
MG=Manufacturing
OM=Order Management
OP=Order Promising
PC=Projects
PL=Production Planning
PO=Purchasing
QS=Quality
SF=Production Management
TR=Treasury

3 RULE_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Rule Occurrence Number

4 EXCP_PROC_NAME Character(8) VARCHAR2(8) NOT NULL Exception Process Name
Prompt Table: EO_CURRCNV_EXCP

5 CCR_TIMING_CD Character(1) VARCHAR2(1) NOT NULL Exception Timing
1=Before Conversion Rule
2=After Conversion Rule
3=In Place Of Conversion Rule
Default Value: 1

6 PROCESSING_SEQ Number(5,0) INTEGER NOT NULL Processing Sequence

7 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniquely identifies a Currency Conversion Process Group
2	PROD_ID	Character(2)	VARCHAR2(2) NOT NULL	This is an XLAT field listing all PeopleSoft 7.5 Product codes. AM=Asset Management AP=Payables AR=Receivables BD=Budgets BI=Billing CA=Contracts CE=Cost Management CP=Product Configurator DM=Deduction Management DP=Demand Planning EN=Manufactuing Bills and Routing EO=Enterprise Components EP=Enterprise Planning EX=Expenses FG=Federal Government GF=Global Financials GL=General Ledger HP=HRMS Education & Government IN=Inventory MG=Manufacturing OM=Order Management OP=Order Promising PC=Projects PL=Production Planning PO=Purchasing QS=Quality SF=Production Management TR=Treasury
3	RULE_INSTNC_NBR	Number(3,0)	SMALLINT NOT NULL	Rule Occurrence Number
4	EXCP_PROC_NAME	Character(8)	VARCHAR2(8) NOT NULL	Exception Process Name Prompt Table: EO_CURRCNV_EXCP
5	CCR_TIMING_CD	Character(1)	VARCHAR2(1) NOT NULL	Exception Timing 1=Before Conversion Rule 2=After Conversion Rule 3=In Place Of Conversion Rule Default Value: 1
6	PROCESSING_SEQ	Number(5,0)	INTEGER NOT NULL	Processing Sequence
7	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section