BUSINESS_UNITPrompt Table: BUS_UNIT_OPT_MG
PRODUCTION_IDOP_SEQUENCESF_RESRC_TYPE10=Crew
30=Machine
50=Tool
CREW_CODEPrompt Table: EN_WC_CREW_VW
MACHINE_CODEPrompt Table: EN_WC_MACH_VW
TOOL_CODEPrompt Table: EN_WC_TOOL_VW
SF_OP_RESRC(SQL Table) |
Index Back |
|---|---|
Production Operation Resources9/19/97 jnw cn#pl700-di-gpenn-52 added net_change_ep logic for era net change CN #MG800-1.0 - 7/30/98 rs - Scrolls to grid conversion - made PCode changes and moved PCode from Crew/Machine/Tool FEd/FCh to EN_PANELS_WRK.RESRC_CODE |
| # | 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 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 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 | CREW_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Crew Name
Prompt Table: EN_WC_CREW_VW |
| 6 | MACHINE_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Machine Code
Prompt Table: EN_WC_MACH_VW |
| 7 | TOOL_CODE |
Character(10) | VARCHAR2(10) NOT NULL |
Tool ID
Prompt Table: EN_WC_TOOL_VW |
| 8 | TOOL_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Used |