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 |