FLD_REQ_S_FLDS

(SQL Table)
 Index Back

Field Request Setup Fields

Field Request Setup Fields

  • Parent record: FLD_REQ_SETUP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: FLD_REQ_SETUP

    2 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: FLD_REQ_FLD_DVW

    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    4 FLD_REQ_CATEGORY Character(1) VARCHAR2(1) NOT NULL Field Request Category
    B=Book Code
    C=Commitment Control
    G=General
    O=Open Item
    P=Performance Measurement
    V=Value Added Tax

    Default Value: G

    5 FLD_REQ_DISP_TYPE Character(1) VARCHAR2(1) NOT NULL Field Request Display Type
    0=Check Box
    1=Date
    2=Drop Down List
    3=Prompt
    4=Character
    5=Number
    6=Hyperlink

    Default Value: 4

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

    Prompt Table: RECDEFN_VW

    7 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

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

    Y/N Table Edit

    Default Value: N

    9 DELIVERED_FLG Character(1) VARCHAR2(1) NOT NULL Delivered Flag

    Y/N Table Edit

    Default Value: N