RFQ_LINE_COMBO(SQL View) |
Index Back |
|---|---|
Combine RFQ Line/Resp Line |
| SELECT a.business_unit , a.rfq_id , a.line_nbr , a.category_id , a.itm_setid , a.inv_item_id , a.descr254_mixed , a.qty_rfq , a.price_rfq , a.unit_of_measure , a.sched_date , a.freight_terms , a.ship_type_id , a.shipto_setid , a.shipto_id , 0 , b.response_flag , b.qty_rfq , b.price_rfq , b.unit_of_measure , b.sched_date , b.freight_terms , b.ship_type_id , b.shipto_id , b.vendor_setid , b.vendor_id , b.vndr_loc , b.qty_award , b.qty_ordered , b.rate_mult , b.rate_div , a.currency_cd , b.currency_cd FROM PS_RFQ_LINE a , ps_rfq_resp_line b WHERE a.business_unit = b.business_unit AND a.rfq_id = b.rfq_id AND a.line_nbr = b.line_nbr |
| # | 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]
Default Value: 1 |
| 4 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 5 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 6 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 7 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 8 | QTY_RFQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Request for Quote |
| 9 | PRICE_RFQ | Number(16,5) | DECIMAL(15,5) NOT NULL | RFQ Price |
| 10 | 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 |
| 11 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 12 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Default Value: BUS_UNIT_OPT_PM.FREIGHT_TERMS Prompt Table: FREIGHT_TERMS |
| 13 | 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 |
| 14 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 15 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Default Value: OPR_DEF_TBL_PM.SHIPTO_ID Prompt Table: SHIPTO_TBL |
| 16 | QTY_TOTAL_AWARD | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Total Awarded |
| 17 | RESPONSE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Supplier Responded
Y/N Table Edit |
| 18 | QTY_RESP | Number(16,4) | DECIMAL(15,4) NOT NULL | Quantity Responded |
| 19 | PRICE_RESP | Number(16,5) | DECIMAL(15,5) NOT NULL | Price Responded |
| 20 | UOM_RESP | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Responded |
| 21 | PROMISE_DT | Date(10) | DATE | Promise Date |
| 22 | FOB_CD_RESP | Character(10) | VARCHAR2(10) NOT NULL | Respond FOB Code |
| 23 | SHIP_TYPE_RESP | Character(10) | VARCHAR2(10) NOT NULL | Ship To Type Responded |
| 24 | SHIPTO_ID_RESP | Character(10) | VARCHAR2(10) NOT NULL | Ship To ID Responded |
| 25 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 26 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 27 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 28 | QTY_AWARD | Number(16,4) | DECIMAL(15,4) NOT NULL | Total Qty Awarded |
| 29 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 30 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 31 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 32 | CURRENCY_RFQ | Character(3) | VARCHAR2(3) NOT NULL | RFQ Currency Code |
| 33 | CURRENCY_RESP | Character(3) | VARCHAR2(3) NOT NULL | Response Currency Code |