EN_BOM_EXPL(SQL Table) |
Index Back |
|---|---|
BOM Explosion result table11/05/97 dbe CN#MG750-6.0 dbe (QPA precision/rounding) - Added fields: BOM_QTY, QTY_PER and YIELD 03/20/98 dbe - Added EXPL_QTY1 for more precision than QTY_PER. 06/18/98 dbe CN#R-ON2FP - Added column NON_OWN_FLAG to support non-owned components-only BOMs. CN# EN800-3.0, Sep 21 98, Anna Added field BomCode 10/21/98 WTK (CN#EN800-6.0)- Added RTG_CODE field. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Prompt Table: EN_BOM_EXPL |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | EXPL_LVL_ENG |
Number(3,0) | SMALLINT NOT NULL | Level Code |
| 4 | TOP_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Top Level Assembly |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | BOM_STATE |
Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing Default Value: PR |
| 7 | BOM_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework Default Value: PR |
| 8 | BOM_CODE |
Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
| 9 | RTG_CODE |
Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 10 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 11 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 12 | 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 |
| 13 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 14 | EXPL_QTY | Number(13,4) | DECIMAL(12,4) NOT NULL | Required Qty |
| 15 | BOM_QTY | Number(7,0) | INTEGER NOT NULL | 06/02/00 LAJ (8.0) Changed field length from 8.0 to 7.0. All other quantity fields have a standardized length of 7, so this change will make bom_qty standard. |
| 16 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 17 | EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Required Qty |
| 18 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 19 | MG_OUTPUT_QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
01/28/98 (CN#EN800-6.0) LAJ...Created
Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly ORD=Order |
| 20 | 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 |
| 21 | CE_COST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 10/21/98 WTK (CN#EN800-6.0)-Created to determine whether or not item is costed and saved in cost rollup. |
| 22 | SORTCODE | Character(254) | VARCHAR2(254) NOT NULL | BOM Sort Code |
| 23 | LOOPING_BOM | Character(1) | VARCHAR2(1) NOT NULL | Looping BOM |
| 24 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No Y=Yes |
| 25 | INCL_LL_FLG | Character(1) | VARCHAR2(1) NOT NULL | Include Line Level |