INV_SIT_VW2

(SQL View)
 Index Back

Production Issue Transfer Tabl

01/21/99 meg (cn# EN800-1.0) Added MG_ORIG_COMP_ID 02/19/99 meg (cn# SF800) Moved picklist_line_no up to right after pick_batch_id. 09/99 meg (cn# SF800) Changed keys 10/04/99 ST CN# EN800-13.0 Modified edittable15,16,17 to 19,20,21 on STOR_LEVEL_2, STOR_LEVEL_3, STOR_LEVEL_4 11/05/02 meg CN#MG880. Added asrs_id, zone_cd, serial_in_prdn, comp_serial_id. 01/24/03 MEG CN#MG880: Set prompt table for serial_id to sf_comp_srl2_vw.

SELECT BUSINESS_UNIT , PICK_BATCH_ID , PICKLIST_LINE_NO , SERIAL_ID , COMP_SERIAL_ID , STAGED_DATE , INV_LOT_ID , CONTAINER_ID , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , UNIT_MEASURE_PICK , COMPONENT_ID , PRODUCTION_ID , OP_SEQUENCE , MG_ORIG_COMP_ID , QTY_CODE , TO_STORAGE_AREA , TO_STOR_LEVEL_1 , TO_STOR_LEVEL_2 , TO_STOR_LEVEL_3 , TO_STOR_LEVEL_4 , SEQUENCE_NBR_6 , QTY_PICKED , QTY_PICKED_CONV , QTY_PICK_ACTUAL , QTY_PICK_ACTL_CONV , CONFIRMED_FLAG , COMPLETED_FLG , QTY_SHORT , NON_OWN_FLAG , CONFIG_CODE , INV_ITEM_ID , PRDN_AREA_CODE , PRODUCTION_TYPE , WORK_CENTER_CODE , DESCR , SUBCONTRACTED , NEW_START_DATE , NEW_START_TIME , DELETE_FLG , ASRS_ID , ZONE_CD , SERIAL_IN_PRDN FROM PS_SF_ISS_TRANSFER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
3 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
4 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: SF_COMP_SRL2_VW

5 COMP_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
6 STAGED_DATE Date(10) DATE Staged Date
7 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Prompt Table: %EDITTABLE11

8 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID

Prompt Table: %EDITTABLE12

9 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

Prompt Table: %EDITTABLE13

10 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

Prompt Table: %EDITTABLE14

11 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

Prompt Table: %EDITTABLE19

12 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

Prompt Table: %EDITTABLE20

13 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

Prompt Table: %EDITTABLE21

14 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure

Prompt Table: %EDITTABLE18

15 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
16 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
17 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
18 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
19 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
20 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
21 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
22 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
23 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
24 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
25 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
26 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
27 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM
28 QTY_PICK_ACTUAL Signed Number(17,4) DECIMAL(15,4) NOT NULL Actual Qty Picked
29 QTY_PICK_ACTL_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
30 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

Y/N Table Edit

Default Value: N

31 COMPLETED_FLG Character(1) VARCHAR2(1) NOT NULL Completed
N=Not Completed
Y=Complete

Y/N Table Edit

Default Value: N

32 QTY_SHORT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Short
33 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
34 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
35 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
36 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
37 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
38 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
39 DESCR Character(30) VARCHAR2(30) NOT NULL Description
40 SUBCONTRACTED Character(1) VARCHAR2(1) NOT NULL Subcontracted
N=No
Y=Yes
41 NEW_START_DATE Date(10) DATE Start Date
42 NEW_START_TIME Time(15) TIMESTAMP Start Time
43 DELETE_FLG Character(1) VARCHAR2(1) NOT NULL Delete Loaded Items

Default Value: N

44 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier
45 ZONE_CD Character(6) VARCHAR2(6) NOT NULL Zone code
46 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production