S360_VND_PO_VW

(SQL View)
Index Back

S360 Supplier PO transaction

S360 Supplier PO transaction

SELECT DISTINCT ' ' , A.BUSINESS_UNIT , A.VENDOR_ID , A.VENDOR_SETID , A.PO_ID , 'PO' , A.PO_DT , A.PO_STATUS , A.BUYER_ID , A.BUDGET_HDR_STATUS , A.PO_REF , A.HOLD_STATUS , A.ORIGIN FROM PS_PO_HDR A WHERE A.VENDOR_ID <> ' ' AND A.VENDOR_SETID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 PRCR_DOC_ID Character(25) VARCHAR2(25) NOT NULL Document ID
6 PRCR_DOC_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
CNT=Contract
IUR=Inter Unit Receipt
MSR=MSR
PMT=Payment
PO=Purchase Order
RCV=Receipt
REQ=Requisition
RFQ=Request For Quote
RTV=Return To Vendor (Supplier)
SSE=Strategic Sourcing Event
VOU=Voucher
WO=Work Order
7 DOCSTAT_DATE Date(10) DATE Document Date
8 STATUS_FIELD Character(30) VARCHAR2(30) NOT NULL Payment Status
9 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
10 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
11 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
12 HOLD_STATUS Character(1) VARCHAR2(1) NOT NULL Hold From Further Processing
13 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin