SF_TRC_INQ_TMP1

(SQL Table)
 Index Back

Genealogy

# 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 PRCSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
4 SETID_INV_ITEM Character(5) VARCHAR2(5) NOT NULL Inv Items SETID
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 TOP_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Top Level Assembly
7 TOP_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
8 TOP_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
9 SF_TRC_EXP_LVL_ENG Signed Number(6,0) DECIMAL(5) NOT NULL Level Code
10 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
11 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
12 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
13 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: %EDITTABLE5

14 COMP_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
15 COMP_LOT_ID Character(15) VARCHAR2(15) NOT NULL Component Lot ID
16 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_PRDNID_HEADR

17 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
18 LAST_DTTIME DateTime(26) TIMESTAMP Last Date Time
19 SF_TRC_PRDN_STATUS Character(1) VARCHAR2(1) NOT NULL Production Trace Status
1=Associated
2=Disassoc
3=Torndown
4=Split
5=Rework
20 SF_TRC_USAG_STATUS Character(1) VARCHAR2(1) NOT NULL FRD
1=Associated
2=Disassoc
3=Torndown
4=Split