QS_SESSN_TRC_VW

(SQL View)
 Index Back

View of qs_sessn_trace8


SELECT A.BUSINESS_UNIT , A.SESSN_ID , A.SAMPLE , A.BOM_CODE , A.COMPL_OP_SEQ , A.CONFIG_CODE , A.CONTAINER_ID , A.CREW_CODE , A.CUST_ID , A.DISTRIB_LINE_NUM , A.DISTRIB_SEQ_NUM , A.DT_TIMESTAMP , A.INV_ITEM_ID , A.INV_LOT_ID , A.LOT_ID , A.MACHINE_CODE , A.OPERATOR , A.OPRID , A.OP_SEQUENCE , A.PRDN_AREA_CODE , A.PRDN_DUE_SHIFT , A.PRODUCTION_ID , A.PRODUCTION_TYPE , A.QC_STEP_ID , A.QTY_INV_RECV , A.RECEIPT_DTTM , A.RECEIVER_ID , A.RECV_LN_NBR , A.RETURN_FR_CUST_ID , A.RETURN_FROM_BU , A.RMA_ID , A.RMA_LINE_NBR , A.RTG_CODE , A.SERIAL_ID , A.STAMP_DTTM , A.STATION_CODE , A.STORAGE_AREA , A.TAG_NUMBER , A.TASK_CODE , A.TOOL_CODE , A.VENDOR_ID , A.VENDOR_LOT_ID , A.WORK_CENTER_CODE FROM PS_QS_SESSN_TRACE8 A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SESSN_ID Character(30) VARCHAR2(30) NOT NULL Session ID
3 SAMPLE Number(4,0) SMALLINT NOT NULL Sample
4 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
5 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence
6 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
7 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
8 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
9 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
11 DISTRIB_SEQ_NUM Number(5,0) INTEGER NOT NULL Distribution Sequence
12 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
15 LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
16 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
17 OPERATOR Character(30) VARCHAR2(30) NOT NULL User ID
18 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
19 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
20 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
21 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
22 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
23 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
24 QC_STEP_ID Character(18) VARCHAR2(18) NOT NULL QC Step Id
25 QTY_INV_RECV Number(16,4) DECIMAL(15,4) NOT NULL Quantity Received
26 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime
27 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
28 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
29 RETURN_FR_CUST_ID Character(15) VARCHAR2(15) NOT NULL Return From Cust ID
30 RETURN_FROM_BU Character(5) VARCHAR2(5) NOT NULL Return From Location
31 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
32 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number
33 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
34 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
35 STAMP_DTTM DateTime(26) TIMESTAMP Date Stamp
36 STATION_CODE Character(10) VARCHAR2(10) NOT NULL Station Code
37 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
38 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
39 TASK_CODE Character(6) VARCHAR2(6) NOT NULL Task Code
40 TOOL_CODE Character(10) VARCHAR2(10) NOT NULL Tool ID
41 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
42 VENDOR_LOT_ID Character(15) VARCHAR2(15) NOT NULL Vendor Lot
43 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center