FR_WORKSHT_TBL

(SQL Table)
 Index Back

Cash Flows Worksheet

Cash Flows Worksheet parent table

  • Parent Record Of FR_CAL2_TMP FR_CALC_TMP FR_WORKSHT_GRID FR_WORKSHT_LDVW FR_WORKSHT_LN FR_WORKSHT_LOCK FR_WORKSHT_OPTN FR_WS_GRID_VW FR_WS_LOCK_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID
    2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    3 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
    N=Inactive
    Y=Active

    Default Value: N

    4 AS_OF_DATE Date(10) DATE NOT NULL As of Date

    Default Value: %date

    5 SEQUENCE_NBR_9 Number(9,0) DECIMAL(9) NOT NULL Sequence

    Default Value: 100000000

    6 COMMENTS Long Character CLOB Comment