CM_PRODVARX_VW

(SQL View)

SELECT ACCTG_LINE_NO ,DEBIT_CREDIT ,BUSINESS_UNIT ,VARIANCE_TYPE ,ACCOUNTING_DT ,SEQ_NBR ,PRDN_AREA_CODE ,PRODUCTION_ID ,COST_ELEMENT ,MONETARY_AMOUNT ,%Abs(%Round(MONETARY_AMOUNT,4) ) ,CURRENCY_CD ,INV_ITEM_ID FROM PS_CM_ACCTG_LINE WHERE TRANSACTION_GROUP IN ('261','262','263','264','265') AND VARIANCE_TYPE <> ' ' AND EXISTS ( SELECT 'X' FROM PS_SF_VARS_DETAIL WHERE PS_CM_ACCTG_LINE.BUSINESS_UNIT = PS_SF_VARS_DETAIL.BUSINESS_UNIT AND PS_CM_ACCTG_LINE.PRODUCTION_ID = PS_SF_VARS_DETAIL.PRODUCTION_ID AND PS_CM_ACCTG_LINE.VARIANCE_TYPE = PS_SF_VARS_DETAIL.VARIANCE_TYPE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACCTG_LINE_NO Number(15,0) DECIMAL(15) NOT NULL Accounting Line Number

2 DEBIT_CREDIT Character(2) VARCHAR2(2) NOT NULL Debit / Credit Indicator
CR=Credit
DR=Debit

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUMGA_NONVW

4 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

5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple

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

7 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
Prompt Table: SF_PRDN_AREA

8 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
Prompt Table: SF_PID_VARS2_VW

9 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

10 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

11 VARIANCE_AMOUNT2 Signed Number(16,4) DECIMAL(14,4) NOT NULL Variance Amount

12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACCTG_LINE_NO	Number(15,0)	DECIMAL(15) NOT NULL	Accounting Line Number
2	DEBIT_CREDIT	Character(2)	VARCHAR2(2) NOT NULL	Debit / Credit Indicator CR=Credit DR=Debit
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMGA_NONVW
4	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
5	ACCOUNTING_DT	Date(10)	DATE	The accounting entry construction date for a given transaction (a generic field that crosses multiple
6	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
7	PRDN_AREA_CODE	Character(10)	VARCHAR2(10) NOT NULL	Production Area Prompt Table: SF_PRDN_AREA
8	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Prompt Table: SF_PID_VARS2_VW
9	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
10	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
11	VARIANCE_AMOUNT2	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID