CM_CST_TEARA_VW

(SQL View)
 Index Back

Teardown Variance Upd Vw

08/05/99 ebn CN#SF800-13.0 New 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 , '265' , a.posted_flag , a.process_instance , a.process_flag , ' ' FROM PS_SF_VARIANCESB a WHERE variance_type IN ('13','14') AND variance_source IN ('C','O') AND posted_flag = 'N' AND cm_cost_mode = 'L'

# 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 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
11 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
12 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
13 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
14 ADJUST_TYPE Character(1) VARCHAR2(1) NOT NULL Adjustment Type
0=CM Only
A=VMI Return
D=Decrease
I=Increase
M=Misc Issue
R=Misc Return
S=Scrap
V=Scrap RTV