UPG_MG_RTG_TAO1(SQL Table) |
Index Back |
---|---|
8.80 MG Upg RTG Times11/20/02 PWF PL880-1.0 This table is used for upgrade in storing the operation times in the bom of outputs/components where incremental release / consumption time units are used. 02/03/04 PWF Added op_seq_orig into table to prevent duplicate insert error |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: BUS_UNIT_OPT_MG |
2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
3 | BOM_STATE | Character(2) | VARCHAR2(2) NOT NULL |
BOM State
EN=Engineering PR=Manufacturing |
4 | BOM_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
03/26/00 RML Added a label "Type"
PR=Production RW=Rework |
5 | BOM_CODE | Number(2,0) | SMALLINT NOT NULL | CN# EN800-3.0, anna 09/21 added new field to database |
6 | OP_SEQ_ORIG | Number(4,0) | SMALLINT NOT NULL | Original Operation Sequence |
7 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
8 | INV_ITEM_ID_NEW | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
9 | REF_ROUTING_ITEM | Character(18) | VARCHAR2(18) NOT NULL | Reference Routing Item |
10 | TIME_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Time / Resource Type
0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time |
11 | OP_TIME | Number(9,2) | DECIMAL(8,2) NOT NULL | Op Time |
12 | OP_RATE | Number(9,2) | DECIMAL(8,2) NOT NULL | Op Rate |
13 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes |
14 | OP_RATE_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Op Rate Unit
UD=Units/Day UH=Units/Hour UM=Units/Min |