TR_FISCPRD_HDR

(SQL Table)
Index Back

TR Fiscal Period Close

Fiscal Periods Associated with Calendar ID set up in Treasury Options

  • Parent Record Of TR_FISCPRD_CLS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_FS_NONVW

    2 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: TR_FSCPRD_CL_VW

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