CNTRCT_EVT_WS2

(SQL Table)
Index Back

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 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
21 INVOICE_DT Date(10) DATE Invoice Date
22 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
23 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency