SF_OP_RESRC_TMP(SQL Table) |
Index Back |
---|---|
Production Operation ResourcesProduction Operation Resources |
# | 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 |