PL_PR_OP_RESRC

(SQL Table)
Index Back

PL Production Resources

01/15/03 EGS (CN#PL880-1): Added.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 SF_RESRC_TYPE Character(2) VARCHAR2(2) NOT NULL Resource Type
10=Crew
30=Machine
50=Tool
6 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
7 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
8 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID
9 TOOL_QTY Number(12,4) DECIMAL(11,4) NOT NULL Quantity Used