PO_SSPO_ALL_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , C.CHNG_ORD_BATCH , C.PO_DT , C.VENDOR_SETID , C.VENDOR_ID , C.VNDR_LOC , C.PYMNT_TERMS_CD , C.BUYER_ID , B.CANCEL_STATUS , B.ITM_SETID , B.INV_ITEM_ID , B.ITM_ID_VNDR , B.VNDR_CATALOG_ID , B.CATEGORY_ID , B.MFG_ID , B.MFG_ITM_ID , B.CNTRCT_ID , B.VERSION_NBR , B.CNTRCT_LINE_NBR , B.CAT_LINE_NBR , B.RELEASE_NBR , B.DESCR254_MIXED , B.UNIT_OF_MEASURE , A.CANCEL_STATUS , A.PRICE_PO , A.DUE_DT , A.SHIPTO_ID , A.QTY_PO , A.MERCHANDISE_AMT , A.CURRENCY_CD , A.FREIGHT_TERMS , A.SHIP_TYPE_ID , A.REVISION FROM PS_PO_LINE_SHIP_FS A , PS_PO_LINE_FS B , PS_PO_HDR_FS C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID

# 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 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
6 PO_DT Date(10) DATE Date
7 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
8 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
9 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
10 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
11 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
12 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
13 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
16 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
17 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
18 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
19 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item 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
25 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
26 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
27 CANCEL_STATUS_SHIP Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
H=Hold
X=Canceled
28 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
29 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
30 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
31 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
32 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
33 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
34 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
35 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
36 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label