UPG_MG_RTG_TAO1

(SQL Table)
Index Back

8.80 MG Upg RTG Times

11/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