CM_CST_REVAL_VW

(SQL View)
 Index Back

Std Cost Revaluation View

GMG CN# CM750-8.0 Changes for SEQ_NBR field; value assigned by Accounting to achieve unique rows. PSG CN# CM750-10.0 Added 7 fields to this view after process_instance so that all fields in ce_itemcvar_pst are selected here. (This is a requirement to be able to populate seq_nbr in Accounting). CN# CM750-10.0 PSG 11/10/97 - multiply PxQ in COBOL instead of the view to aviod error when there are too many decimals. 07/21/99 ebn CN#CM800-9.0 Changed keys to reflect changes made to ce_itemcvar_pst keys. Incorporated table CE_ITEMCVAR_PSB into view.

SELECT A.MG_PROC_INSTANCE , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.INV_ITEM_ID , A.STORAGE_AREA , A.CONFIG_CODE , A.COST_ELEMENT , A.REVALUE_TYPE , A.SEQ_NBR , A.CM_BOOK , B.PRODUCTION_AREA , B.PRODUCTION_TYPE , B.STAGED_DATE , B.INV_LOT_ID , B.SERIAL_ID , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.CONTAINER_ID , B.UNIT_OF_MEASURE , A.PROCESS_INSTANCE , -(B.VAR_TL_COST + B.VAR_LL_COST) , '200' , B.QTY_BASE , B.UNIT_MEASURE_STD , B.REVALUE_DATE , B.DISTRIB_TYPE , A.POSTED_FLAG , A.PROCESS_FLAG , B.NEW_TL_COST , B.NEW_LL_COST , B.PRD_TL_COST , B.PRD_LL_COST , B.VAR_TL_COST , B.VAR_LL_COST , B.NEW_TRANS_GROUP , B.JOB_INSTANCE , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.BASE_CURRENCY , G.APPL_JRNL_ID , B.REVALUE_DATE FROM PS_CM_CST_REVAA_VW A , PS_CE_ITEMCVAR_PST B , PS_BUS_UNIT_TBL_IN G WHERE A.MG_PROC_INSTANCE = B.MG_PROC_INSTANCE AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.STORAGE_AREA = B.STORAGE_AREA AND A.CONFIG_CODE = B.CONFIG_CODE AND A.COST_ELEMENT = B.COST_ELEMENT AND A.REVALUE_TYPE = B.REVALUE_TYPE AND A.SEQ_NBR = B.SEQ_NBR AND %Join(COMMON_KEYS, CE_ITEMCVAR_PST A, BUS_UNIT_TBL_IN G)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_IN

3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MASTER_ITEM_TBL

5 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
6 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
7 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

Prompt Table: CM_ELEMENT

8 REVALUE_TYPE Character(2) VARCHAR2(2) NOT NULL 1/25/99 - CRC EN800-6.0 : added revalue type = '05' for co/by product
01=Inventory
02=Inspection
03=WIP - Comp
04=WIP - Assy
05=WIP - Waste
9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
10 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
11 PRODUCTION_AREA Character(10) VARCHAR2(10) NOT NULL Production Area
12 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
13 STAGED_DATE Date(10) DATE Staged Date
14 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
15 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
16 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1
17 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2
18 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3
19 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4
20 CONTAINER_ID Character(10) VARCHAR2(10) NOT NULL Container ID
21 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
22 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
23 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
24 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
25 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
26 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
27 REVALUE_DATE Date(10) DATE Creation Date

Default Value: %date

28 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
29 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

Y/N Table Edit

Default Value: N

30 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
31 NEW_TL_COST Number(15,4) DECIMAL(14,4) NOT NULL New This Level Cost
32 NEW_LL_COST Number(15,4) DECIMAL(14,4) NOT NULL New Lower Level Cost
33 PRD_TL_COST Number(15,4) DECIMAL(14,4) NOT NULL Production This Lvl Cost
34 PRD_LL_COST Number(15,4) DECIMAL(14,4) NOT NULL Production Lower Lvl Cost
35 VAR_TL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL This level Cost Variance
36 VAR_LL_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Lower Level Cost Variance
37 NEW_TRANS_GROUP Character(3) VARCHAR2(3) NOT NULL New Transaction Group
38 JOB_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
39 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
40 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
41 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
42 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
43 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple