PV_CONN_CHNG_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
3	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
4	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
5	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
6	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
7	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
8	DISPATCH_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Dispatch Flag Default Value: N
9	PO_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Purchase Order Line Number
10	PO_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	PO Schedule Number
11	AMT_ONLY_FLG_PO	Character(1)	VARCHAR2(1) NOT NULL	Amount Only PO
12	SCHED_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Notifications Enabled - Active/Inactive 1=Inactive 2=Active
13	QTY_PO	Number(16,4)	DECIMAL(15,4) NOT NULL	Purchase Order Quantity
14	MATCH_STATUS_LN_PO	Character(1)	VARCHAR2(1) NOT NULL	Match Status PO M=Matched N=Not Matched P=Partially Matched
15	QTY_REQ_SRCD	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
16	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
17	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
18	AMT_OPEN	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Open Amount
19	QTY_REQ	Number(16,4)	DECIMAL(15,4) NOT NULL	Requisition Quantity
20	QTY_OPEN	Number(16,4)	DECIMAL(15,4) NOT NULL	Open Quantity
21	MERCH_AMT_RECV	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amount Received
22	QTY_SH_NETRCV_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Net Receipt Quantity
23	QTY_SH_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accepted Quantity
24	AMT_MATCHED	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amt Matched
25	QTY_MATCHED	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Matched
26	MULTIPLE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Multiple Values per Attr Default Value: N