EN_RTG_OPS_TMP(SQL Table) |
Index Back |
---|---|
Item Rtg Ops (transfer)9/97 WTK Created 11/99 LAJ...Changed process_instance to eip_ctl_id so that this table may be shared with the app messaging process. |
# | 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
Prompt Table: BUS_UNIT_OPT_MG |
3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: MG_ITEM_OWN_VW |
4 | RTG_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown Default Value: PR |
5 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL |
Routing Code
Default Value: 1 |
6 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing Default Value: PR |
7 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
8 | TASK_CODE | Character(6) | VARCHAR2(6) NOT NULL |
Task Code
Prompt Table: %EDITTABLE14 |
9 | TASK_INTENSITY | Character(1) | VARCHAR2(1) NOT NULL |
Intensity
0=Labor Time 1=Mach Time 2=Longest 3=Cumulative Default Value: 2 |
10 | CREWSIZE | Number(7,2) | DECIMAL(6,2) NOT NULL | Crew Size |
11 | MACH_RESOURCES | Number(7,2) | DECIMAL(6,2) NOT NULL | Machine Resources |
12 | COUNT_POINT | Character(1) | VARCHAR2(1) NOT NULL |
3/22/2000 dfl - Change short name from cnt ptr to cnt pt, more std.
N=No Y=Yes Y/N Table Edit Default Value: N |
13 | SUBCONTRACTED | Character(1) | VARCHAR2(1) NOT NULL |
Subcontracted
N=No Y=Yes Y/N Table Edit Default Value: N |
14 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_PO_VW |
15 | SUB_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/02/05 EGS: Created |
16 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Work Center
Prompt Table: EN_WORK_CENTER |
17 | OPERATION_YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL |
Operation Yield
Default Value: 100 |
18 | FIXED_SCRAP_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | YBO Enhancement |
19 | OPERATION_FLOAT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Operation Float
Y/N Table Edit |
20 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
21 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
22 | SIM_SETUP_QUEUE | Character(1) | VARCHAR2(1) NOT NULL |
Simultaneous Setup and Queue
Y/N Table Edit Default Value: N |
23 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Conversion Code
Prompt Table: CE_CONCODE |
24 | CON_OH_CODE_1 | Character(4) | VARCHAR2(4) NOT NULL |
First Conversion Ovhd Code
Prompt Table: CE_CONOH_CODE |
25 | CON_OH_CODE_2 | Character(4) | VARCHAR2(4) NOT NULL |
Second Conversion Ovhd Code
Prompt Table: CE_CONOH_CODE |
26 | CON_OH_CODE_3 | Character(4) | VARCHAR2(4) NOT NULL |
Third Conversion Ovhd Code
Prompt Table: CE_CONOH_CODE |
27 | CON_OH_CODE_4 | Character(4) | VARCHAR2(4) NOT NULL |
Fourth Conversion Ovhd Code
Prompt Table: CE_CONOH_CODE |
28 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |