IN_SDWC_PO_VW

(SQL View)
Index Back

PO Past Due Date

Record used by Query to populate EOEN context record.

SELECT %subrec(IN_PO_NKEY_SBR, D) , D.DUE_DT , D.BUSINESS_UNIT_IN , D.IN_SDWC_HASH_KEY FROM PS_IN_SDWC_PO_1_VW D WHERE NOT EXISTS ( SELECT B.BUSINESS_UNIT_IN FROM PS_IN_SDWC_PO_CTX B , PS_EOEN_DASHBRD C WHERE B.BUSINESS_UNIT = D.BUSINESS_UNIT AND B.PO_ID = D.PO_ID AND B.LINE_NBR = D.LINE_NBR AND B.SCHED_NBR = D.SCHED_NBR AND B.DST_ACCT_TYPE = D.DST_ACCT_TYPE AND B.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND B.EOEN_PRCS_NAME = C.EOEN_PRCS_NAME AND B.EOEN_CATEGORY = C.EOEN_CATEGORY AND B.SEQ_NBR_EOEN = C.SEQ_NBR_EOEN AND C.EOEN_STATUS = '0')

# 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 DST_ACCT_TYPE Character(4) VARCHAR2(4) NOT NULL 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment
6 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
7 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.
8 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit
9 IN_SDWC_HASH_KEY Character(60) VARCHAR2(60) NOT NULL Hash