CM_NP_DEPN1_VW (SQL View)	Index Back
Pending CM_DEPN rows (110)

CM_NP_DEPN1_VW

(SQL View)

Pending CM_DEPN rows (110)

SELECT A.BUSINESS_UNIT , A.CM_BOOK , %DatePart(A.DT_TIMESTAMP) , A.INV_ITEM_ID , A.TRANSACTION_GROUP , A.DT_TIMESTAMP , %Substring(B.MESSAGE_TEXT, 1, 50) , A.POSTED_FLAG , A.SEQ_NBR , %DateTimeNull , 0 , %DateTimeNull , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , 0 , ' ' , ' ' , 0 , 0 , A.PROCESS_INSTANCE , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , 0 , A.PRODUCTION_ID , 0 , ' ' , %DateNull , %TimeNull , ' ' , ' ' FROM PS_CM_DEPLETION A , PSMSGCATDEFN B WHERE A.POSTED_FLAG = 'N' AND A.MESSAGE_NBR = 110 AND B.MESSAGE_SET_NBR = 15500 AND B.MESSAGE_NBR = 185

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

3 TRANSACTION_DATE Date(10) DATE Transaction Date

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

5 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.

6 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

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

8 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

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

10 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.

11 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

12 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.

13 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

14 CM_SEQ_VARIANCE Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:

15 FROM_PRDN_ID Character(10) VARCHAR2(10) NOT NULL From Production ID

16 TO_PRDN_ID Character(10) VARCHAR2(10) NOT NULL To Production ID

17 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit

18 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

19 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

20 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

21 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

22 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.

23 MISC_CHARGE_CODE Character(10) VARCHAR2(10) NOT NULL 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

24 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

25 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

26 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

27 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

28 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

29 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

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

31 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

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

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

34 TRANS_DATE Date(10) DATE Transaction Date

35 TRANS_TIME Time(15) TIMESTAMP Transaction Time

36 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

37 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
2	CM_BOOK	Character(10)	VARCHAR2(10) NOT NULL	Cost Book
3	TRANSACTION_DATE	Date(10)	DATE	Transaction Date
4	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
5	TRANSACTION_GROUP	Character(3)	VARCHAR2(3) NOT NULL	11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
6	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
7	DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description of length 50
8	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
9	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
10	CM_DT_TIMESTAMP_A	DateTime(26)	TIMESTAMP	07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
11	CM_SEQ_NBR_A	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
12	CM_DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Receipt dttm.
13	CM_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
14	CM_SEQ_VARIANCE	Number(15,0)	DECIMAL(15) NOT NULL	07/99 GMG CN800-9.0:
15	FROM_PRDN_ID	Character(10)	VARCHAR2(10) NOT NULL	From Production ID
16	TO_PRDN_ID	Character(10)	VARCHAR2(10) NOT NULL	To Production ID
17	BUSINESS_UNIT_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
18	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
19	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
20	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
21	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
22	CM_SEQ_COST	Number(15,0)	DECIMAL(15) NOT NULL	Cost Sequence Number. Incremented each time the actual cost is updated.
23	MISC_CHARGE_CODE	Character(10)	VARCHAR2(10) NOT NULL	10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
24	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
25	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
26	RTV_DISTRIB_NUM	Number(5,0)	INTEGER NOT NULL	RTV Distribution Number
27	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
28	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
29	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
30	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
31	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
32	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
33	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
34	TRANS_DATE	Date(10)	DATE	Transaction Date
35	TRANS_TIME	Time(15)	TIMESTAMP	Transaction Time
36	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
37	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.