BCT_MG_CPL_EVW

(SQL View)
 Index Back

Production Order Completions

FRD 01/05/04 PWF Adding COMPLETE_FLG to record.

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.SF_KANBAN_ID , B.PRODUCTION_ID , B.PRDN_AREA_CODE , B.INV_ITEM_ID , B.REVISION , B.BOM_CODE , B.RTG_CODE , B.SF_BOM_RTG_EFFDT , B.COMPL_OP_SEQ , B.UPDATE_OP_SEQ , B.COMPL_QTY , B.SCRAPPED_QTY , B.REASON_CD , B.PERCENT_COMP , B.DISTRIB_TYPE , B.MG_OUTPUT_ITEM , B.MG_OUTPUT_SEQ , B.MG_OUTPUT_COMPL , B.MG_OUTPUT_TYPE , B.MG_OUTPUT_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.TO_PRODUCTION_ID , B.OP_SEQUENCE , B.MG_TRANS_UOM , B.UNIT_OF_MEASURE , B.MG_UNPLAN_OUTPUT , B.END_TRANS_FLG , B.MG_ISSUE_COMP_FLG , B.COMPLETE_FLG 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 SF_KANBAN_ID Character(15) VARCHAR2(15) NOT NULL Kanban ID
10 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
11 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
14 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
15 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
16 SF_BOM_RTG_EFFDT Date(10) DATE 12/28/98,eyz, CN#EN800-4.0, new this as a workfield in Completions for the Recipe Management feature.
17 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence
18 UPDATE_OP_SEQ Number(4,0) SMALLINT NOT NULL Back Thru Operation
19 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
20 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty
21 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
22 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
23 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
24 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
25 MG_OUTPUT_SEQ Number(4,0) SMALLINT NOT NULL NAS 022399 (CN# EN800-6.0) Field required for Message Agent definition of Multiple Outputs Completion.
26 MG_OUTPUT_COMPL Signed Number(13,4) DECIMAL(11,4) NOT NULL 990105 nas (CN# EN800-6.0) This field will contain the user inputted quantity completed of a specific output within completion process.
27 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste
28 MG_OUTPUT_QTY_CODE Character(3) VARCHAR2(3) NOT NULL 01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future.
ASY=Assembly
ORD=Order
29 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
30 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
31 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
32 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
33 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
34 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
35 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
36 TO_PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL To Production ID
37 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
38 MG_TRANS_UOM Character(3) VARCHAR2(3) NOT NULL 01/19/99 NAS (CN#800-6.0) Created new field
39 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
40 MG_UNPLAN_OUTPUT Character(1) VARCHAR2(1) NOT NULL 01/19/99 nas (CN#800-6.0) Created new field.
41 END_TRANS_FLG Character(1) VARCHAR2(1) NOT NULL End of Transaction Flag
42 MG_ISSUE_COMP_FLG Character(1) VARCHAR2(1) NOT NULL NAS - 09-27-99 Created - Will be used to determine if the program must issue components a standard or will we be expecting component consuption transactions from user/external source.
N=Use comp.issue trans. provided
Y=Program Generate Issue Trans.
43 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