BCT_MG_PIK_EVW

(SQL View)
Index Back

Production Picking

04/08/03 MEG: Added production_id.

SELECT A.EIP_TRANS_SRC , A.EIP_TRANS_SRC_REF , B.EIP_TRANS_SRC_SEQ , A.OPRID , A.DEVICE_ID , B.DEVICE_DTTIME , B.BUSINESS_UNIT , B.TRANSACTION_CODE , B.INV_LOT_ID , B.SERIAL_ID , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.CONTAINER_ID , B.UNIT_OF_MEASURE , B.QTY , B.COMPLETE_FLG , B.PICK_BATCH_ID , B.PICKLIST_LINE_NO , B.COMPONENT_ID , B.UOM_ORIG , B.PRODUCTION_ID FROM PS_BCT_DTL B , PS_BCT_CTL A WHERE A.EIP_CTL_ID = B.EIP_CTL_ID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EIP_TRANS_SRC Character(30) VARCHAR2(30) NOT NULL 08/02/99 NAS: Created the field for MES but it will be owned by Entreprise, they just don't know it yet :-)
2 EIP_TRANS_SRC_REF Character(30) VARCHAR2(30) NOT NULL Source Reference
3 EIP_TRANS_SRC_SEQ Number(15,0) DECIMAL(15) NOT NULL Source Transaction Sequence
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 DEVICE_ID Character(10) VARCHAR2(10) NOT NULL Device ID
6 DEVICE_DTTIME DateTime(26) TIMESTAMP Device Date Time
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 TRANSACTION_CODE Character(4) VARCHAR2(4) NOT NULL Transaction Code
9 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
10 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
11 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
12 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
13 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
14 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
15 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
16 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
17 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
18 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
19 COMPLETE_FLG Character(1) VARCHAR2(1) NOT NULL Complete Flag
0=Process Location
1=Pick Line Complete
2=Pick Batch Complete
3=Pick Line as Planned
4=Pick Batch as Planned
5=Process Location - Incomplete
6=Complete Pick - Zero Quantity
7=Complete Pick - Leave Alone
8=Complete Pick - Dft Ship Loc
A=Use Defaults
B=No Action
20 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
21 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
22 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
23 UOM_ORIG Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure
24 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID