BUSINESS_UNITINV_ITEM_IDPRODUCTION_TYPEPR=Production
RW=Rework
SV=Service
TD=Teardown
BOM_CODEMG_ORIG_COMP_IDOP_SEQUENCESUB_ITM_IDSF_BOM_SUB_VW(SQL View) |
Index Back |
|---|---|
View for Comp SubstititutesEN800-1.0 - Ravi- This view will display all substitute items at BOM level for a component in review plan. 09/24/99 CN#EN800-1.0 meg - Added sub_priority_nbr, effdt_from, effdt_to and made them list boxes. Removed field edits. |
| SELECT BUSINESS_UNIT , INV_ITEM_ID , BOM_TYPE , BOM_CODE , COMPONENT_ID , OP_SEQUENCE , SUB_ITM_ID , SUB_PRIORITY_NBR , EFFDT_FROM , EFFDT_TO FROM PS_EN_BOM_COMP_SUB WHERE BOM_STATE = 'PR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | PRODUCTION_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 4 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 5 | MG_ORIG_COMP_ID |
Character(18) | VARCHAR2(18) NOT NULL | original component ID |
| 6 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | SUB_ITM_ID |
Character(18) | VARCHAR2(18) NOT NULL | 11/30/99 RML Added label "Substitute" |
| 8 | SUB_PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_sub_pri_nbr. |
| 9 | EFFDT_FROM | Date(10) | DATE | Effective Date From |
| 10 | EFFDT_TO | Date(10) | DATE | Effective Date To |