SF_TRC_PRDN_VW5(SQL View) |
Index Back |
---|
SELECT BUSINESS_UNIT , INV_ITEM_ID , PRODUCTION_ID , SERIAL_ID FROM PS_SF_TRC_PRDN WHERE SF_TRC_PRDN_STATUS = '1' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
2 | Character(18) | VARCHAR2(18) NOT NULL | 01/31/03 MDS CN#MG880-Genealogy: Needed this clone of inv_item_id for the serial id prompt table in td completions because tools always finds a blank inv_item_id (because it's on multiple records in this component). | |
3 | Character(10) | VARCHAR2(10) NOT NULL | 01/31/03 MDS CN#MG880-Genealogy: Needed this clone of production_id for the serial id prompt table in td completions because tools always finds a blank production_id (because it's on multiple records in this component). | |
4 | Character(20) | VARCHAR2(20) NOT NULL | 02/26/03 MDS CN#MG880-Genealogy: Added this field to prompt for assembly serial id for teardown completions. |