RS_SO_EXPHDR_VW

(SQL View)
Index Back

Express Search Header View

Shadow view for RS_SO_HDR. Used by Express Search Component Interface for Service Order Creation and Update.

SELECT BUSINESS_UNIT , SO_ID , SO_DATE , EXPRESS_SEARCH_FLG , SO_SOURCE , CUST_SETID , CUST_ID , CONTRACT_NUM , CONTR_LN_NBR , ALLOW_NONBILL_FLG , BID_FLAG , ENTERED_BY , ASSIGNED_TO , PROJECT_ID , DESCR60 , LASTUPDOPRID , LASTUPDDTTM , BUSINESS_UNIT_HR , TREE_SETID , NODE_DETAIL , OWNERSHIP_ID , DESCR FROM %Table(RS_SO_HDR)

  • Audit Record: RS_SO_AUDIT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_DATE Date(10) DATE Service Order Date
    4 EXPRESS_SEARCH_FLG Character(1) VARCHAR2(1) NOT NULL Express Search

    Y/N Table Edit

    Default Value: Y

    5 SO_SOURCE Character(1) VARCHAR2(1) NOT NULL Service Order Source
    C=Contract
    P=Project
    S=SRS
    T=Template
    6 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
    7 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: %EDITTABLE5

    8 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Default Value: NEXT

    9 CONTR_LN_NBR Number(3,0) SMALLINT NOT NULL Contract Line Number
    10 ALLOW_NONBILL_FLG Character(1) VARCHAR2(1) NOT NULL Nonbillable Assignment Allowed

    Y/N Table Edit

    Default Value: N

    11 BID_FLAG Character(1) VARCHAR2(1) NOT NULL Worker Bids Accepted

    Y/N Table Edit

    Default Value: N

    12 ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered by

    Default Value: OPR_DEF_TBL_FS.OPRID

    Prompt Table: RS_OPR_NAME_VW

    13 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To

    Prompt Table: RS_OPR_NAME_VW

    14 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    15 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    16 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    18 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

    Prompt Table: BUS_UNIT_TBL_HR

    19 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID
    20 NODE_DETAIL Character(1) VARCHAR2(1) NOT NULL Tree Node or Tree detail Value
    D=Detail
    N=Node
    21 OWNERSHIP_ID Character(30) VARCHAR2(30) NOT NULL Owning Organization
    22 DESCR Character(30) VARCHAR2(30) NOT NULL Description