RSF_OPP_QTE_HDR

(SQL View)
 Index Back

Opportunity Quotes

Opportunity Quote/Sales Order table

SELECT OPPORTUNITY_ID ,%Substring(CAPTURE_ID , 1 , 10) ,CAPTURE_TYPE_CD ,QUOTE_EXPIRE_DT ,'R' ,' ' ,TOTAL_PRICE ,CURRENCY_CD ,' ' ,' ' ,' ' ,0 ,0 ,0 ,DESCR50 ,DESCR50 ,ROW_ADDED_DTTM ,ROW_ADDED_OPRID ,ROW_LASTMANT_DTTM ,ROW_LASTMANT_OPRID ,SYNCID ,SYNCDTTM FROM PS_RO_RSF_LOPPY_VW

  • Related Language Record: RSF_OPPQTE_HDLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPPORTUNITY_ID Character(15) VARCHAR2(15) NOT NULL Opportunity ID

    Prompt Table: RSF_OPPORTUNITY

    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 CAPTURE_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Capture Type
    QUO=Quote
    SO=Order
    4 QUOTE_EXPIRE_DT Date(10) DATE Quote Expire Date
    5 QUOTE_STATUS Character(1) VARCHAR2(1) NOT NULL Quote Status
    A=Quote Accepted
    C=Order Created
    O=Sent to Order
    R=Customer Reviewing
    6 SENT_TO_OM_FLAG Character(1) VARCHAR2(1) NOT NULL Flag indicating whether the Quote/Order have been sent to/Received from OM
    R=Received from Order Management
    S=Sent to Order Management
    7 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    9 SHIPPING_TEXT Character(50) VARCHAR2(50) NOT NULL Text 50
    10 DISCOUNT_TEXT Character(50) VARCHAR2(50) NOT NULL Text 50
    11 TAX_TEXT Character(50) VARCHAR2(50) NOT NULL Tax Line Text
    12 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
    13 DISC_TAKEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Taken
    14 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
    15 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    16 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
    17 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    18 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    19 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    20 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    21 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    22 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time