CM_NP_SFOHST_VW (SQL View)	Index Back
SF_OP_HIST pending rows pending costing with calculate production cost option selected

CM_NP_SFOHST_VW

(SQL View)

SF_OP_HIST pending rows

pending costing with calculate production cost option selected

SELECT A.BUSINESS_UNIT , C.CM_BOOK , %DatePart(A.DT_TIMESTAMP) , A.PRODUCTION_ID , A.DT_TIMESTAMP , A.OP_SEQUENCE , A.SEQ_NBR , ' ' , ' ' , 0 , %Substring(B.MESSAGE_TEXT, 1,50) , A.PRDN_AREA_CODE , A.INV_ITEM_ID , A.PRDN_DUE_DATE , A.PRDN_DUE_SHIFT , A.COMPL_QTY , A.SCRAPPED_QTY , A.CE_POSTED_FLAG , 0 , ' ' , %DateNull , %TimeNull , ' ' , ' ' FROM PS_SF_OP_HIST A , PSMSGCATDEFN B , PS_CM_BU_BOOK_TBL C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND C.CM_BOOK_STATUS = 'A' AND A.CE_POSTED_FLAG = 'N' AND B.MESSAGE_SET_NBR = 15500 AND B.MESSAGE_NBR = 212

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUMGOP_NONVW

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
Prompt Table: CM_BU_BOOK_TBL

3 TRANSACTION_DATE Date(10) DATE Transaction Date

4 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
Prompt Table: %EDITTABLE

5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

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

8 CE_COST_TYPE Character(4) VARCHAR2(4) NOT NULL Cost Type

9 COST_VERSION Character(10) VARCHAR2(10) NOT NULL Cost Version
Prompt Table: CE_VERSION5_VW

10 COST_SEQ Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number

11 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50

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 PRDN_DUE_DATE Date(10) DATE Prdn Due Date

15 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift

16 COMPL_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty

17 SCRAPPED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Scrapped Qty

18 CE_POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posted
6=Cost for 661
N=Cost Pending Calculation
Y=Cost Calculated
Default Value: N

19 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

21 TRANS_DATE Date(10) DATE Transaction Date

22 TRANS_TIME Time(15) TIMESTAMP Transaction Time

23 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUMGOP_NONVW
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book Prompt Table: CM_BU_BOOK_TBL
3	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
4	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID Prompt Table: %EDITTABLE
5	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
6	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
7	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
8	CE_COST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Cost Type
9	COST_VERSION	Character(10)	VARCHAR2(10) NOT NULL	Cost Version Prompt Table: CE_VERSION5_VW
10	COST_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number
11	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
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	PRDN_DUE_DATE	Date(10)	DATE	Prdn Due Date
15	PRDN_DUE_SHIFT	Signed Number(2,0)	DECIMAL(1) NOT NULL	Prdn Due Shift
16	COMPL_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Completed Qty
17	SCRAPPED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Scrapped Qty
18	CE_POSTED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Posted 6=Cost for 661 N=Cost Pending Calculation Y=Cost Calculated Default Value: N
19	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
20	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
21	TRANS_DATE	Date(10)	DATE	Transaction Date
22	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time
23	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
24	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.