BO_REQUEST_DTL

(SQL Table)
 Index Back

FSR Detail

Financial Structure Request Detail

  • Parent record: BO_REQUEST

    • # 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 BO_REQ_DTL_STATUS Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Detail Status
    A=Approved
    C=Canceled
    D=Denied
    E=Error
    F=Completed
    P=Pending Approval
    R=In Review

    Default Value: R

    4 BUSINESS_UNIT_BO Character(5) VARCHAR2(5) NOT NULL Financial Structure Request Business Unit

    Prompt Table: SP_BU_GL_NONVW

    5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    6 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

    Prompt Table: BO_REQ_TFLD_VW

    7 BO_REQ_TMPLT_TYPE Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Template Type
    C=ChartField
    T=Tree Only
    8 BO_REQ_FLD_ACT Character(1) VARCHAR2(1) NOT NULL Financial Structure Request Type
    A=Add
    B=Add + Tree
    T=Tree Only
    U=Update
    V=Update + Tree

    Default Value: A

    9 FIELDVALUE1 Character(30) VARCHAR2(30) NOT NULL Field Value

    Prompt Table: %EDITTABLE

    10 EFFDT Date(10) DATE Effective Date
    11 EFFDT_OLD Date(10) DATE Old Effective Date
    12 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    13 EFF_STATUS_OLD Character(1) VARCHAR2(1) NOT NULL Old Effective Status
    A=Active
    I=Inactive
    14 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    15 GL_ROLENAME Character(30) VARCHAR2(30) NOT NULL Role Name
    16 GL_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By
    17 GL_ENTERED_DTTM DateTime(26) TIMESTAMP Entered Date/Time
    18 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    19 EOFD_MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Discussion Message ID
    20 GL_DESCRLONG Long Character CLOB Long Description