EO_CCR_LANG_VW

(SQL View)
 Index Back

CurrConv Rule Lang View


SELECT PROC_GRP_ID ,PROD_ID ,RULE_INSTNC_NBR ,LANGUAGE_CD ,DESCR ,DESCR50 ,DESCRLONG FROM PS_EO_CRCNVRL_LANG

  • Related Language Record for EO_CURRCNV_R_VW

  • Parent record: EO_CURRCNV_RULE

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

    Prompt Table: EO_CURRCNV_RULE

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

    Prompt Table: EO_CURRCNV_RULE

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    7 DESCRLONG Long Character CLOB Long Description