BCT_D_MG_PO_VW

(SQL View)
 Index Back

BCT Detail Mfg PO Completion

BCT Detail record view of MFG Completions for use by purchasing receiving and RTV.

SELECT A.BUSINESS_UNIT , A.UNIT_OF_MEASURE , A.PRODUCTION_ID , A.COMPL_OP_SEQ , SUM(A.COMPL_QTY) , SUM(A.SCRAPPED_QTY) FROM PS_BCT_DTL A WHERE A.TRANSACTION_CODE IN ('0112', '0113') AND A.BCT_DET_STATUS IN ('0', '1') GROUP BY A.BUSINESS_UNIT , A.UNIT_OF_MEASURE , A.PRODUCTION_ID , A.COMPL_OP_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 COMPL_OP_SEQ Number(4,0) SMALLINT NOT NULL Completion Operation Sequence
5 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty
6 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty