VENDOR_SETIDVENDOR_IDBUSINESS_UNIT_POPO_IDVCHR_PO_VW1(SQL View) |
Index Back |
|---|---|
Voucher PO Header Prompt |
| SELECT a.vendor_setid , b.vendor_id , a.business_unit , a.po_id , a.po_dt , b.name1 , a.origin , a.pymnt_terms_cd FROM PS_PO_HDR_FS a , ps_vendor b WHERE a.vendor_setid = b.setid AND a.vendor_id = b.vendor_id AND ((a.po_status IN ('D','X','PX')) OR ((a.chng_ord_batch > 0) AND (a.po_status IN ('D','X','PX'))) OR ((a.po_status = 'C') AND (a.match_action = 'N'))) AND a.ers_action = 'N' AND a.in_process_flg = 'N' AND a.match_status_po IN ('T','P','N') AND a.mid_roll_status = 'N' AND A.BUDGET_HDR_STATUS = 'V' AND A.BUDGET_HDR_STS_NP = 'V' AND A.CC_USE_FLAG IN ('N',' ') AND EXISTS ( SELECT 'X' FROM PS_PO_LINE_DIST_FS WHERE BUSINESS_UNIT = A.BUSINESS_UNIT AND PO_ID = A.PO_ID AND DST_ACCT_TYPE = 'DST' AND KK_CLOSE_FLAG <> 'Y') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 2 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 3 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 4 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | PO_DT | Date(10) | DATE | Date |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 8 | 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. |