SF_PICKLOC_TMP

(SQL Table)
Index Back

Picking Location Temp

# 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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
4 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
5 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
6 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
7 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
8 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
9 PARENT_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Parent Item ID
10 TO_STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
11 TO_STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
12 TO_STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
13 TO_STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
14 TO_STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
16 STAGED_DATE Date(10) DATE Staged Date
17 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
18 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
19 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
20 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
21 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
22 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
23 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
24 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
25 QTY_PICKED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked in Phys Loc UOM
26 UNIT_MEASURE_PICK Character(3) VARCHAR2(3) NOT NULL Phys Location Unit of Measure
27 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
28 QTY_SHORT Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Short
29 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
30 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
31 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
32 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
33 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
34 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
35 DESCR Character(30) VARCHAR2(30) NOT NULL Description
36 SUBCONTRACTED Character(1) VARCHAR2(1) NOT NULL Subcontracted
N=No
Y=Yes
37 NEW_START_DATE Date(10) DATE Start Date
38 NEW_START_TIME Time(15) TIMESTAMP Start Time
39 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick
40 SUBSTITUTE_FLG Character(1) VARCHAR2(1) NOT NULL Substitute Flag
41 ASRS_ID Number(15,0) DECIMAL(15) NOT NULL ASRS Identifier
42 ZONE_CD Character(6) VARCHAR2(6) NOT NULL Zone code
43 SERIAL_IN_PRDN Character(1) VARCHAR2(1) NOT NULL Serial in Production
44 FPB_WORKFLOW_FLG Character(1) VARCHAR2(1) NOT NULL Use Fixed Pick Workflow
45 FPB_ROLENAME Character(30) VARCHAR2(30) NOT NULL Fixed Picking Bin Role Name
46 FPB_RTE_CNTL_TYPE Character(30) VARCHAR2(30) NOT NULL Route Control Type
47 FPB_RTE_FROM_VALUE Character(30) VARCHAR2(30) NOT NULL From Value
48 FPB_RTE_TO_VALUE Character(30) VARCHAR2(30) NOT NULL To Value