SCP_ACKPODIN_FL

(SQL View)
 Index Back

PO List W/O Vouchers DueIn

Used for POA Tile SCP_ACKPOLST_FL with 4 additional fields to Due-In calculation

SELECT DISTINCT A.PO_ID , A.PO_DT , A.DATETIME_DISP , MIN(C.DUE_DT) , A.PO_STATUS , A.VENDOR_ID , A.BUSINESS_UNIT , A.VENDOR_SETID , A.BUYER_ID , A.PYMNT_TERMS_CD , A.RECV_STATUS , A.BILL_LOCATION , A.VENDOR_SETID , A.VNDR_LOC , A.CHNG_ORD_BATCH ,A.CURRENCY_CD , A.PO_POA_STATUS , B.POA_STATUS , B.PO_REF , A.PO_ACK_SOURCE ,0 ,'' ,0 ,0 FROM PS_PO_POA_SRC_VWFL A , PS_PO_HDR B , PS_PO_LINE_SHIP C WHERE A.VENDOR_ID = B.VENDOR_ID AND A.VENDOR_SETID= B.VENDOR_SETID AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID =B.PO_ID AND A.RECV_STATUS IN ('N', 'O', 'P', 'H', 'R') AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PO_ID =B.PO_ID GROUP BY A.PO_ID , A.PO_DT , A.DATETIME_DISP , A.PO_STATUS , A.VENDOR_ID , A.BUSINESS_UNIT , A.VENDOR_SETID , A.BUYER_ID , A.PYMNT_TERMS_CD , A.RECV_STATUS , A.BILL_LOCATION , A.VENDOR_SETID , A.VNDR_LOC , A.CHNG_ORD_BATCH ,A.CURRENCY_CD , A.PO_POA_STATUS , B.POA_STATUS , B.PO_REF, A.PO_ACK_SOURCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
2 PO_DT Date(10) DATE Date
3 DATETIME_DISP DateTime(26) TIMESTAMP Date and Time Dispatched
4 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.
5 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
8 SETID Character(5) VARCHAR2(5) NOT NULL SetID
9 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
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 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled
12 BILL_LOCATION Character(10) VARCHAR2(10) NOT NULL Billing Location
13 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
14 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
15 CHNG_ORD_BATCH Number(3,0) SMALLINT NOT NULL Change Order Number
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
17 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
BAC=Buyer Accepted
CMP=EDX compare needed
NEW=New
SRP=Supplier Responded
SRV=Supplier Review
18 POA_STATUS Character(2) VARCHAR2(2) NOT NULL po ack status field that will be on po_hdr.
AC=Acknowledged with changes
AK=Acknowledged
BA=Approved, Changes Pending
IN=Initial Dispatch Acknowledged
NR=Not Required
SR=Responded, Awaits Review
WD=Awaiting PO Dispatch
WR=Awaiting Acknowledgement
19 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
20 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer)
EDI=EDX
SUP=Online (Supplier)
21 SCP_POA_SIGN_NUM Signed Number(19,2) DECIMAL(17,2) NOT NULL Amount Multiplier
22 SCP_POA_DUEIN Character(30) VARCHAR2(30) NOT NULL Due In
23 SCP_POA_DUEIN_DAYS Signed Number(11,0) DECIMAL(10) NOT NULL Due In Days
24 SCP_POADUEIN_HOURS Number(5,0) INTEGER NOT NULL Due In Hours