PORFQLINE_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for RFQ_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 4 | LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 5 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL |
Category ID
Prompt Table: ITM_CAT_VW |
| 6 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 7 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 8 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 9 | QTY_RFQ | Number(16,4) | DECIMAL(15,4) NOT NULL | Qty Request for Quote |
| 10 | PRICE_RFQ | Number(16,5) | DECIMAL(15,5) NOT NULL | RFQ Price |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | 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 |
| 13 | STOCKLESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Stockless Item
N=No Y=Yes |
| 14 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 15 | SCHED_DATE | Date(10) | DATE | Schedule Date |
| 16 | FREIGHT_TERMS | Character(10) | VARCHAR2(10) NOT NULL |
Freight Terms Code
Default Value: BUS_UNIT_OPT_PM.FREIGHT_TERMS Prompt Table: FREIGHT_TERMS |
| 17 | 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 |
| 18 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL | ShipTo SetID |
| 19 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Default Value: OPR_DEF_TBL_PM.SHIPTO_ID Prompt Table: SHIPTO_TBL |
| 20 | FILENAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 21 | FILE_EXTENSION | Character(4) | VARCHAR2(4) NOT NULL |
File Extension
Prompt Table: FILE_DIR_BU_VW |
| 22 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
| 23 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer's Item ID
Prompt Table: ITEM_MFG_ID_VW |
| 24 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 25 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 26 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 27 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 28 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 29 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 30 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 31 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 32 | 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 |
| 33 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |