IN_SDWC_PO_VW(SQL View) |
Index Back |
---|---|
PO Past Due DateRecord 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 |