CM_WRK_TMP(SQL Table) |
Index Back |
|---|---|
Used as temp tblUsed in the Costed BOM and Costed Routing pages as a temp table to store work fields that are used in insert/select statements |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | OP_SEQUENCE_FIRST | Number(4,0) | SMALLINT NOT NULL | First Operation Sequence |
| 3 | OP_SEQUENCE_MAX | Number(4,0) | SMALLINT NOT NULL | Op Sequence Max |
| 4 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 5 | EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Required Qty |
| 6 | YLD_EXPL_QTY1 | Number(16,7) | DECIMAL(15,7) NOT NULL | Exploded Qty with Yield |
| 7 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |