CE_BU_BK_PID_VW

(SQL View)
 Index Back

BU/Book/PID View

3/21/03 lee: Initial create. Used in the PID Progress Inquiry.

SELECT A.BUSINESS_UNIT , B.CM_BOOK , A.PRODUCTION_ID , A.PROD_STATUS , %Round(%DecMult(%DecDiv(A.COMPLETED_QTY,A.EXPECTED_PRDN_QTY),100),2) , A.ORIG_START_DATE , A.ORIG_END_DATE , A.INV_ITEM_ID FROM PS_SF_PRDNID_HEADR A , PS_CM_BU_BOOK_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.EXPECTED_PRDN_QTY > 0 AND B.CM_BOOK_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUMGOP_NONVW

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

Prompt Table: CM_BU_BOOK_TBL

3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_PRID_H_VW

4 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
10=Entered
15=Firmed
20=Released
30=In Process
40=Pend Cmpl
50=Completed
60=Clsd/Labor
70=Clsd/Acctg
90=Canceled
5 SF_PRDN_PER_COMPL Number(10,2) DECIMAL(9,2) NOT NULL 10/21/98, eyz CN#800-6.0, added for Co-By Product Completions 11/04/99 MDS CN#EN800-6.0: Changed from 999.99 to 9999.99.
6 ORIG_START_DATE Date(10) DATE Original Start Date
7 ORIG_END_DATE Date(10) DATE Original Due Date
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID