PO_RFQR_LN_EVW

(SQL View)
Index Back

RFQR Message LN View

SELECT BUSINESS_UNIT , RFQ_ID , LINE_NBR , VENDOR_ID , VNDR_LOC , PO_EDI_STATUS , INV_ITEM_ID , DESCR254_MIXED , MFG_ID , VNDR_CATALOG_ID , ITM_ID_VNDR , QTY_RFQ , PRICE_RFQ , CURRENCY_CD , UNIT_OF_MEASURE , LEAD_TIME , FREIGHT_TERMS , SHIP_TYPE_ID , QTY_MIN FROM PS_RFQ_RESP_LN_EC

SELECT BUSINESS_UNIT , RFQ_ID , LINE_NBR , VENDOR_ID , VNDR_LOC , PO_EDI_STATUS , INV_ITEM_ID , DESCR254_MIXED , MFG_ID , MFG_ITM_ID , VNDR_CATALOG_ID , ITM_ID_VNDR , QTY_RFQ , PRICE_RFQ , CURRENCY_CD , UNIT_OF_MEASURE , LEAD_TIME , FREIGHT_TERMS , SHIP_TYPE_ID , QTY_MIN FROM PS_RFQ_RESP_LN_EC

# 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_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 PO_EDI_STATUS Character(1) VARCHAR2(1) NOT NULL Purchasing EDI Status
E=Error
H=Hold
L=New/Reprocess
P=Processed
X=Cancelled
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
10 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
11 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
12 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
13 QTY_RFQ Number(16,4) DECIMAL(15,4) NOT NULL Qty Request for Quote
14 PRICE_RFQ Number(16,5) DECIMAL(15,5) NOT NULL RFQ Price
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
16 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
17 LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
18 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
19 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
20 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity