SETIDPRODUCT_IDPROD_COMPONENT_IDASY=Assembly
ORD=Order
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
N=No
Y=Yes
IN_SW_PRDKIT_VW(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.PRODUCT_ID , A.PROD_COMPONENT_ID , B.DESCR , A.QTY_PER , A.QTY_CODE , A.MIN_QTY_PER , A.MAX_QTY_PER , A.UNIT_OF_MEASURE , A.DATE_IN_EFFECT , A.DATE_OBSOLETE , A.OPTIONAL_SHIP , B.DROP_SHIP_FLAG , B.INV_ITEM_ID ,' ' FROM PS_PRODKIT_COMPS A ,PS_PROD_ITEM B WHERE A.SETID = B.SETID AND A.PROD_COMPONENT_ID = B.PRODUCT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | PRODUCT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 3 | PROD_COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Product Component ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 6 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 7 | MIN_QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Minimum allowable quantity for a kit component |
| 8 | MAX_QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Maximum allowable quantity for a kit component |
| 9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 10 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
| 11 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 12 | OPTIONAL_SHIP | Character(1) | VARCHAR2(1) NOT NULL | OK to Ship Without |
| 13 | DROP_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Drop Ship
N=No Y=Yes |
| 14 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 15 | UPDATE_IMAGE_BTN | Character(1) | VARCHAR2(1) NOT NULL | Update Image |