RSF_OPP_QTE_DTL (SQL View)	Index Back
Opportunity Quotes Detail Opportunity Quote/Sales Order table

RSF_OPP_QTE_DTL

(SQL View)

Opportunity Quotes Detail

Opportunity Quote/Sales Order table

SELECT OPPORTUNITY_ID ,%Substring(CAPTURE_ID , 1 , 10) ,LINE_NBR ,0 ,' ' ,PRODUCT_ID ,QTY_ORDERED ,UNIT_OF_MEASURE ,PRICE ,PRICE ,ROW_ADDED_DTTM ,ROW_ADDED_OPRID ,ROW_LASTMANT_DTTM ,ROW_LASTMANT_OPRID ,SYNCID ,SYNCDTTM FROM PS_RO_RSF_LINE_VW

# 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 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

4 SEQNUMPROD Signed Number(4,0) DECIMAL(3) NOT NULL Sequence Number

5 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

7 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

9 PRICE_BASE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price (base)

10 PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL This is price per unit for calculating the service charge.

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

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

16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
4	SEQNUMPROD	Signed Number(4,0)	DECIMAL(3) NOT NULL	Sequence Number
5	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
7	QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. CS=Case EA=Each MHR=Muti Hourly PER=Percentage SQF=Square Footage
9	PRICE_BASE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price (base)
10	PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	This is price per unit for calculating the service charge.
11	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
12	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
13	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
14	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
15	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.
16	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time