RS_SO_EXPLNE_VW

(SQL View)
 Index Back

Express Search Line View

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

SELECT BUSINESS_UNIT , SO_ID , SO_LINE , ACTIVITY_ID , RESOURCE_ID , QTY_INTEGER , CUST_ID , ADDRESS_SEQ_NUM , START_DT , END_DT , LATE_START_DT , EST_DAYS , PERIOD_DAYS , PART_TIME_FLG , DESCR , PROJ_ROLE , REQUIREMENT_ID , KEY_REQS , SO_LINE_STATUS , DISTANCE , APPROVAL_STATUS , NONBILLABLE_FLAG , BID_FLAG , CNTCT_SEQ_NUM , BILL_RATE_TYPE , CURRENCY_CD , BILL_RATE , BILL_RATE_TO , WEIGHT_POINTS , RATE_DATE , BILL_RATE_CV , BILL_RATE_TO_CV , LASTUPDOPRID , LASTUPDDTTM , COMMENTS_2000 FROM %Table(RS_SO_LINE)

  • Parent record: 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
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
    5 RESOURCE_ID Character(40) VARCHAR2(40) NOT NULL Transaction ID
    6 QTY_INTEGER Number(11,0) DECIMAL(11) NOT NULL Quantity Rounded to 0 Decimals

    Default Value: 1

    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.
    8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: RS_CUST_VW

    9 START_DT Date(10) DATE Start Date
    10 END_DT Date(10) DATE End Date
    11 LATE_START_DT Date(10) DATE Late Start Date
    12 EST_DAYS Number(5,0) INTEGER NOT NULL Estimated number of days
    13 PERIOD_DAYS Number(5,0) INTEGER NOT NULL Number of Work Days
    14 PART_TIME_FLG Character(1) VARCHAR2(1) NOT NULL Part Time

    Y/N Table Edit

    Default Value: N

    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Prompt Table: RS_PROJROLE_VW

    17 REQUIREMENT_ID Character(30) VARCHAR2(30) NOT NULL Project Team - Requirement ID

    Prompt Table: PC_OPENREQID_VW

    18 KEY_REQS Character(100) VARCHAR2(100) NOT NULL Key Requirements
    19 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Closed
    C=Cancel
    O=Open

    Default Value: O

    20 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled
    21 APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
    A=Approved
    D=Denied
    E=Sent Back for Revision
    H=On Hold
    I=Initial
    M=Resubmitted
    P=In Process
    R=Rerouted
    S=Submitted

    Default Value: I

    22 NONBILLABLE_FLAG Character(1) VARCHAR2(1) NOT NULL Shadow Consultants Allowed

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    24 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

    Prompt Table: CUST_CONTACT

    25 BILL_RATE_TYPE Character(1) VARCHAR2(1) NOT NULL Bill Rate Type
    L=Maximum
    M=Minimum
    R=Range
    T=Target
    26 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    27 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    28 BILL_RATE_TO Number(27,3) DECIMAL(26,3) NOT NULL Bill Rate To
    29 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
    30 RATE_DATE Date(10) DATE Exchange Rate Date
    31 BILL_RATE_CV Number(27,3) DECIMAL(26,3) NOT NULL Converted Bill Rate
    32 BILL_RATE_TO_CV Number(27,3) DECIMAL(26,3) NOT NULL Bill Rate To Converted
    33 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.
    34 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.
    35 COMMENTS_2000 Long Character CLOB Comment Text