CM_CST_WIPR2_VW

(SQL View)
 Index Back

WIP Revalue Earned Conv Costs

PSG CN# CM750-10.0 11/5/97 GMG Make revalue_flag a key 05/25/99 EBN CN#SF800-9.0: Add field prdn_split. 07/21/99 ebn CN#CM800-9.0 Changed keys to reflect changes made to sf_earnconcost keys. Incorporated table SF_EARNCONCOSTB into view.

SELECT A.MG_PROC_INSTANCE , A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.COST_ELEMENT , A.CONVERSION_TYPE , A.TRANS_DATE , A.TRANS_TIME , A.SEQ_NBR , A.REVALUE_FLAG , A.CM_BOOK , B.INV_ITEM_ID , B.UNIT_MEASURE_STD , B.PRDN_AREA_CODE , B.PRODUCTION_TYPE , -B.CONVERSION_AMT , B.QTY_BASE , B.DISTRIB_TYPE , A.POSTED_FLAG , A.PROCESS_INSTANCE , B.CONVERSION_AMT , B.RATE_AMOUNT , B.RATE_TYPE , B.OP_TIME_RATE , B.OP_TIME_RATE_UNIT , B.OVERHEAD_RATE , B.OVERHEAD_PERCENT , B.OH_RATE_TYPE , B.OH_LAB_MACH_AMT , B.EARN_COST_QTY , B.PRORATE_QTY , B.PERCENT_COMP , B.DAILY_CAPACITY , B.CREWSIZE , B.MACH_RESOURCES , B.PRDN_SPLIT_FLG , A.PROCESS_FLAG , B.OPRID , '211' , G.BUSINESS_UNIT_GL , G.BASE_CURRENCY , G.BASE_CURRENCY , G.APPL_JRNL_ID , A.TRANS_DATE FROM PS_CM_CST_WIPA2_VW A , PS_SF_EARNCONCOST 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.OP_SEQUENCE = B.OP_SEQUENCE AND A.COST_ELEMENT = B.COST_ELEMENT AND A.CONVERSION_TYPE = B.CONVERSION_TYPE AND A.TRANS_DATE = B.TRANS_DATE AND A.TRANS_TIME = B.TRANS_TIME AND A.SEQ_NBR = B.SEQ_NBR AND A.REVALUE_FLAG = B.REVALUE_FLAG AND %Join(COMMON_KEYS, SF_EARNCONCOST B, 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
3 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CONVERSION_TYPE Character(4) VARCHAR2(4) NOT NULL Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4
7 TRANS_DATE Date(10) DATE NOT NULL Transaction Date
8 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time
9 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
10 REVALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.

Y/N Table Edit

11 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
12 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
13 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
14 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
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 CE_EXTENDED_COST Signed Number(32,15) DECIMAL(30,15) NOT NULL Extended Cost
17 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity

Default Value: 1

18 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
19 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
20 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
21 CONVERSION_AMT Signed Number(12,4) DECIMAL(10,4) NOT NULL Conversion Amount
22 RATE_AMOUNT Number(11,4) DECIMAL(10,4) NOT NULL Rate Amount
23 RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Rate Per
HR=Hourly
UN=Per Unit
24 OP_TIME_RATE Number(9,2) DECIMAL(8,2) NOT NULL Operation Time/Rate
25 OP_TIME_RATE_UNIT Character(2) VARCHAR2(2) NOT NULL Operation Time/Rate Unit
DY=Days
HR=Hours
MN=Minutes
UD=Units per Day
UH=Units per Hour
UM=Units per Minute
26 OVERHEAD_RATE Number(11,4) DECIMAL(10,4) NOT NULL Conversion Overhead Rate
27 OVERHEAD_PERCENT Number(5,1) DECIMAL(4,1) NOT NULL Conversion Overhead %
28 OH_RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Conversion Ovhd Rate Type
%L=% of Labor Amt
%M=% of Mach Amt
PL=Amt Per Labor Hr
PM=Amt Per Mach Hr
PU=Per Unit Amt
29 OH_LAB_MACH_AMT Signed Number(12,4) DECIMAL(10,4) NOT NULL Lab/Mach Amt for Ovhd Cal
30 EARN_COST_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Earned Cost Quantity
31 PRORATE_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Maximum Quantity
32 PERCENT_COMP Number(6,2) DECIMAL(5,2) NOT NULL Scrap Prdn Pct
33 DAILY_CAPACITY Number(5,2) DECIMAL(4,2) NOT NULL Average Daily Hours
34 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
35 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
36 PRDN_SPLIT_FLG Character(1) VARCHAR2(1) NOT NULL 02/26/99 SCC CN#SF800-9.0: New field.
37 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
A=Purge All
S=Only purge items with at least
38 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
39 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
40 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
42 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
43 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
44 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple