USERIDSEQ_NBR_6EN_BOMINQFD2_VW(SQL View) |
Index Back |
|---|---|
Item Where Used Express02/24/2004 PWF Res 152700 Bom Where Used Express Inquiry |
| SELECT USERID , SEQ_NBR_6 , EXPL_LVL_WHRUSED , INV_ITEM_ID , DESCR , BOM_CODE , OP_SEQUENCE FROM PS_EN_BOMINQ_EXP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | SEQ_NBR_6 |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | EXPL_LVL_WHRUSED | Number(3,0) | SMALLINT NOT NULL | Level |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 7 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |