PO_SSPOLN_WS

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO 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 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
5 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
6 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
9 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
10 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
13 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
14 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
16 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
17 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
18 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
19 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
20 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
21 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
22 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
23 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
24 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number