CM_CST_VAR_VW (SQL View)	Index Back
Costed Production Variance Vw GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. 07/21/99 ebn CN#CM800-9.0 Changed keys to reflect changes made to sf_variances keys. Incorporated table SF_VARIANCESB into view.

CM_CST_VAR_VW

(SQL View)

Costed Production Variance Vw

GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. 07/21/99 ebn CN#CM800-9.0 Changed keys to reflect changes made to sf_variances keys. Incorporated table SF_VARIANCESB into view.

SELECT a.business_unit , a.production_id , a.variance_type , a.cost_element , a.variance_source , a.trans_date , a.trans_time , a.seq_nbr , a.cm_book , c.variance_amount , c.distrib_type , a.posted_flag , c.prdn_area_code , b.inv_item_id , c.production_type , a.process_instance , c.variance_amount , a.process_flag FROM ps_cm_cst_vaa_vw a , ps_sf_prdnid_headr b , PS_SF_VARIANCES c WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id AND a.business_unit = c.business_unit AND a.production_id = c.production_id AND a.variance_type = c.variance_type AND a.cost_element = c.cost_element AND a.variance_source = c.variance_source AND a.trans_date = c.trans_date AND a.trans_time = c.trans_time AND a.seq_nbr = c.seq_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 VARIANCE_TYPE Character(2) VARCHAR2(2) NOT NULL 9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance
02=Usage Variance
03=Component Yield Variance
04=Labor Lot Size Variance
05=Process Routing Variance
06=Efficiency Variance
07=Rate Variance
08=Material Lot Size Variance
09=Rework Expense
10=Rework Labor Expense
11=Outside Processing PPV
12=Mix Variance
13=Teardown Material Expense
14=Teardown Conversion Expense
15=Yield Variance
16=Co-Product Rate Var
17=Material Rate Variance

4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
Prompt Table: CM_ELEMENT

5 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
C=Close
O=Re-Open
R=Report

6 TRANS_DATE Date(10) DATE NOT NULL Transaction Date

7 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time

8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

10 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost

11 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
Prompt Table: CM_DISTR_TYPE

12 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted

13 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

15 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown

16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

17 VARIANCE_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Variance Amount

18 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
3	VARIANCE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	9/9/02 CRC: added variance type '15' for Yield Variance 01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance
4	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element Prompt Table: CM_ELEMENT
5	VARIANCE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Variance Source C=Close O=Re-Open R=Report
6	TRANS_DATE	Date(10)	DATE NOT NULL	Transaction Date
7	TRANS_TIME	Time(15)	TIMESTAMP NOT NULL	Transaction Time
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
10	TOTAL_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Total Cost
11	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
12	POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program. N=Not Posted X=Don't Post Y=Posted
13	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area
14	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
15	PRODUCTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	JNW 11/1/98 (CN#SF800-13) activated teardown xlat PR=Production RW=Rework SV=Service TD=Teardown
16	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
17	VARIANCE_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount
18	PROCESS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Process Flag A=Purge All S=Only purge items with at least