CAL_DEFN_TBL

(SQL Table)
 Index Back

Calendars

Detail Calendar Definition

  • Related Language Record: CAL_DEFN_LANG

  • Parent Record Of CAL_ADJP_LOG CAL_ADJP_TBL CAL_ADJP_VW CAL_BLDR_BP_VW CAL_BLDR_TD_VW CAL_BLDR_VW CAL_BPS_TBL CAL_BP_TBL CAL_DETP_LOG CAL_DETP_TBL CAL_JUST_LOG CAL_PGLT_TD_VW CAL_PGLT_TD_VW2 CAL_PGLT_TD_VW3 CAL_SUMP_TBL CAL_TD_TBL PC_PM_FROMPD_VW PC_PM_TOPD_VW PC_SUMCAL_BP_VW PROJ_INT_DETP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CALENDAR_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Calendar
    B=Budget Calendar
    D=Detail Calendar
    I=Summary Budget Period Calendar
    P=Budget Period Calendar
    S=Summary Calendar
    T=Promo Mgmt Sales Calendar
    5 DETAIL_CALENDAR Character(2) VARCHAR2(2) NOT NULL Detail Calendar

    Prompt Table: %EDITTABLE
    Set Control Field: SETID

    6 NUMBER_OF_PERIODS Number(3,0) SMALLINT NOT NULL Periods in a Year

    Default Value: 12

    7 DEPR_CAL_SW Character(1) VARCHAR2(1) NOT NULL Used for depreciation

    Y/N Table Edit

    Default Value: N

    8 DAILY_CALENDAR Character(1) VARCHAR2(1) NOT NULL Daily Calendar

    Y/N Table Edit

    Default Value: N

    9 DESCRLONG Long Character CLOB Long Description