EN_TASKS

(SQL Table)
Index Back

Routing Tasks

CN#SF800-17.0 dfl - Add new field, count_point.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUMGOP_NONVW

2 TASK_CODE Character(6) VARCHAR2(6) NOT NULL Task Code
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
5 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

6 SUBCONTRACTED Character(1) VARCHAR2(1) NOT NULL Subcontracted
N=No
Y=Yes

Y/N Table Edit

Default Value: N

7 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

8 TASK_INTENSITY Character(1) VARCHAR2(1) NOT NULL Intensity
0=Labor Time
1=Mach Time
2=Longest
3=Cumulative

Default Value: 2

9 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
10 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_PO_VW

12 OPERATION_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Operation Yield

Default Value: 100

13 SIM_SETUP_QUEUE Character(1) VARCHAR2(1) NOT NULL Simultaneous Setup and Queue

Y/N Table Edit

Default Value: N

14 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code

Prompt Table: CE_CONCODE

15 CON_OH_CODE_1 Character(4) VARCHAR2(4) NOT NULL First Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

16 CON_OH_CODE_2 Character(4) VARCHAR2(4) NOT NULL Second Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

17 CON_OH_CODE_3 Character(4) VARCHAR2(4) NOT NULL Third Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

18 CON_OH_CODE_4 Character(4) VARCHAR2(4) NOT NULL Fourth Conversion Ovhd Code

Prompt Table: CE_CONOH_CODE

19 CONTINUOUS_FLG Character(1) VARCHAR2(1) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

20 IGNORE_CAPACITY Character(1) VARCHAR2(1) NOT NULL 08/29/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

21 SUB_ITEM_ID Character(18) VARCHAR2(18) NOT NULL 11/02/05 EGS: Created

Prompt Table: MG_SUB_ITEM_VW

22 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text