BUSINESS_UNIT_POPO_IDVCHR_TP_PO_VW2(SQL View) |
Index Back |
|---|---|
Voucher PO Header Prompt |
| SELECT a.business_unit , a.po_id , a.po_dt , b.vendor_id , a.vendor_setid , b.name1 , a.origin , a.pymnt_terms_cd , a.currency_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 ('A','PA','O'))) OR ((a.po_status = 'C') AND (a.match_action = 'N'))) AND a.ers_action = 'N' AND a.in_process_flg = 'N' AND A.CC_USE_FLAG IN ('N',' ') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | PO_DT | Date(10) | DATE | Date |
| 4 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 5 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 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. |
| 9 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |