SEQUENCENO1=Associated
2=Disassoc
3=Torndown
4=Split
5=Rework
1=Associated
2=Disassoc
3=Torndown
4=Split
SF_TRC_INQ_VW1(SQL View) |
Index Back |
|---|---|
Genealogy |
| SELECT 0 ,STIT1.OPRID , STIT1.PRCSINSTANCE , STIT1.CREATEDTTM , STIT1.SETID_INV_ITEM , STIT1.BUSINESS_UNIT , STIT1.TOP_ITEM_ID , STIT1.TOP_SERIAL_ID , STIT1.TOP_LOT_ID , STIT1.SF_TRC_EXP_LVL_ENG , STIT1.INV_ITEM_ID , STIT1.SERIAL_ID , STIT1.INV_LOT_ID , STIT1.COMPONENT_ID , STIT1.COMP_SERIAL_ID , STIT1.COMP_LOT_ID , STIT1.PRODUCTION_ID , STIT1.QTY , STIT1.LAST_DTTIME , MIT1.DESCR , MIT1.UNIT_MEASURE_STD , STIT1.SF_TRC_PRDN_STATUS , STIT1.SF_TRC_USAG_STATUS FROM PS_SF_TRC_INQ_TMP1 STIT1 , PS_MASTER_ITEM_TBL MIT1 WHERE STIT1.SETID_INV_ITEM = MIT1.SETID AND ((STIT1.SF_TRC_EXP_LVL_ENG < 0 AND STIT1.INV_ITEM_ID = MIT1.INV_ITEM_ID) OR (STIT1.SF_TRC_EXP_LVL_ENG >= 0 AND STIT1.COMPONENT_ID = MIT1.INV_ITEM_ID)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQUENCENO |
Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | PRCSINSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 4 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation |
| 5 | SETID_INV_ITEM | Character(5) | VARCHAR2(5) NOT NULL | Inv Items SETID |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 7 | TOP_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Top Level Assembly |
| 8 | TOP_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 9 | TOP_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 10 | SF_TRC_EXP_LVL_ENG | Signed Number(6,0) | DECIMAL(5) NOT NULL | Level Code |
| 11 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 12 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 13 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lot ID |
| 14 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 15 | COMP_SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL | Serial ID |
| 16 | COMP_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL | Component Lot ID |
| 17 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 18 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 19 | LAST_DTTIME | DateTime(26) | TIMESTAMP | Last Date Time |
| 20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 21 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 22 | SF_TRC_PRDN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Production Trace Status
1=Associated 2=Disassoc 3=Torndown 4=Split 5=Rework |
| 23 | SF_TRC_USAG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FRD
1=Associated 2=Disassoc 3=Torndown 4=Split |