RUN_CNTL_CC4_EO(SQL Table) | 
Index Back | 
|---|---|
Currency Conversion Run Cntrl | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
| 2 | 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  |