EO_PS_PRODUCT

(SQL Table)
Index Back

List of PeopleSoft Products

List of PeopleSoft Products referenced by the Currency Conversion Utility. Process Groups/Rules are grouped by Process Group Id and Product. Installed Products within the Utility also reference this record.

  • Related Language Record: EO_PS_PROD_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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
    2 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 INSTALLED_SW Character(1) VARCHAR2(1) NOT NULL Installed?

    Y/N Table Edit

    Default Value: N

    5 ALWAYS_INSTLD_SW Character(1) VARCHAR2(1) NOT NULL Always Installed?

    Y/N Table Edit

    Default Value: N