RFQ_LINE_NRSPVW(SQL View) |
Index Back |
|---|---|
Request For Quote Lines |
| 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.CURRENCY_CD , A.UNIT_OF_MEASURE , A.STOCKLESS_FLG , A.LEAD_TIME , A.SCHED_DATE , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.SHIPTO_SETID , A.SHIPTO_ID , A.FILENAME , A.FILE_EXTENSION , A.MFG_ID , A.MFG_ITM_ID , %subrec(PUR_USR_LIN_SBR, A) FROM PS_RFQ_LINE A WHERE A.LINE_NBR NOT IN ( SELECT LINE_NBR FROM PS_RFQ_RESP_LINE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RFQ_ID = B.RFQ_ID) |
| # | 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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 11 | 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 |
| 12 | STOCKLESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stockless Item
N=No Y=Yes |
| 13 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 14 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 15 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Default Value: BUS_UNIT_OPT_PM.FREIGHT_TERMS Prompt Table: FREIGHT_TERMS |
| 16 | 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 |
| 17 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 18 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Default Value: OPR_DEF_TBL_PM.SHIPTO_ID Prompt Table: SHIPTO_TBL |
| 19 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 20 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL |
File Extension
Prompt Table: FILE_DIR_BU_VW |
| 21 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
| 22 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: ITEM_MFG_ID_VW |
| 23 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 24 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 25 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 26 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 27 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 28 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 29 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |