VENDOR_SETIDVENDOR_IDBUSINESS_UNIT_POPO_IDVCHR_PO_NM_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 ('X','PX') OR a.match_status_po = 'M') AND a.ers_action = 'N' AND a.in_process_flg = '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') AND NOT EXISTS ( SELECT 'X' FROM PS_RECV_LN_SHIP_FS F WHERE F.BUSINESS_UNIT_PO = A.BUSINESS_UNIT AND F.PO_ID = A.PO_ID AND F.SERIAL_CONTROL = 'Y' AND F.SERIAL_STATUS = 'I' AND F.recv_ship_status <> 'X') |
| # | 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. |