CM_CST_USAGE_VW

(SQL View)
 Index Back

Costed Usage Variance Vw

GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows.

select a.business_unit, a.production_id, a.variance_type, a.cost_element, a.variance_source, a.seq_nbr, a.trans_date, a.trans_time, a.total_cost, a.distrib_type, a.posted_flag, a.prdn_area_code, b.inv_item_id, a.production_type, a.process_instance, a.variance_amount, a.process_flag from ps_cm_cst_usaga_vw a, PS_SF_PRDNID_HEADR b where a.business_unit = b.business_unit and a.production_id = b.production_id

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 TRANS_DATE Date(10) DATE Transaction Date
8 TRANS_TIME Time(15) TIMESTAMP Transaction Time
9 TOTAL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Cost
10 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

Prompt Table: CM_DISTR_TYPE

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 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
13 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
14 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
15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
16 VARIANCE_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Variance Amount
17 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least