BO_REQ_TC_FLDS

(SQL Table)
 Index Back

FSR Template Core Information

Financial Structure Request Template Core Information

  • Parent record: BO_REQ_TMPLT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL 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
    4 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Field Name
    5 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: RECDEFN_VW

    6 FLD_REQ_DISP_OPTN Character(1) VARCHAR2(1) NOT NULL Field Request Display Option
    N=Do Not Display
    O=Optional
    R=Required

    Default Value: O

    7 REQUIRED_FLG Character(1) VARCHAR2(1) NOT NULL Required Flag

    Y/N Table Edit

    Default Value: N