EN_BOM_ERTMP_VW(SQL View) |
Index Back |
|---|---|
BOM Transfer Error Messages08/13/98 CN#MG800-3.0 HK : Bom transfer error messages for manufacturing;created. Used by EG transfers and BOM Mass Maintenance to select into the panel buffers the appropriate error messages. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode 11/99 LAJ...Since process_instance was replaced with eip_ctl_id in the exceptions table, added link to table en_trns_tmp to get the process_instance. |
| SELECT c.process_instance ,a.business_unit ,a.business_unit_to ,a.inv_item_id ,a.bom_state ,a.bom_type ,a.bom_code ,a.component_id ,a.mg_output_type ,a.op_sequence ,a.date_in_effect ,a.sub_itm_id ,a.message_set_nbr ,a.message_nbr ,a.copy_direction ,a.run_cntl_id ,a.mass_maint_code ,a.en_transfer_source ,a.bom_level ,a.bom_transfer_stat FROM ps_en_bom_err_tmp a , PS_EN_BOM_MMC_HDR b , ps_en_trns_tmp c WHERE a.business_unit = b.business_unit AND a.mass_maint_code = b.mass_maint_code AND b.origin = 'EN' AND a.eip_ctl_id = c.eip_ctl_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUSINESS_UNIT_TO |
Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
| 4 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
| 6 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
| 7 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 8 | COMPONENT_ID |
Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 9 | 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 |
| 10 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 11 | 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 |
| 12 | SUB_ITM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/30/99 RML Added label "Substitute" |
| 13 | MESSAGE_SET_NBR |
Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 14 | MESSAGE_NBR |
Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 15 | COPY_DIRECTION | Character(2) | VARCHAR2(2) NOT NULL |
Copy From/To
EE=Engineering to Engineering EM=Engineering to Manufacturing ME=Manufacturing to Engineering |
| 16 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 17 | MASS_MAINT_CODE | Character(10) | VARCHAR2(10) NOT NULL | Mass Maintenance Code |
| 18 | EN_TRANSFER_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Engineering Transfer Source
M=Mass Change T=BOMs and Routings Transfer |
| 19 | BOM_LEVEL | Number(3,0) | SMALLINT NOT NULL | BOM Level |
| 20 | BOM_TRANSFER_STAT | Character(1) | VARCHAR2(1) NOT NULL |
02/01/00 LAJ
Took the word "Transfer" out of the label, since we now display this field for BOM Mass Maintenance Error correction.
Also added new translate (Update) to distiguish between the EG transfer process status and the BOM Mass Maintenance Status
05/18/00 LAJ
Added new label id for BOM results. This is used by the Mass Maint staged results panelgroup.
E=Error O=No Change T=Transfer U=No Errors W=Warning |