GL_PE_04_PRS

(SQL Table)
 Index Back

Actual vs. Budget Prsnaliztion

Actual vs. Budget Personalization

  • Parent Record Of GL_PE04_GRP_TBL GL_PE_CF_PAIR GL_PE_TN_PAIR

    • # 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 INQUIRY Character(10) VARCHAR2(10) NOT NULL Inquiry Name
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    4 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

    Prompt Table: SP_BUL_AL_NONVW

    5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    6 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

    Prompt Table: CAL_DETP_FY_VW

    7 PERIOD_FROM Number(3,0) SMALLINT NOT NULL From Period

    Default Value: 1

    Prompt Table: CAL_DETP_PER_VW

    8 PERIOD_TO Number(3,0) SMALLINT NOT NULL To Period

    Prompt Table: CAL_DETP_PER_VW

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 STATISTICS_CODE Character(3) VARCHAR2(3) NOT NULL Statistics Code

    Prompt Table: STAT_ALL_VW

    11 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: GL_PE_CF1_VW

    12 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: TREE_FLDNAME_VW

    13 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: CF_TREENODE_VW

    14 TREE_LEVEL Character(10) VARCHAR2(10) NOT NULL Tree Level Number

    Prompt Table: TREE_LEVEL_VW

    15 AMT_FLDNAME Character(18) VARCHAR2(18) NOT NULL Amount Field Name

    Prompt Table: INQ_AMT_FLD_VW

    16 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    17 SHOW_GRID Character(1) VARCHAR2(1) NOT NULL To show grid.

    Y/N Table Edit

    Default Value: N

    18 PROFITABILITY Character(1) VARCHAR2(1) NOT NULL PROFITABILITY
    L=5 Least Profitable
    M=5 Most Profitable

    Default Value: M