CE_BUBK_PID_VW1

(SQL View)
 Index Back

BU Book PID latest proac costs

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

SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.PRODUCTION_ID , A.PROD_STATUS , A.SF_PRDN_PER_COMPL , A.ORIG_START_DATE , A.ORIG_END_DATE , A.INV_ITEM_ID , B.EXTENDED_COST_TOT FROM PS_CE_BU_BK_PID_VW A ,PS_CE_PID_PROAC_VW B WHERE A.CM_BOOK = B.CM_BOOK (+) AND A.PRODUCTION_ID = B.PRODUCTION_ID (+) AND A.BUSINESS_UNIT = B.BUSINESS_UNIT (+)

# 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
9 EXTENDED_COST_TOT Signed Number(16,2) DECIMAL(14,2) NOT NULL Latest Cost Measure