PO_SSRFQLN_VW

(SQL View)
 Index Back

SS eRFQ response record.

Used to hold the response information. Found in PO_SSRFQ_RESP page.

SELECT BUSINESS_UNIT , RFQ_ID , LINE_NBR , VENDOR_SETID , VENDOR_ID , VNDR_LOC , RESPONSE_FLAG , ITM_SETID , INV_ITEM_ID , DESCR254_MIXED , MFG_ID , MFG_ITM_ID , VNDR_CATALOG_ID , ITM_ID_VNDR , QTY_RFQ , PRICE_RFQ , CURRENCY_CD , RATE_MULT , RATE_DIV , UNIT_OF_MEASURE , LEAD_TIME , SCHED_DATE , FREIGHT_TERMS , SHIP_TYPE_ID , SHIPTO_SETID , SHIPTO_ID , UOM_AWARD , QTY_AWARD , UOM_ORDERED , QTY_ORDERED , QTY_ORDERED_LAST , CATEGORY_ID ,PHYSICAL_NATURE ,VAT_SVC_PERFRM_FLG , QTY_MIN , COMMENTS FROM PS_RFQ_RESP_LINE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RFQ_ID Character(10) VARCHAR2(10) NOT NULL RFQ ID
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 RESPONSE_FLAG Character(1) VARCHAR2(1) NOT NULL Supplier Responded

Y/N Table Edit

Default Value: N

8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

12 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITEM_MFG_ID_VW

13 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
14 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
15 QTY_RFQ Number(16,4) DECIMAL(15,4) NOT NULL Qty Request for Quote
16 PRICE_RFQ Number(16,5) DECIMAL(15,5) NOT NULL RFQ Price
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

18 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
19 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
20 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: UNITS_TBL

21 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
22 SCHED_DATE Date(10) DATE Schedule Date
23 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Default Value: BUS_UNIT_OPT_PM.FREIGHT_TERMS

Prompt Table: FREIGHT_TERMS

24 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Default Value: BUS_UNIT_OPT_PM.SHIP_TYPE_ID

Prompt Table: SHIP_METHOD

25 SHIPTO_SETID Character(5) VARCHAR2(5) NOT NULL ShipTo SetID
26 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Default Value: OPR_DEF_TBL_PM.SHIPTO_ID

Prompt Table: SHIPTO_TBL

27 UOM_AWARD Character(3) VARCHAR2(3) NOT NULL Unit Of Meaure Awarded

Prompt Table: UNITS_TBL

28 QTY_AWARD Number(16,4) DECIMAL(15,4) NOT NULL Total Qty Awarded
29 UOM_ORDERED Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Ordered

Prompt Table: UNITS_TBL

30 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
31 QTY_ORDERED_LAST Number(16,4) DECIMAL(15,4) NOT NULL Last Qty Placed in Order
32 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
33 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
34 VAT_SVC_PERFRM_FLG Character(1) VARCHAR2(1) NOT NULL Where VAT Services Physically Performed Flag
1=Ship To Location
2=Ship From Location
3=Buyer's Location
4=Supplier's Location
35 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
36 COMMENTS Long Character CLOB Comment