SF_COMP_TRC_TMP(SQL Table) |
Index Back |
|---|---|
Component Transfer Temp07/14/99 SCC CN#SF800-9.0: Component Transfer To Pid selection |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEL | Character(1) | VARCHAR2(1) NOT NULL |
Select
Y/N Table Edit Default Value: N |
| 2 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 3 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 4 | MG_ORIG_COMP_ID | Character(18) | VARCHAR2(18) NOT NULL | original component ID |
| 5 | CURR_SCHED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED |
| 6 | ISSUE_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY |
| 7 | QTY_SHORT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Short |
| 8 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 9 | YIELD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY |
| 10 | PEND_CONSUME_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME |
| 11 | PEND_LOSS_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS |
| 12 | ISSUE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp. ISS=Issue KIT=Kit REPL=Replenish |
| 13 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |