EO_CURRCNV_R_VW

(SQL View)
 Index Back

Currency Conversion Rule View


SELECT PROC_GRP_ID , PROD_ID , RULE_INSTNC_NBR , RECNAME , DESCR , DESCR50 , PROCESSING_SEQ , EXECUTE_PROD_ID , BYPASS_PROD_ID , EFFDT_PROC_CD , ALIAS_DT_FLDNAME , INCRMNT_FLDNAME , BYPASS_DTL_AUDIT , RULE_SQLID , CCR_STATUS , DESCRLONG FROM PS_EO_CURRCNV_RULE

  • Related Language Record: EO_CCR_LANG_VW

  • Parent record: EO_PROCGRP_PROD

    • # 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

    Prompt Table: EO_PROCGRP_PROD

    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

    Prompt Table: EO_PROCGRP_PROD

    3 RULE_INSTNC_NBR Number(3,0) SMALLINT NOT NULL Rule Occurrence Number
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: EO_PSRECDEFN_VW

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 PROCESSING_SEQ Number(5,0) INTEGER NOT NULL Processing Sequence
    8 EXECUTE_PROD_ID Character(2) VARCHAR2(2) NOT NULL Execution Product ID
    9 BYPASS_PROD_ID Character(2) VARCHAR2(2) NOT NULL Bypass Product ID
    10 EFFDT_PROC_CD Character(1) VARCHAR2(1) NOT NULL Date Processing Method
    1=No Effective Date Processing
    3=Effective Date, No Eff Seq
    4=Effective Date with Eff Seq
    11 ALIAS_DT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Effective Date Field Name

    Prompt Table: EO_RECFIELD2_VW

    12 INCRMNT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Increment Field Name

    Prompt Table: EO_RECFIELD1_VW

    13 BYPASS_DTL_AUDIT Character(1) VARCHAR2(1) NOT NULL Used by the Currency Conversion Utility. Any exceptions process that has been coded to write before and after images to the audit table should check this flag before writing to the audit table. Note: Use this flag in conjuntion with the flag on the run control (see Run Control for the Currency Conversion Utility). This flas has been added to the state record.

    Y/N Table Edit

    14 RULE_SQLID Character(23) VARCHAR2(23) NOT NULL Rule SQLID
    15 CCR_STATUS Character(1) VARCHAR2(1) NOT NULL Used by the Currency Conversion Utility when a rule is made inactive. When the status is changed from active to inactive, all other fields are grayed out and a warning message is desplayed informing the user of possible disruption to the integrity of the rule set.
    A=Active
    I=Inactive
    16 DESCRLONG Long Character CLOB Long Description