RS_SO_LINE

(SQL Table)
 Index Back

Service Order Line

This table is for service order lines or it contains resource requests. Each service order contains multiple service order lines or resource requests.

  • 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.

    Prompt Table: %EDITTABLE6

    8 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

    Prompt Table: %EDITTABLE7

    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 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
    E=Employee
    N=Non-Employee
    18 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

    Prompt Table: RS_POOL_ACTIVE

    19 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.

    Prompt Table: RS_REGION

    20 REQUIREMENT_ID Character(30) VARCHAR2(30) NOT NULL Project Team - Requirement ID
    21 KEY_REQS Character(100) VARCHAR2(100) NOT NULL Key Requirements
    22 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
    A=Closed
    C=Cancel
    O=Open

    Default Value: O

    23 DISTANCE Number(8,2) DECIMAL(7,2) NOT NULL Distance Traveled
    24 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

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: CUST_CONTACT

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

    Prompt Table: FO_CUST_CONT_VW

    40 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location

    Prompt Table: LOCATION_TBL

    41 TAX_EXEMPT_FLAG Character(1) VARCHAR2(1) NOT NULL Tax Exemption License Exists

    Y/N Table Edit

    42 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
    43 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code

    Prompt Table: CA_TAX_CD_VW

    44 TAX_GROUP Character(10) VARCHAR2(10) NOT NULL Tax Group

    Prompt Table: PRODGP_NGTAX_VW

    45 TAX_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Type
    1=Sale
    2=Rental
    3=Service
    4=Purchase
    5=Lease
    B=Return
    46 TAX_TRANS_SUB_TYPE Character(1) VARCHAR2(1) NOT NULL Transaction Sub Type
    1=Property
    2=Freight
    3=Service
    4=Rental or Lease
    5=Expense
    6=Misc
    N=None
    47 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
    G=Goods
    S=Services
    48 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: %EDITTABLE3

    49 OPEN_DT Date(10) DATE Date Opened

    Default Value: %date

    50 START_TIME Time(15) TIMESTAMP Start of Shift
    51 WEEKLY_HOURS_STD Number(6,2) DECIMAL(5,2) NOT NULL Standard hours per week
    52 MIN_HOURS_WAIVED Character(1) VARCHAR2(1) NOT NULL Minimum Hours Waived

    Y/N Table Edit

    Default Value: N

    53 TEMP_TO_HIRE Character(1) VARCHAR2(1) NOT NULL Temporary To Hire

    Y/N Table Edit

    Default Value: N

    54 END_TIME Time(15) TIMESTAMP End of Shift
    55 FO_TARGET_MARGIN Number(7,3) DECIMAL(6,3) NOT NULL Target Margin
    56 REG_PAY_RATE Number(19,6) DECIMAL(18,6) NOT NULL Pay Rate
    57 REG_BILL_RATE Number(19,6) DECIMAL(18,6) NOT NULL Bill Rate
    58 CO_OP Character(1) VARCHAR2(1) NOT NULL CO-OP Order

    Y/N Table Edit

    Default Value: N

    59 RELOCATE Character(1) VARCHAR2(1) NOT NULL Willing to Relocate

    Y/N Table Edit

    Default Value: N

    60 CONFIDENTIAL Character(1) VARCHAR2(1) NOT NULL Confidential Order

    Y/N Table Edit

    Default Value: N

    61 FEE_SCHEDULE Character(50) VARCHAR2(50) NOT NULL Fee Schedule

    Prompt Table: POTENTIAL_VW

    62 FEE_SCHEDULE_SENT Date(10) DATE Fee Schedule Sent
    63 FEE_SCHEDULE_SIGN Date(10) DATE Fee Schedule Sign
    64 GUARANTEE_DAYS Number(3,0) SMALLINT NOT NULL Guarantee Days
    65 SALARY_RANGE_MIN Number(11,2) DECIMAL(10,2) NOT NULL Salary Range
    66 SALARY_RANGE_MAX Number(11,2) DECIMAL(10,2) NOT NULL Maximum Salary Range
    67 INITIAL_COMP Number(11,2) DECIMAL(10,2) NOT NULL Compensation
    68 FIRST_REVIEW Character(10) VARCHAR2(10) NOT NULL First Review
    69 PERCENT_INCREASE Number(6,2) DECIMAL(5,2) NOT NULL Renewal % Increase
    70 RESUME_CONTACT Character(40) VARCHAR2(40) NOT NULL Contact Person for Resume

    Prompt Table: FO_CUST_CONT_VW

    71 CONTACT_NAME1 Character(40) VARCHAR2(40) NOT NULL Contact Name 1

    Prompt Table: FO_CUST_CONT_VW

    72 CONTACT_NAME2 Character(40) VARCHAR2(40) NOT NULL Contact Name 2

    Prompt Table: FO_CUST_CONT_VW

    73 CONTACT_NAME3 Character(40) VARCHAR2(40) NOT NULL Contact Name 3

    Prompt Table: FO_CUST_CONT_VW

    74 EXTEND_OFFER Character(1) VARCHAR2(1) NOT NULL Extend Offer
    C=Customer
    R=Recruiter
    T=Third Party Service
    75 REFERENCE_CHECK Character(1) VARCHAR2(1) NOT NULL Reference Check By
    C=Customer
    R=Recruiter
    T=Third Party Service
    76 OTHER_RECRUITERS Character(50) VARCHAR2(50) NOT NULL Other Recruiters
    77 FO_CSF_ID Character(15) VARCHAR2(15) NOT NULL Definition ID

    Prompt Table: FO_CUST_CSF_VW

    78 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    79 FO_JOBTITLE Character(9) VARCHAR2(9) NOT NULL Job Title Code

    Prompt Table: FO_JOBTITLE_VW2

    80 CONFIDENCE_CD Character(2) VARCHAR2(2) NOT NULL Confidence
    AL=Advanced
    BL=Beginner
    IL=Intermediate
    NI=Not Investigated
    81 JOB_SUPPLEMENT Character(30) VARCHAR2(30) NOT NULL Job Supplement

    Prompt Table: FO_JOB_SUP_VW

    82 POST_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
    %=All
    C=Complete
    E=Errors
    N=Not Posted

    Y/N Table Edit

    83 COMMENT1 Character(254) VARCHAR2(254) NOT NULL Comments
    84 COMMENT2 Character(254) VARCHAR2(254) NOT NULL Comments
    85 SCHEDULE_COMMENT Character(254) VARCHAR2(254) NOT NULL Comment
    86 SHOW_IN_SELFSERV Character(1) VARCHAR2(1) NOT NULL Show in Self-service

    Y/N Table Edit

    87 FACTOR_IMP_AVA Character(1) VARCHAR2(1) NOT NULL Availability Importance
    0=0 - Not at all important
    1=1 - Much less important
    2=2 - Less important
    3=3 - Important
    4=4 - More important
    5=5 - Much more important
    88 FACTOR_IMP_JOY Character(1) VARCHAR2(1) NOT NULL Preferences Importance
    0=0 - Not at all important
    1=1 - Much less important
    2=2 - Less important
    3=3 - Important
    4=4 - More important
    5=5 - Much more important
    89 FACTOR_IMP_QUA Character(1) VARCHAR2(1) NOT NULL Qualifications Importance
    0=0 - Not at all important
    1=1 - Much less important
    2=2 - Less important
    3=3 - Important
    4=4 - More important
    5=5 - Much more important
    90 FACTOR_IMP_RES Character(1) VARCHAR2(1) NOT NULL Resume Importance
    0=0 - Not at all important
    1=1 - Much less important
    2=2 - Less Important
    3=3 - Important
    4=4 - More important
    5=5 - Much more important
    91 MAX_COUNT_99 Number(2,0) SMALLINT NOT NULL Candidates per Page

    Default Value: 10

    92 RS_RSRCGRP_NAME Character(15) VARCHAR2(15) NOT NULL Resource Group ID

    Prompt Table: RS_RSRCGRP_FAV

    93 SRCH_RESUME Character(1) VARCHAR2(1) NOT NULL Search in resume.
    N=Inactive
    Y=Active

    Default Value: Y

    94 TOTAL_EST_HRS Number(9,2) DECIMAL(8,2) NOT NULL Total Estimated Hours
    95 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category

    Prompt Table: RS_TASK_CAT