BUSINESS_UNITBOM_STATEEN=Engineering
PR=Manufacturing
BOM_TYPEPR=Production
RW=Rework
INV_ITEM_IDCP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
EN_BOM_OUT3_VW(SQL View) |
Index Back |
|---|---|
BOM Output VwCN #EN800-6.0 cel, 2/22/99. Used in Bom Inquiry panels to see if there are any co-products or by-products. Since this is used for lower levels....only pulling the bom_code = 1 rows, since that is how the explosion is done. |
| SELECT A.BUSINESS_UNIT , A.BOM_STATE , A.BOM_TYPE , B.INV_ITEM_ID , A.MG_OUTPUT_TYPE FROM PS_EN_BOM_OUTPUTS A , PS_BU_ITEMS_INV B WHERE A.MG_OUTPUT_TYPE <> 'CP' AND A.MG_OUTPUT_TYPE <> 'TD' AND A.BOM_CODE = 1 AND A.INV_ITEM_ID = B.MG_ASSOCIATED_BOM AND A.BUSINESS_UNIT = B.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
| 3 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | MG_OUTPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
10/22/98 (CN#EN800-6.0) LAJ...Created
Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle).
11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste |