PO_ACTIVITY_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
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_RECV	Character(5)	VARCHAR2(5) NOT NULL	Receiving Business Unit
6	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
7	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
8	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
9	RECV_SHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Schedule Status C=Closed H=Hold O=Open R=Received X=Canceled Default Value: O
10	QTY_SH_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accept QTY in Supplier UOM
11	QTY_SH_RECVD_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt QTY in Supplier UOM
12	QTY_SH_REJCT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Reject QTY in Supplier UOM
13	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
14	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
15	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
16	AMT_INVOICED	Number(27,3)	DECIMAL(26,3) NOT NULL	Amount Invoiced
17	QTY_INVOICED	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Quantity Invoiced
18	QTY_MATCHED	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity Matched
19	MATCHED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount Matched
20	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
21	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code