SF_OP_RESRC_TMP

(SQL Table)
Index Back

Production Operation Resources

Production 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