EN_TRN_CMP_TMP(SQL Table) |
Index Back |
---|---|
BOM Component Transfer Table9/10/97 rlk - resave for unique key issue in dddaudit 11/97 LAJ CN#EG750-3.0 - Added new fields needed to determine if component is to be updated by BOM Mass Maintenance. The code being processed is in MASS_MAINTENANCE_CODE. EN_MMC_UPDATE_FLG is set to Y if at least one of the sequences on the mass maintenance code will update the component. EN_MMC_SEQ_FLG01 thru EN_MMC_SEQ_FLG20 store the actual sequence numbers to be applied to that component. Note: A mass maintenance code may only have a maximum of twenty sequences. The alternative solution would have been to add "original value" fields for all the component related fields (component_id, op_sequences, inv_item_length, etc.). 05/24/99 LAJ...CN#EN800-6.0 Broke out the fields used for processing the component update to the subrecord en_trn_upd_sbr. This subrecord will also be share by the outputs temp table. 11/99 HLK...Changed process_instance to eip_ctl_id so that this table may be shared with the app messaging process. 01/14/00 LAJ...CN#EN800 Created new subrecord called en_bom_cmp_sbr to contain all fields previously in en_bom_comp_sbr, minus the key fields. This is so that the records en_bom_comps and en_trn_cmp_tmp could use the same fields, but with a different key structures. (Here we need dup key on component_id). 10/09/02 PWF PL880-1.0 Removal of EP_OP_SEQ from subrecord |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_OWN_VW |
4 | BOM_STATE | Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
5 | BOM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
6 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
7 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL |
04/10/00 (Internet Architecture) SCC: Uppercase label Id.
Prompt Table: %EDITTABLE |
8 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL |
Operation Sequence
Prompt Table: %EDITTABLE2 |
9 | DATE_IN_EFFECT | Date(10) | DATE NOT NULL |
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
Prompt Table: %EDITTABLE3 |
10 | DATE_OBSOLETE | Date(10) | DATE NOT NULL |
Obsolete Date
Prompt Table: %EDITTABLE4 |
11 | POS_NBR | Number(4,0) | SMALLINT NOT NULL | Position Number |
12 | QTY_PER | Number(10,4) | DECIMAL(9,4) NOT NULL | Quantity |
13 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order Default Value: ASY |
14 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL |
Component Yield
Default Value: 100 |
15 | ECO_ID | Character(10) | VARCHAR2(10) NOT NULL | ECO Number |
16 | PENDING_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Status
ACT=Active PEN=Pending Default Value: ACT |
17 | SUB_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Subcontract Supply
Y/N Table Edit Default Value: N |
18 | 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 Default Value: N |
19 | TEARDOWN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
01/28/99 jnw (CN#SF800-13) added field
Y/N Table Edit |
20 | ROLLUP_FLG | Character(1) | VARCHAR2(1) NOT NULL |
03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.
Y/N Table Edit Default Value: N |
21 | EN_SUBS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
KPN 08/23/02: Added label PL_SUBS_EXIST
N=No Y=Yes Default Value: N |
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 | INCR_CONS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
07/22/02 EGS (CN#PL880-1): Added
1=None 2=Over Time Default Value: 1 |
33 | INCR_CONS_OFFSET | Number(16,4) | DECIMAL(15,4) NOT NULL | 07/22/02 EGS (CN#PL880-1): Added |
34 | COMP_REV | Character(4) | VARCHAR2(4) NOT NULL |
03/29/00 ST Created new field Component Revision.
Prompt Table: EN_REV_COMP_VW |
35 | COPY_DIRECTION | Character(2) | VARCHAR2(2) NOT NULL |
Copy From/To
EE=Engineering to Engineering EM=Engineering to Manufacturing ME=Manufacturing to Engineering |
36 | BUSINESS_UNIT_TO | Character(5) | VARCHAR2(5) NOT NULL | 04/10/00 SCC (Internet Architecture): Add label BUSINESS_UNIT |
37 | 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 |
38 | EN_MMC_UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Mass Maintenance Update Flag |
39 | MASS_MAINT_CODE | Character(10) | VARCHAR2(10) NOT NULL | Mass Maintenance Code |
40 | EN_MMC_SEQ_FLG01 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 1 |
41 | EN_MMC_SEQ_FLG02 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 2 |
42 | EN_MMC_SEQ_FLG03 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 3 |
43 | EN_MMC_SEQ_FLG04 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 4 |
44 | EN_MMC_SEQ_FLG05 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 5 |
45 | EN_MMC_SEQ_FLG06 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 6 |
46 | EN_MMC_SEQ_FLG07 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 7 |
47 | EN_MMC_SEQ_FLG08 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 8 |
48 | EN_MMC_SEQ_FLG09 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 9 |
49 | EN_MMC_SEQ_FLG10 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 10 |
50 | EN_MMC_SEQ_FLG11 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 11 |
51 | EN_MMC_SEQ_FLG12 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 12 |
52 | EN_MMC_SEQ_FLG13 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 13 |
53 | EN_MMC_SEQ_FLG14 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 14 |
54 | EN_MMC_SEQ_FLG15 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 15 |
55 | EN_MMC_SEQ_FLG16 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 16 |
56 | EN_MMC_SEQ_FLG17 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 17 |
57 | EN_MMC_SEQ_FLG18 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 18 |
58 | EN_MMC_SEQ_FLG19 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 19 |
59 | EN_MMC_SEQ_FLG20 | Number(3,0) | SMALLINT NOT NULL | Mass Maintenance Seq Flag 20 |