RTBL_USER_PRNLZ

(SQL Table)
Index Back

Container Personalization

  • Parent Record Of RTBL_USER_CF RTBL_USR_PARM RTBL_USR_PARM_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 RTBL_CONTAINER_NBR Number(5,0) INTEGER NOT NULL Container Number
    3 RTBL_CURR_SCENARIO Character(10) VARCHAR2(10) NOT NULL Current Scenario
    4 RTBL_PAGELET_ID Character(30) VARCHAR2(30) NOT NULL Pagelet ID

    Prompt Table: PTPPB_PAGELET

    5 RTBL_REPORT_TYPE Character(30) VARCHAR2(30) NOT NULL Report Type

    Prompt Table: PTPPB_DATATYPE

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

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

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

    Prompt Table: SP_BUL_SD_NONVW
    Set Control Field: BUSINESS_UNIT

    8 FISCAL_YEAR_FROM Number(4,0) SMALLINT NOT NULL Fiscal Year
    9 FISCAL_YEAR_TO Number(4,0) SMALLINT NOT NULL Range To Fiscal Year
    10 FROM_PERIOD Number(3,0) SMALLINT NOT NULL From Period
    11 TO_PERIOD Number(3,0) SMALLINT NOT NULL To Period
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    13 LOCK_STATUS Character(1) VARCHAR2(1) NOT NULL 12/26/01 EGS (CN#PL900-1): Added

    Y/N Table Edit

    Default Value: N

    14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.