BO_REQ_TMPLT

(SQL Table)
Index Back

FSR Template

Financial Structure Request Template

  • Related Language Record: BO_REQ_TMPLT_LN
  • Parent Record Of BO_REQ_TC_FLDS BO_REQ_TU_FLDS BO_REQ_TU_LN BO_REQ_T_CHK BO_REQ_T_CHK_LN BO_REQ_T_QST BO_REQ_T_QST_LN
  • # 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 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: FLD_REQ_SFLD_VW

    3 BO_REQ_TMPLT_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Template Type
    C=ChartField
    T=Tree Only

    Default Value: C

    4 BO_REQ_TMPLT_NAME Character(60) VARCHAR2(60) NOT NULL Financial Structure Request Template Name
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: RECDEFN_VW

    7 GL_ROLENAME Character(30) VARCHAR2(30) NOT NULL Role Name

    Prompt Table: ROLE_USRLST_VW

    8 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By
    9 GL_ENTERED_DTTM DateTime(26) TIMESTAMP Entered Date/Time
    10 GL_UPDATED_BY Character(30) VARCHAR2(30) NOT NULL Updated By
    11 GL_UPDATED_DTTM DateTime(26) TIMESTAMP Updated Date/Time
    12 GL_DESCRLONG Long Character CLOB Long Description