EN_BOM_EXP_INQ1(SQL Table) |
Index Back |
|---|---|
BOM Explosion Inquiry Table 1BOM Record for BOM Explosion Inquiry Input. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 3 | TOP_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Top Level Assembly |
| 4 | EXPL_LVL_ENG |
Number(3,0) | SMALLINT NOT NULL | Level Code |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 7 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 8 | EP_OP_SEQ | Number(4,0) | SMALLINT NOT NULL | Enterprise Rtg Op Seq |
| 9 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label |
| 10 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 11 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 12 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Used to store the unit of measure for an item. |
| 13 | POS_NBR | Number(4,0) | SMALLINT NOT NULL | Position Number |
| 14 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 15 | ECO_ID | Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 16 | SUB_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Subcontract Supply
Y/N Table Edit |
| 17 | NON_OWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
Y/N Table Edit |
| 18 | TEARDOWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
01/28/99 jnw (CN#SF800-13) added field
Y/N Table Edit |
| 19 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 20 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 21 | SORTCODE | Character(254) | VARCHAR2(254) NOT NULL | BOM Sort Code |
| 22 | LOOPING_BOM | Character(1) | VARCHAR2(1) NOT NULL | Looping BOM |
| 23 | INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 24 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 25 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 26 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 27 | INV_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 28 | INV_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Volume |
| 29 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 30 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 31 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 32 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 33 | EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Required Qty |
| 34 | CALC_COST_PCT | Number(16,7) | DECIMAL(15,7) NOT NULL | Calculated Cost Factor Percent |
| 35 | CALC_RESOURCE_PCT | Number(16,7) | DECIMAL(15,7) NOT NULL | Calculated Resource Factor pct |
| 36 | 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 Item CS=Secondary Co-Product RB=Recycle By-Product TD=Teardown Item WB=Waste By-Product |
| 37 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 38 | EN_SUBS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
BOM Substitutions Exist
N=No Y=Yes Y/N Table Edit Default Value: N |
| 39 | COMP_REV | Character(4) | VARCHAR2(4) NOT NULL | 03/29/00 ST Created new field Component Revision. |