IN_SDWC_PEGDTVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
2	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
3	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
4	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
5	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
6	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
7	HDR_HASH	Character(28)	VARCHAR2(28) NOT NULL	11/07/04 EGS: Created
8	PEG_HASH	Character(28)	VARCHAR2(28) NOT NULL	07/29/04 EGS: Created
9	PEG_ORDER_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Used by Pegging Maintenance/Inquiry 010=Purchase 020=Production 030=Transfer Demand 035=Transfer Supply 070=Stock Request 090=Sales Order 100=Requisition 110=WO Inventory 115=WO Non-Inventory
10	PEG_ORDER_KEY	Character(30)	VARCHAR2(30) NOT NULL	Used to store the various Order Number formats in 1 field
11	PEG_LINE_KEY	Character(30)	VARCHAR2(30) NOT NULL	Used to Store the concatenation of Line, Demand, Sched, Kit, etc in 1 field.
12	PEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	07/21/04 EGS: Created 10=Open 20=Completed 30=Canceled 40=Not Pegged
13	QTY_AVAILABLE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Available
14	BAD_PEG_QTY	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Bad Pegged Quantity
15	QTY_PEG_ORIG	Number(16,4)	DECIMAL(15,4) NOT NULL	10/28/04 EGS: Created
16	QTY_ORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	06/21/04 EGS: Created
17	QTY_PEG_REMAIN	Number(16,4)	DECIMAL(15,4) NOT NULL	10/28/04 EGS: Created
18	QTY_PEGGED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	06/16/04 EGS: Created.
19	NET_QTY_PEGGED	Number(16,4)	DECIMAL(15,4) NOT NULL	Net QTY Pegged
20	QTY_RECEIVED	Number(16,4)	DECIMAL(15,4) NOT NULL	Received Qty
21	QTY_COMPLETE	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Complete
22	QTY_COMPLETE_PEG	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Complete
23	QTY_PEND_RECV	Number(16,4)	DECIMAL(15,4) NOT NULL	Received Qty
24	PEG_FLAG	Character(1)	VARCHAR2(1) NOT NULL	06/17/04 EGS: Created. Default Value: N
25	SCHED_DATE	Date(10)	DATE	Schedule Date
26	SCHED_TIME	Time(15)	TIMESTAMP	Schedule Time
27	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
28	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
29	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID
30	HARD_PEG	Character(1)	VARCHAR2(1) NOT NULL	09/01/04 EGS: Created Y/N Table Edit Default Value: N
31	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
32	DEST_DMD_SRC	Character(2)	VARCHAR2(2) NOT NULL	07/29/04 EGS: Created
33	BUSINESS_UNIT_SUP	Character(5)	VARCHAR2(5) NOT NULL	07/29/04 EGS: Created
34	DEST_ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	07/29/04 EGS: Created
35	DEST_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	07/29/04 EGS: Created
36	DEST_SCHED_NBR	Number(6,0)	INTEGER NOT NULL	07/29/04 EGS: Created
37	DEST_DMD_LINE	Number(4,0)	SMALLINT NOT NULL	07/29/04 EGS: Create
38	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
39	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
40	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
41	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
42	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
43	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
44	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
45	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
46	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
47	MG_OUTPUT_QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	01/28/98 (CN#EN800-6.0) LAJ...Created Stores the quantity code for an output item on a Bill of Materials. It was created with the same values as qty_code, but by separating these two fields, it allows greater flexibility in the future. ASY=Assembly ORD=Order
48	WO_ID	Character(10)	VARCHAR2(10) NOT NULL	Work Order Identification
49	WO_TASK_ID	Number(5,0)	INTEGER NOT NULL	Task Number
50	RES_LN_NBR	Number(5,0)	INTEGER NOT NULL	Resource Line No.
51	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes
52	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
53	PEG_TRANS_LINK	Character(1)	VARCHAR2(1) NOT NULL	11/09/04 EGS: Created
54	PEG_CHANGE	Character(1)	VARCHAR2(1) NOT NULL	11/19/04 EGS: Created Y/N Table Edit Default Value: N
55	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
56	CHECK_PUTAWAY	Character(1)	VARCHAR2(1) NOT NULL	Check For Putaway
57	QTY_PEGGED_ORD	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	06/16/04 EGS: Created.
58	SHIP_FROM_BU	Character(5)	VARCHAR2(5) NOT NULL	Ship from INV BU
59	DOC_ID	Character(50)	VARCHAR2(50) NOT NULL	ID
60	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
61	QTY_SCHEDULED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Scheduled
62	SCHED_SHIP_DATE	Date(10)	DATE	Scheduled Ship Date
63	SSRC_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Supply Source business unit
64	UNIT_MEASURE_ORD	Character(3)	VARCHAR2(3) NOT NULL	Ordering UOM
65	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure