BO_REQ_COR_VW

(SQL View)
 Index Back

FSR Core Information

Financial Structure Request Core Information

SELECT D.BO_REQUEST_ID , D.BO_REQ_DTL_NO , D.FIELDNAME1 , C.FIELDNAME2 , C.FLD_REQ_DISP_OPTN , C.FIELD_VALUE_DATE , C.FIELD_VALUE_NBR , C.FLD_REQ_VALUE_GL , F.LONGNAME , F.FLD_REQ_CATEGORY , F.FLD_REQ_DISP_TYPE , F.EDITTABLE , F.REQUIRED_FLG , C.GL_DESCRLONG FROM PS_BO_REQ_COR_DTL C , PS_BO_REQUEST_DTL D , PS_FLD_REQ_S_FLDS F WHERE D.BO_REQUEST_ID = C.BO_REQUEST_ID AND D.BO_REQ_DTL_NO = C.BO_REQ_DTL_NO AND F.FIELDNAME1 = D.FIELDNAME1 AND F.FIELDNAME2 = C.FIELDNAME2

  • Parent record: BO_REQUEST_DTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BO_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Financial Structure Request ID
    2 BO_REQ_DTL_NO Number(3,0) SMALLINT NOT NULL Financial Structure Request Detail ID
    3 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: BO_REQ_TFLD_VW

    4 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Field Name
    5 FLD_REQ_DISP_OPTN Character(1) VARCHAR2(1) NOT NULL Field Request Display Option
    N=Do Not Display
    O=Optional
    R=Required
    6 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b
    7 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
    8 FLD_REQ_VALUE_GL Character(254) VARCHAR2(254) NOT NULL Field Request Value Reserved for Field Request feature, and the size may change later!!!
    9 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    10 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

    11 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

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

    Prompt Table: RECDEFN_VW

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

    Y/N Table Edit

    Default Value: N

    14 GL_DESCRLONG Long Character CLOB Long Description