EN_BOM_EXP_INQ2(SQL Table) |
Index Back |
|---|---|
BOM Explosion Inquiry Table 201/27/97 MEG (CN# PL601-2.5) Added EP_OP_SEQ 02/17/98 WTK (CN#WKAWAMOT-WR71P) - Added ECO_NUMBER 2/1999 CEL (CN# EN800-6.0) Added cost and resource percent fields,output type, and description (to display the xlat name of the output type) to carry down thru bom explosion 04/12/99 ST CN# EN800-1.0 - Added EN_SUBS_EXIST 09/15/99 CeL - Added teardown flag for Jay. 04/05/00 ST - Added COMP_REV 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from record |
| # | 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 | 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 |
| 9 | DATE_OBSOLETE | Date(10) | DATE | Obsolete Date |
| 10 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 11 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 12 | POS_NBR | Number(4,0) | SMALLINT NOT NULL | Position Number |
| 13 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 14 | ECO_ID | Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
| 15 | SUB_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Subcontract Supply
Y/N Table Edit |
| 16 | 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 Y/N Table Edit |
| 17 | TEARDOWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 01/28/99 jnw (CN#SF800-13) added field |
| 18 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
| 19 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 20 | SORTCODE | Character(254) | VARCHAR2(254) NOT NULL | BOM Sort Code |
| 21 | LOOPING_BOM | Character(1) | VARCHAR2(1) NOT NULL | Looping BOM |
| 22 | INV_ITEM_SIZE | Character(5) | VARCHAR2(5) NOT NULL | Item Size |
| 23 | INV_ITEM_HEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Height |
| 24 | INV_ITEM_LENGTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Length |
| 25 | INV_ITEM_WIDTH | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Width |
| 26 | INV_ITEM_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Item Weight |
| 27 | INV_ITEM_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Volume |
| 28 | UNIT_MEASURE_DIM | Character(3) | VARCHAR2(3) NOT NULL |
Dimension UOM
Prompt Table: UNITS_TBL |
| 29 | UNIT_MEASURE_WT | Character(3) | VARCHAR2(3) NOT NULL |
Weight UOM
Prompt Table: UNITS_TBL |
| 30 | UNIT_MEASURE_VOL | Character(3) | VARCHAR2(3) NOT NULL |
Volume UOM
Prompt Table: UNITS_TBL |
| 31 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 32 | EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Required Qty |
| 33 | CALC_COST_PCT | Number(16,7) | DECIMAL(15,7) NOT NULL | Calculated Cost Factor Percent |
| 34 | CALC_RESOURCE_PCT | Number(16,7) | DECIMAL(15,7) NOT NULL | Calculated Resource Factor pct |
| 35 | 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 |
| 36 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 37 | EN_SUBS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
KPN 08/23/02: Added label PL_SUBS_EXIST
N=No Y=Yes Y/N Table Edit Default Value: N |
| 38 | COMP_REV | Character(4) | VARCHAR2(4) NOT NULL | 03/29/00 ST Created new field Component Revision. |
| 39 | OP_STARTS_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 8/8/02 YBO Enhancement |
| 40 | QTY_PRECISION | Character(1) | VARCHAR2(1) NOT NULL |
Quantity Precision
D=Decimal W=Whole Nbr |