EN_RTG_TIME_TMP

(SQL Table)
 Index Back

Item Routing Op Times (copy)

CN#EG750-4.0 dbe (Engineering Routings) - Added new field: RTG_STATE.

# 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

Prompt Table: MASTER_ITEM_TBL

3 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown

Default Value: PR

4 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Default Value: 1

5 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing

Default Value: PR

6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
7 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
8 OP_TIME Number(9,2) DECIMAL(8,2) NOT NULL Op Time
9 OP_RATE Number(9,2) DECIMAL(8,2) NOT NULL Op Rate
10 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
DY=Days
HR=Hours
MN=Minutes
11 OP_RATE_UNIT Character(2) VARCHAR2(2) NOT NULL Op Rate Unit
UD=Units/Day
UH=Units/Hour
UM=Units/Min
12 INCLUDE_SETUP Character(1) VARCHAR2(1) NOT NULL Include Setup in Lead Time
N=No
Y=Yes

Y/N Table Edit

Default Value: Y

13 SCHED_BY_CALENDAR Character(1) VARCHAR2(1) NOT NULL Schedule by Calendar

Y/N Table Edit

Default Value: Y