EN_TASKS(SQL Table) |
Index Back |
---|---|
Routing TasksCN#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 |