PROCESS_INSTANCEBUSINESS_UNITPRODUCTION_IDOP_SEQUENCECOST_ELEMENTORIG_OP_SEQUENCECOMP=Component
LAB=Labor
OVHD=OVHD
SF_SCYLDCST_TMP(SQL Table) |
Index Back |
|---|---|
Scrap Yield Cost Temp Table11/25/02 crc F-SMERENDA-86: Cumulative Cost Temp Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process 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 | COST_ELEMENT |
Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 6 | ORIG_OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | 10/10/99 MDS (CN#EN800-1.0) Added field to SF_COMPSUB_WRK for FieldEdit of item substitutes. |
| 7 | SCRAP_REC_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Scrap Record Type
COMP=Component LAB=Labor OVHD=OVHD |
| 8 | EXT_QPA_COST1 | Signed Number(20,8) | DECIMAL(18,8) NOT NULL | Extended Cost |