SF_TRC_TD_VW1(SQL View) |
Index Back |
|---|---|
TD Completions Serial ID View101/31/2003 MDS CN#MG880-Genealogy: Added serial ID prompt table for completing serial_in_prdn teardown outputs. |
| SELECT SETID_INV_ITEM ,BUSINESS_UNIT ,INV_ITEM_ID ,SERIAL_ID ,INV_LOT_ID ,TRANSACTION_NBR ,COMPONENT_ID ,OP_SEQUENCE ,MG_ORIG_COMP_ID ,QTY_CODE ,COMP_SERIAL_ID ,COMP_LOT_ID ,SCHED_QTY ,SF_TEARDOWN_QTY FROM PS_SF_TRC_USAG WHERE SF_TRC_USAG_STATUS = '1' AND INV_ITEM_ID <> COMPONENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_INV_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 5 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 6 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL | 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size. |
| 7 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 8 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 9 | MG_ORIG_COMP_ID | Character(18) | VARCHAR2(18) NOT NULL | original component ID |
| 10 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 11 | COMP_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 12 | COMP_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Component Lot ID |
| 13 | SCHED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Component Scheduled Qty |
| 14 | SF_TEARDOWN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Quantity Torn Down |