AP_VCHR_KK_VW

(SQL View)
Index Back

Budget Check Voucher Line


SELECT DISTINCT BUSINESS_UNIT , VOUCHER_ID , INVOICE_ID , INVOICE_DT , VENDOR_ID FROM PS_VOUCHER WHERE BUDGET_HDR_STATUS <> 'V' AND ENTRY_STATUS <> 'X' AND APPR_STATUS IN ('A','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
4 INVOICE_DT Date(10) DATE Invoice Date
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier