PO_CANCEL_WK4

(SQL Table)
Index Back

Temp Table used in PO Cancel

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
8 QTY_REQ Number(16,4) DECIMAL(15,4) NOT NULL Requisition Quantity
9 QTY_REQ_STD Number(16,4) DECIMAL(15,4) NOT NULL Quantity Requested Stand. UOM
10 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
11 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate
12 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
13 AMT_OPEN Signed Number(28,3) DECIMAL(26,3) NOT NULL Open Amount
14 AMT_OPEN_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount Open Base
15 BUSINESS_UNIT_REQ Character(5) VARCHAR2(5) NOT NULL Requesting Business Unit
16 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
17 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number
18 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number
19 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number