SCP_OVRDUE1H_VW(SQL View) |
Index Back |
---|---|
PO's with Overdue SchedulesSupplier PO's with Overdue Schedules 1 |
SELECT DISTINCT A.BUSINESS_UNIT_PO , A.BUYER_ID , A.PO_ID , A.PO_DT , A.PO_STATUS , A.VENDOR_ID , A.PYMNT_TERMS_CD , A.RECV_STATUS , A.BILL_LOCATION , A.CHNG_ORD_BATCH , A.VENDOR_SETID , A.VNDR_LOC , A.CURRENCY_CD FROM PS_SCP_RCVPOSHP_VW A WHERE A.DUE_DT < %CurrentDateIn AND EXISTS ( SELECT 'X' FROM PS_PO_LINE L , PS_VENDOR V , PS_PO_OPRDEFN_VW D WHERE A.BUSINESS_UNIT_PO = L.BUSINESS_UNIT AND A.PO_ID = L.PO_ID AND A.LINE_NBR = L.LINE_NBR AND A.VENDOR_SETID = V.SETID AND A.VENDOR_ID = V.VENDOR_ID AND A.BUYER_ID = D.OPRID AND L.RECV_REQ = 'Y' ) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |
3 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
4 | PO_DT | Date(10) | DATE | Date |
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 | 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. |
8 | 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 |
9 | BILL_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Billing Location |
10 | CHNG_ORD_BATCH | Number(3,0) | SMALLINT NOT NULL | Change Order Number |
11 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
12 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |