BUSINESS_UNITINV_ITEM_IDBOM_STATEEN=Engineering
PR=Manufacturing
BOM_TYPEPR=Production
RW=Rework
BOM_CODEMG_OUTPUT_TYPECP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
MG_OUTPUT_ITEMOP_SEQUENCEDATE_IN_EFFECTLANGUAGE_CDEN_BOM_MMCB_LVW(SQL View) |
Index Back |
|---|---|
BOM Mass Maint BOM RL View03/31/99 LAJ CN#EN800-6.0 This view is used to join together assembly items and their descriptions. It will be used for the 'View Button' on the Output Search panel for BOM Mass Maintenance. 04/41/99 LAJ : Created as Rel language view for EN_BOM_MMCB_VW |
| select distinct a.business_unit, a.inv_item_id, a.bom_state, a.bom_type, a.bom_code, a.mg_output_type, a.mg_output_item, a.op_sequence, a.date_in_effect, e.language_cd, e.descr from ps_en_bom_outputs a, ps_set_cntrl_rec c, PS_INV_ITEMS d, ps_master_itm_lang e where a.business_unit = c.setcntrlvalue and c.recname = 'MASTER_ITEM_TBL' and e.setid = c.setid and e.setid = d.setid and a.inv_item_id = e.inv_item_id and a.inv_item_id = d.inv_item_id and d.effdt = (select MAX(effdt) from PS_INV_ITEMS where setid = d.setid and inv_item_id = e.inv_item_id and effdt <= %CurrentDateIn) |
| # | 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 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
| 4 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 5 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 6 | 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 |
| 7 | MG_OUTPUT_ITEM |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id. |
| 8 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 9 | 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 |
| 10 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |