BCT_MG_OISS_EVW

(SQL View)
Index Back

Production Order Issue

frd

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.PRODUCTION_ID , B.COMPONENT_ID , B.MG_ORIG_COMP_ID , B.OP_SEQUENCE , B.QTY_CODE , B.INV_LOT_ID , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.CONTAINER_ID , B.SUB_ITM_ID , B.QTY , B.YIELD_QTY , B.UNIT_OF_MEASURE 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 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
10 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
11 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
12 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
13 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
14 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
15 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
16 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
17 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
18 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
19 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
20 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
21 SUB_ITM_ID Character(18) VARCHAR2(18) NOT NULL 11/30/99 RML Added label "Substitute"
22 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
23 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
24 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage