PO_POOVERDUE_VW

(SQL View)
 Index Back

PO Overdue Schedules


SELECT A.BUSINESS_UNIT , A.BUYER_ID , A.BUYER_DESCR , A.NAME1 , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.INV_ITEM_ID , A.DESCR254_MIXED , A.CATEGORY_CD , A.DUE_DT , A.TOTAL_AMOUNT , A.CURRENCY_CD , A.SHIPTO_ID , A.COUNT_ORDERS , A.DAYS_NUM , A.WEEK_NUM , A.MONTH_NUM , A.MONTH_CHAR , A.YEAR FROM PS_PO_OVERDUE1_VW A UNION ALL SELECT B.BUSINESS_UNIT , B.BUYER_ID , B.BUYER_DESCR , B.NAME1 , B.PO_ID , B.LINE_NBR , B.SCHED_NBR , B.INV_ITEM_ID , B.DESCR254_MIXED , B.CATEGORY_CD , B.DUE_DT , B.TOTAL_AMOUNT , B.CURRENCY_CD , B.SHIPTO_ID , B.COUNT_ORDERS , B.DAYS_NUM , B.WEEK_NUM , B.MONTH_NUM , B.MONTH_CHAR , B.YEAR FROM PS_PO_OVERDUE2_VW B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

2 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
3 BUYER_DESCR Character(30) VARCHAR2(30) NOT NULL Buyer Desc
4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 CATEGORY_CD Character(18) VARCHAR2(18) NOT NULL Category Code
11 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.
12 TOTAL_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Total Amount
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
15 COUNT_ORDERS Number(15,0) DECIMAL(15) NOT NULL Order Count
16 DAYS_NUM Number(6,0) INTEGER NOT NULL Days Late
17 WEEK_NUM Number(6,0) INTEGER NOT NULL This is the week number
18 MONTH_NUM Number(6,0) INTEGER NOT NULL Months Late
19 MONTH_CHAR Character(15) VARCHAR2(15) NOT NULL Month
20 YEAR Character(4) VARCHAR2(4) NOT NULL Year
1=NONE