VCHR_PO_VW3(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')) OR ((a.chng_ord_batch > 0) AND (a.po_status IN ('D','X')))) 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') AND EXISTS( SELECT 'X' FROM PS_PO_LINE_FS PO_LN WHERE PO_LN.BUSINESS_UNIT = A.BUSINESS_UNIT AND PO_LN.PO_ID = A.PO_ID AND PO_LN.PO_GROUP_ID = ' ' AND PO_LN.cancel_status <> 'X') |
# | 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 |