RUN_CNTL_CC4_EO

(SQL Table)
Index Back

Currency Conversion Run Cntrl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 PROC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Uniquely identifies a Currency Conversion Process Group

Prompt Table: EO_PROC_GROUP

5 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

Prompt Table: EO_PS_PRODUCT

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

Prompt Table: EO_CURRCNV_RULE

7 AE_STMT_SW Character(1) VARCHAR2(1) NOT NULL Include AE Statements

Y/N Table Edit

Default Value: N

8 CCR_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Rule Status
A=Active
B=Both
I=Inactive