CM_CST_MVAR_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.

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 , '261' , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.BASE_CURRENCY , G.APPL_JRNL_ID , A.TRANS_DATE FROM PS_CM_CST_MUVAR_VW A , PS_SF_PRDNID_HEADR B , PS_SF_VARIANCES C , PS_BUS_UNIT_TBL_IN G 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 AND %Join(COMMON_KEYS, SF_VARIANCES C, BUS_UNIT_TBL_IN G)

# 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 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended 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
19 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
20 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
22 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
23 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
24 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple