LED_INQ_CRIT

(SQL Table)
 Index Back

RTBL Ledger Inquiry Criteria

  • Parent Record Of JRNL_DRILL_CF LED_DRILL_CF LED_DRILL_CF_VW LED_INQ_ADJPER LED_INQ_CF LED_INQ_SCE LED_INQ_SCE_H

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPERATOR_VW

    2 SAVED_SEARCH Character(30) VARCHAR2(30) NOT NULL Saved Search Name
    3 INQUIRY_TYPE Character(1) VARCHAR2(1) NOT NULL Inquiry Type specifies Saved Search or Personalization to distinguish the type of search crieria.
    P=Personalization
    S=Saved Search

    Default Value: P

    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

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

    Prompt Table: SP_BUL_SD_NONVW

    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

    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

    Prompt Table: CUR_CD_ALL_VW

    10 INCLUDE_BAL_FRWD Character(1) VARCHAR2(1) NOT NULL Include Balance Forward

    Y/N Table Edit

    Default Value: N

    11 AMT_DSPLY_OPT Character(1) VARCHAR2(1) NOT NULL Amount Display Option specifies Transaction or Base currency balances for display.
    B=Base Currency
    T=Transaction Currency

    Default Value: B

    12 MAX_ROWS_SCROLL Number(5,0) INTEGER NOT NULL Max Number of Rows in Scrolls

    Default Value: 100