BUSINESS_UNITSEQ_NBROP_SEQUENCESF_RESRC_TYPE10=Crew
30=Machine
50=Tool
Prompt Table: EN_WC_CREW_VW
Prompt Table: EN_WC_MACH_VW
Prompt Table: EN_WC_TOOL_VW
PL_SF_OP_RESRC(SQL Table) |
Index Back |
|---|---|
PL/Prd Operation ResourcesThis record defines the resources assigned to the operations by the Red Pepper Planning system. SCC 01/13/97 (MFG-SCHEW-8): Production ID was added in between keys SEQ_NBR and OP_SEQUENCE in release 6. Fix record so that Production ID is after the keys. CN #MG800-1.0 - 7/30/98 rs - Scrolls to grid conversion - made PCode changes in SF_RESRC_TYPE RowInit |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | SF_RESRC_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Resource Type
10=Crew 30=Machine 50=Tool |
| 5 | PROBINST | Character(20) | VARCHAR2(20) NOT NULL | Optimization Problem Instance |
| 6 | PL_SEQ_NBR | Number(9,0) | DECIMAL(9) NOT NULL | 01/09/02 EGS (CN#PL900-1): Added |
| 7 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 8 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: EN_WC_CREW_VW |
| 9 | MACHINE_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Machine Code
Prompt Table: EN_WC_MACH_VW |
| 10 | TOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Tool ID
Prompt Table: EN_WC_TOOL_VW |
| 11 | TOOL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Used |
| 12 | PLANNER_CD | Character(12) | VARCHAR2(12) NOT NULL | Planner Code |
| 13 | PLANNING_TIMESTAMP | DateTime(26) | TIMESTAMP | Planning Date and Time |
| 14 | PLANNING_VERSION | Character(20) | VARCHAR2(20) NOT NULL | Planning Version |