RFQ_RESPLN_HST

(SQL Table)
Index Back

RFQ Vndr Response Line History

# 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 DTTM_RESP DateTime(26) TIMESTAMP Date Time Responded
8 RESPONSE_FLAG Character(1) VARCHAR2(1) NOT NULL Supplier Responded

Y/N Table Edit

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

Prompt Table: MANUFACTURER

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

Prompt Table: ITEM_MFG_ID_VW

14 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
15 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
16 QTY_RFQ Number(16,4) DECIMAL(15,4) NOT NULL Qty Request for Quote
17 PRICE_RFQ Number(16,5) DECIMAL(15,5) NOT NULL RFQ Price
18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
19 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
20 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
21 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

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

Prompt Table: FREIGHT_TERMS

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

Prompt Table: SHIP_METHOD

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

Prompt Table: SHIPTO_TBL

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

Prompt Table: UNITS_TBL

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

Prompt Table: UNITS_TBL

31 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty
32 QTY_ORDERED_LAST Number(16,4) DECIMAL(15,4) NOT NULL Last Qty Placed in Order
33 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
34 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
35 COMMENTS Long Character CLOB Comment
36 STOCKLESS_FLG Character(1) VARCHAR2(1) NOT NULL Stockless Item
N=No
Y=Yes
37 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
38 FILE_EXTENSION Character(4) VARCHAR2(4) NOT NULL File Extension
39 RESPONSE_PRICE_RFQ Number(16,5) DECIMAL(15,5) NOT NULL RFQ Price
40 RESPONSE_QTY_RFQ Number(16,4) DECIMAL(15,4) NOT NULL Qty Request for Quote
41 RFQ_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
42 RFQ_DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL (No Description)
43 RFQ_FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
44 RFQ_LEAD_TIME Number(3,0) SMALLINT NOT NULL Lead Time Days
45 RFQ_MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
46 RFQ_MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
47 RFQ_SCHED_DATE Date(10) DATE Schedule Date
48 RFQ_SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
49 RFQ_UOM Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
50 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1
51 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1
52 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2
53 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3
54 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4
55 CUSTOM_DATE_B Date(10) DATE Custom Date
56 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2